Is it normal for the Batch_ID to be NULL in the Transaction Table?
Wanted to do some cleanup of Batch transactions - now I see that the attribute does not apparently get populated.....
(Makes it difficult to select the right ones...You Think?)
Is there a setting I missed?
SQL Server 2008 R2 SP1 CU3
You should upgrade to SQL Server 2012. It support the scenario of staging data in without effecting the transaction tables.
Thanks, Tomer (MSFT).
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?