No everything else in SSMS works fine. But when I click on the activity monitor it just takes forever for the details to come back. It is slow at times...

After you install the new clustered instance, and you move the disk and rename the virtual server to original, and all file paths are the same.

The when you start...

You said you were keeping the SQL server 2005 and not upgrading it, so you would not have to restore you db's. The above reply was assuming you were moving...

Thanks for all the great info and the replys.

Just a quick question on your comment

"This virtual NIC is not liked by the SQL Server installation, which will complain and fail. You will need to "unteam" the NICs via...

Check this out, it may help.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Will this work for you?

select *

into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=D:\testing.xls;HDR=YES',

'SELECT * FROM [Sheet1$]')

Thanks, I'll check it out.

David Bird (7/31/2009)

---

Your question got my mind of thinking. I have tested the script on a Lab server to verify it would not blow up. Currently, we do not have...

Hey David., I know this is an old thread but I really liked your approach and have developed on top of yours. I had a question about drive spae and...

That's pretty much what I 'm looking for. Some people put that in a nice formatted document. I would like to see some so that I can get an idea...

Just looking for a document that outlines common steps for recovery either for the SQL Server or SQL Instance or the Databases. Something along the lines of what is needed...

This is on Windows 2003

I have found linda's suggestion to work but it worked only short term for me. It would last untill the cached account creditials or whatever is causing this, expired again....

Another update:

If I highlight all the SQL statements in the stored procedure and execute it, it takes the same amount of time as executing the stored procedure. But if...