Easiest way to do that is an audit table.

Here are the articles I wrote on the subject:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

Make sure to read through the discussions, as there's a lot of good data...

It looks like one before the import, and one after. The one after would have multiple steps in it.

Stefan Krzywicki (10/10/2011)

---

He's not scary! If worse comes to worse, buy him a beer after and all...

Grant Fritchey (10/10/2011)

---

GSquared (10/10/2011)

---

The computer is my friend.

The...

The semicolon is a statement terminator and can actually have an affect in terms of compilability of code (specifically with reference to Common Table Expressions), and is listed as "will...

The computer is my friend.

The computer wants me...

Lowell (10/10/2011)

---

GSquared (10/10/2011)

---

It depends on what you need to audit.

Are you just auditing the commands, or do you need to audit the actual data changes as well?

C2 will audit both,...

The ColumnProperty function doesn't work outside the scope of the current database.

You'll need to use it in-scope, which usually means dynamic SQL to build the query string with a "USE"...

It depends on what you need to audit.

Are you just auditing the commands, or do you need to audit the actual data changes as well?

C2 will audit both, but it...

They both will give you errors/warnings about the data, but Arithabort Off will give an error if you use it where it needs to be on.

So, yeah, you'll get more...

I already did. Please read my question and supply the data needed. I can probably help you, but I need more information from you in...

No such thing as a "Select Trigger" in SQL Server.

And they didn't include it specifically to force people who want it to buy the more expensive product. That and...

YOU'VE BEEN WARNED!!!

😀 😛 😛 😀

Changes to objects, you can audit via DDL triggers. Search "t-sql ddl trigger" and you'll get the articles on that.

Selects, you'll have to build your own audit solution. ...

Here's the link for the standard needed: http://msdn.microsoft.com/en-us/library/ms190306.aspx

As for why, it has to do with errors vs null values. Read the data I linked to, it'll probably make it...