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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply