Jeff Moden (12/15/2008)

---

rbarryyoung (12/15/2008)

---

Lynn Pettis (12/15/2008)

---

Jeff Moden (12/15/2008)

---

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite...

Nooooo. I do all my venting after the game is over and I am away from the pitch and the offending individuals. Other refs are good to have...

Jeff Moden (12/15/2008)

---

Lynn Pettis (12/15/2008)

---

Jeff Moden (12/15/2008)

---

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the...

Jeff Moden (12/15/2008)

---

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman in explaining the...

Well, it was either this, or watch a recorded episode of Ghost Hunters for th umpteenth time while waiting for my middle daughter to call me to come pick her...

Well, call me a softy, but I gave him something to work with. Hope it takes the comments to heart and takes the time to provide us with more...

Although I thought I'd not bother with this either, I decided to at least provide you with one solution.

I have also taken the time to create the scripts that you...

david.c.holley (12/14/2008)

---

If I could write the T-SQL then I'd post it. I am presented the data as it exists in the tables and as I need it displayed. Either help...

Michael Artz (12/15/2008)

---

OK seems I'm more of a newb than anyone realises (even me)

the "UI" i was referring to was within visual web developer ..... i havent found any other...

OR, using the OUTPUT clause of the delete, you could delete from the audit tables and load the deleted records to stage tables that would make exporting the data with...

You should know that SQL Server 2005 Enterprise Edition and SQL Server 2005 Developer Edition are equivalent, just different licensing (Developer Edition can't be used in a production environment).

Not enough information. It would help to see the code, the DDL for the tables including defined indexes, and the execution plans for the queries.

You can use the UI to create the table create scripts for you. Right click on the table and go from there. Remember, we need to be able...

You would use a scheduled job to perform the archive process. Start by looking up SQL Server Agent in Books Online.

And, yes, if the trigger fails, the insert that triggered the insert will also fail.