The site owners cannot keep things open forever. Just try to get in the habit of selecting everything with CTRL-A then copying with CTRL-C .... this way those long important...

This is not the case. tempdb is like any other database it contains at a minimum of an .mdf file for data portion of the database and an .ldf file...

Not always the case ... I use Nextel and their phones store this stuff on a chip. I can even take the chip out of one phone and put it into...

Have you tried using the Cluster Administrator ?

Just curious as to why you are not storing name instead ? It would seem that this method would lend itself to fewer issues.

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

    DBCC DBREINDEX

   ...

Has anyone called MS PSS about this issue ?

You also might want to search the forums here for 'dynamic sql'. There are lots of discussions on this here. This way you will have a better understanding.

I want 'just a phone' <period> ... the good old days of th Nextel flip phone were great except for the 2 way feature which just encouraged endless babble, incomplete...

Here's a handy link no DBA should be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

I am curuous. How can you over-write the master database when you are not in single-user SQL Server startup mode ? Has SQL 2K5 changed this ?

Wishing in the present for a reality out of one possible future ... I'd opt for a device worn on the ear (or someplace fairly inconspicuous) that could serve as...

MOM - Microsoft Operations Manager

You might also want to execute DBCC NEWALLOC and DBCC CHECKCATALOG as well. Also, have you examined the system and application event logs for additinal errors ? If both of...

Yelena, this post is a keeper !

I have not seen such common sense and wisdom in a great while ...