﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General  / Which information can i log when i use Change Data Capture / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sun, 19 May 2013 17:49:17 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Which information can i log when i use Change Data Capture</title><link>http://www.sqlservercentral.com/Forums/Topic1060059-391-1.aspx</link><description>[quote][b]ocolakoglu (2/8/2011)[/b][hr]Hi When i use change data capture can i log hostname,username information?[/quote]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.</description><pubDate>Mon, 19 Nov 2012 15:23:01 GMT</pubDate><dc:creator>ScottPletcher</dc:creator></item><item><title>RE: Which information can i log when i use Change Data Capture</title><link>http://www.sqlservercentral.com/Forums/Topic1060059-391-1.aspx</link><description>[quote][b]ocolakoglu (2/8/2011)[/b][hr]Hi When i use change data capture can i log hostname,username information?[/quote]Simply put: No.The information is not available, due to the way CDC works. </description><pubDate>Mon, 19 Nov 2012 08:18:19 GMT</pubDate><dc:creator>Adam Machanic</dc:creator></item><item><title>RE: Which information can i log when i use Change Data Capture</title><link>http://www.sqlservercentral.com/Forums/Topic1060059-391-1.aspx</link><description>Hi..Go through this linkhttp://www.sqlservercentral.com/articles/Change+Data+Capture+(CDC)/64289/</description><pubDate>Tue, 08 Feb 2011 02:41:53 GMT</pubDate><dc:creator>Junglee_George</dc:creator></item><item><title>Which information can i log when i use Change Data Capture</title><link>http://www.sqlservercentral.com/Forums/Topic1060059-391-1.aspx</link><description>Hi When i use change data capture can i log hostname,username information?</description><pubDate>Tue, 08 Feb 2011 00:55:54 GMT</pubDate><dc:creator>ocolakoglu</dc:creator></item></channel></rss>