GSquared,

So after hours of fiddling with this and comparing your sample to mine I have found the problem or reason why yorus works and mine doesn't. The bottom line...

FYI - I fiugured it out. WHile the CREATE AND DROP TABLE DDL's can be caught with the same Event and COlumns as DROP VIEW, you aprently have to...

GSquared,

Would you mind posting the DDL to create the DDLLog tabel you're using in your examples? I still can;t get mine to work even though yours does but I...

GSquared (10/28/2010)

---

Actually, if you look, you'll notice that my trigger uses the EventData() function. I just log the whole XML blob, instead of parsing it in the trigger.

Part of...

Thanks GSquared for replying; your answer has made me realize a key piece of the puzzle was left out of my initial post and thats because I did not relaize...

I'm trying to provide additional material/refereneces to the IT guys about why this is a bad idea because when something does not work right because of this it will be...

GSquared (10/22/2010)

---

It'll take as long as whatever you have the trigger do takes.

If, for example, the trigger just immediately returns, then it'll take microseconds.

If, for example, the trigger writes a...

GSquared (10/21/2010)

---

I'm not sure how an Instead of Delete trigger would know to run (actually delete stuff) the first time and not run in subsequent calls, without potentially complex "mutex"...

Steve-3_5_7_9 (10/14/2010)

---

I don't know much about DPM. I did find this at social.msdn.microsoft.com

===

"DPM takes VDI backups not native backup. Full backups would not hurt, log backups would."

===

so it looks...

Steve-3_5_7_9 (10/14/2010)

---

Replication probably wouldn't work in this scenario, nor mirroring. Log shipping might work for you but that involves the FULL backup and T-Log backups.

Personally, I would still take...

Ross McMicken (10/14/2010)

---

Does the data have to go over the wire, or could you just buy a few 1TB USB drives and send them back and forth? Sending a few...

First off thanks to everyone for the suggestions. I wasn't expecting but maybe 1 or 2 and of that probably not anything I could implment because of various restrictions....

Sorry to waste everyones time on this but the problem was user/tech error. Thats what I get for not doing it myself.

Gail,

Well it is a restore from a backup but not a native SQL Backup. We use DPM (from Microsoft) and so the normal laws of the SQL World seem...

I did not Gail but I do now. Thanks. I knew it was a dumb question. It would be...