I think it is lass wasteful of people's time, and you would get better responses by asking a detailed question in a new thread instead of latching on to a...

Since the original post is 11 months old, with no follow up, I would think a solution has been found.

Maybe explain why you want to do it, and there might be a better solution.

OK, I retract my reply.

Tara should consider the valid concerns listed.

sp_msforeachdb

Sounds like you have 2 different machines ?? You're not upgrading an existing machine from 2000...

Are you trying to rebuild the indexes through the GUI ? You will have better performance if you script out the code, then run it as a job. ...

You would probably be better served by starting a new thread rather than add to a 4 year old thread.

loki1049 (12/22/2010)

---

There is no exclamation mark. This is a view of a table not a query. I know in SQL Management studio 2008 the view into a table is actaully...

Would the default trace files be of use to at least get some information about what heppened between 12:00 and 4:00 ?

Learn about the different recovery models:

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

http://msdn.microsoft.com/en-us/library/aa173531(v=sql.80).aspx

I used this when looking for a phone number. I already knew which column to look in. If you don't know which column might have it, then I guess you...

Be thankful you only lost 4 hours, and put proper disaster procedures in place for next time.

I'm not familiar with that tool. I use SQL profiler to open the .trc file

premkuttan.lakshmanan (12/15/2010)

---

in sp_who2 the coressponding blkby for spid 101 is 101 and in the corresponding command column it shows as killed/Rollback . Does it mean that the activity is getting...