When I started working with databases, I found Books Online, MSDN, and even most books on the subject to be far too advanced. They assumed a lot of "you...

I have a couple of pieces of meta-code. As commented, the main one is one that will generate an audit trigger for a table.

I don't drink, but sleep deprivation has been an enemy of my productivity many, many times. And there have been times where I've told a boss that I needed...

And my point is that this way controls permissions whether it already...

The one I use is based on the articles I wrote on the subject. It won't work with your audit table structure.

I would probably do it more like this:

ALTER trigger [dbo].[Tier1_ChangeTracking] on [dbo].[Tier1] for insert, update

as

INSERT INTO Tier1_AUDIT (T1ID, T1Name, althline, ShortName, class, Alt_text, header, Description, Content,

BypassUrl, ButtonLoc, FrontPage, Live,...

Instead of scanning that table, I'd create a sub-table with just the ID (or other PK reference), and an "Ignored" datetime value. It would only include records that have...

david_wendelken (3/11/2010)

---

You are right, I could use alter if the object exists.

The whole point of "create or replace" is that I don't have to know, OR CARE, if the object...

That's me with 2 months worth...

Roy Ernest (3/10/2010)

---

I used to play soccer... I was playing in the Midfield. I could take the ball fast to the opposition goal post but when I see the goal...

Alvin Ramard (3/10/2010)

---

GSquared (3/10/2010)

---

Nobody I know...

As promised a couple of months ago, I've updated to having a beard in my pic. 🙂

I'd have to see the rest of the trigger to tell you the best way to handle this, but you can detect deleted rows in a trigger because they exist...

Is there a particular reason to not use a job? It's going to be the easiest and most efficient way to handle this.

Nobody I know bothers to qualify...