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: Wednesday, November 5, 2014 4:54 AM
Points: 611, Visits: 1,149
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: Thursday, September 25, 2014 9:01 PM
Points: 1,113, Visits: 705
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:06 AM
Points: 2,268, Visits: 3,425
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)

Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
Post #1386607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse