Which information can i log when i use Change Data Capture

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Which information can i log when i use Change...

Which information can i log when i use Change Data Capture

Rate Topic

Display Mode

Topic Options

Author

Message

ocolakoglu

Posted Tuesday, February 08, 2011 12:55 AM

Grasshopper

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

Junglee_George

Posted Tuesday, February 08, 2011 2:41 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, April 05, 2013 1:04 AM
Points: 471, Visits: 547

Hi..
Go through this link

http://www.sqlservercentral.com/articles/Change+Data+Capture+(CDC)/64289/

Post #1060088

Adam Machanic

Posted Monday, November 19, 2012 8:18 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:20 PM
Points: 1,137, Visits: 667

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

ScottPletcher

Posted Monday, November 19, 2012 3:23 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 1,324, Visits: 1,778

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)
One man with courage makes a majority. Andrew Jackson

Post #1386607

« Prev Topic | Next Topic »

Permissions