Unfortunately, EM in SQL Server 2000 doesn't allow you to script the restore command. The best thing I can do at this point is have you read RESTORE in...

Old SQL Newbie (12/16/2008)

---

Same here. I was a nurse...

Ian Massi (12/16/2008)

---

Interesting topic. I'd want to become a lumberjack. I'd sleep all night and I'd work all day... then again I do that now too. At...

Correct me if I am wrong, isn't table partitioning only available in Enterprise Edition? I thought I had read that somewhere, but I haven't had a chance to check....

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).