sanjeev_krs2004 (12/15/2008)

---

HCan any of you guide me how to delete the transaction logs without accessing the database.

Rich Caine (12/10/2008)

---

How could I change the sub query above to get the highest DateCreated yet still return Versions.Ref (which I need in the emcompassing join)?

ps (12/15/2008)

---

Even if the database is online; since i'm restoring the primary filegroup, i need to put the database in single_user mode right?

ps (12/14/2008)

---

You can move those four tables in a different database file. take file/filegroup backup. You'll be able to restore them.

http://msdn.microsoft.com/en-us/library/ms189906.aspx

http://msdn.microsoft.com/en-us/library/ms179401.aspx

ganesha2181 (12/15/2008)

---

One of my site have a more than 41,000,00 data. Problem is i want to this data into 41 tables, per table i have a keep 1,000,00 data.

Gail, I think he needs to run 2nd SP for each Row.

Nicholas Cain (12/14/2008)

---

I am sure that there are far more elegant versions of this that would work with a simple convert, I just couldn't figure any out.

ps (12/14/2008)

---

You can also use cursors or Loop within the first SP and calling the 2nd SP for each rowset from within the cursor/loop.