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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:34 AM
Points: 593, Visits: 1,083
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: Wednesday, July 30, 2014 9:28 PM
Points: 1,140, Visits: 702
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: Friday, August 29, 2014 2:25 PM
Points: 2,044, Visits: 3,059
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)
"In America, every man is innocent until proven broke!" Brant Parker
Post #1386607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse