February 8, 2011 at 12:55 am
Hi
When i use change data capture can i log hostname,username information?
February 8, 2011 at 2:41 am
November 19, 2012 at 8:18 am
ocolakoglu (2/8/2011)
HiWhen i use change data capture can i log hostname,username information?
Simply put: No.
The information is not available, due to the way CDC works.
--
Adam Machanic
whoisactive
November 19, 2012 at 3:23 pm
ocolakoglu (2/8/2011)
HiWhen i use change data capture can i log hostname,username information?
You can use any columns from the original table you want ... but that's it.
So to capture that other info using CDC you must first add it to the table row.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply