Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Which information can i log when i use Change Data Capture Expand / Collapse
Author
Message
Posted Tuesday, February 8, 2011 12:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 2:26 AM
Points: 15, Visits: 120
Hi
When i use change data capture can i log hostname,username information?
Post #1060059
Posted Tuesday, February 8, 2011 2:41 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, July 31, 2015 1:07 AM
Points: 636, Visits: 1,221
Hi..
Go through this link

http://www.sqlservercentral.com/articles/Change+Data+Capture+(CDC)/64289/
Post #1060088
Posted Monday, November 19, 2012 8:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, May 3, 2015 2:03 PM
Points: 1,113, Visits: 713
ocolakoglu (2/8/2011)
Hi
When 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
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #1386423
Posted Monday, November 19, 2012 3:23 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:41 PM
Points: 3,033, Visits: 4,641
ocolakoglu (2/8/2011)
Hi
When 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)

"If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them." James Blackburn, in closing argument in the "Fatal Vision" murders trial
Post #1386607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse