Tag Info

New answers tagged

1

When you say, "without using triggers", do you mean any triggers or just row-by-row triggers on tables? I ask because you may be able to get what you want with judicious use of the CONTEXT_INFO() function, but you would need to ensure that SET CONTEXT_INFO was called correctly before your operations take place. One place to do that might be a ...


2

Please take a look at the connect bug: Below is the relevant snippet from it This behavior is by design. CDC is designed to expose the following information about a change: updated columns, type of operation and transaction information. It has not been designed as an audit solution. It has been created to enable efficient Extract Transfer and Load ...


3

I am not sure about CDC, but if the login has view server state permission you can use DMVs to get some information. This is given in Books Online here. I changed the query to add columns which would give you the IP address: SELECT c.session_id, c.net_transport, c.encrypt_option, c.auth_scheme, s.host_name, s.program_name, ...



Top 50 recent answers are included