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 @ 6:38 AM
Points: 594, Visits: 1,095
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: Saturday, September 13, 2014 8:37 AM
Points: 1,140, Visits: 703
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: Today @ 5:14 PM
Points: 2,083, Visits: 3,126
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)

"While in these days of quiet desperation /
As I wander through the world in which I live /
I search everywhere for some new inspiration /
But it's more than cold reality can give /
If I need a cause for celebration /
Or a comfort I can use to ease my mind /
I rely on my imagination /
And I dream of an imaginary time" : the inimitable Mr. Billy Joel
Post #1386607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse