Thank you so much for your conclusion.

Thank you so much for the input above.

Unfortunately, a temporary table can only be dropped from the connection session where it was created.

From the Activity Monitor, I cannot determine which...

Are you asking clean installation or a repair?

Normally, a repair will not hurt your database. But you should backup all your databases as a DBA.

Gail:

Both SQL 2000/2005 have the same issue. I know the attached characters are related to the connection session. If we open two connection sessions, and run the following script on...

Frankly speaking, I believe that MS support team may interprete the check output much better. If your company has support agreement with MS, it is the best source.

As users, I...

Thank you so much for the input above. I have tried all you recommended. It still does not work now, however.

After indentifying which index is corrupted, you may try to rebuild this index.

Do not forget to have a backup before doing anything.

Some links for you. May them help.

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

http://forums.sqlwire.com/showthread.php?t=2523

The following article may help.

http://www.sqlknowledge.com/index.php/articles/35-administration/67-how-long-does-a-sp-stay-in-the-cache-

Try the system table, sysobjects.

1. Most of the logins STATUS is sleeping and LAST COMMAND is AWAITING COMMAND. What is this means?

These indicate that the are not running while you executed sp_who2.

2.Logins ABC\MOSSADMIN n...

Make your batch smaller if you can.

I guess you used a different tool in restore from the tool used in backup.

Show plan is based on statistics in existing tables. It does not work on any temporary table.

VDI error can be caused by some reasons. The following one is one of them.

VDI error 1000: Failed to recognize the SQL Server instance

If you can provide the error...