Good article.  One thing to note - the INFORMATION_SCHEMA performance in some versions of SQL Server may be problematic in triggers.  When I first converted a system to the new...

• This reply was modified 5 years, 4 months ago by  Tore Bostrup-382308.

Interesting article. I took a slightly different approach when needing to delete almost 99.5% of rows from two tables with a total of 200 million rows between them. ...

Publishing the article as is (with advice that will lead beginners astray) is OK. Promoting it as the headline article in the daily email is somewhat of an editorial...

Lee, I presume you're working with a healtcare system or somewhere outside the US.

There may be some healthcare specific products out there.

Logically, capturing the "pipe" to (and from) the...

Actually, SQL Prompt uses column names to produce the ON suggestions, but if you don't have the relationships defined, you'll have to select the table to join to - but...

sp_recompile does NOT recompile UDF's. I'm not sure about views, but that should be easy to test.

Great article.

Also, SQL Prompt is great. For those who haven't already tried it - go ahead, you'll be hooked. Note: I am just a happy user.

Briefly described,...

OOPS, I forgot I couldn't use angle brackets in the text, so some explanatory "stuff" got lost in the trigger description:

INSERT INTO [Source Table Name]_Audit

...

Having an audit table for each original table makes it easier to work with the audit data. It helps avoid the problem of the audit table being a performance...

There are different ways of implementing Audit Logging. Before you start, you may Google a bit to see what tools may be available to help. You may find...

Cimode (2/26/2007) questions whether 3VL is useful.

Sure, NULL values complicate applications, because they...

We are using the technique with connection pooling (although a WinForms app) for user/application context information required for logging purposes (used in triggers).  By always setting the CONTEXT_INFO as part...