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) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them.