Just an afterthought ... since this is a development database environment and it seems losing things (or things getting corrupted) will cause you grief ... it might be a good...

Unless your are running SQL 2K enterprise /3GB and /PAE will do you absolutely no good since the 'standard' edition is limited to to 2 Gb <period>

What about adding:

EXEC sp_MSforeachtable 'sp_recompile ?'

Otherwise your execution plans will not take advantage of the new statistics ...

Can you post your restore script ?

Even MS has 'builtin' this undocumented feature (maintenance with no listed Jobs) in some products ... in particular SMS and MOM (to a limited extent) ... as for showing up,...

A true "quiesce" is simple a temporary cessation of activity wothon the DBMS engine that allows the engine to write out coordinated recovery points in all logs. In the...

I'm not real experienced with DTS but it sounds like a better soluition than a trigger on a system table.

First off, add more RAM 2 Gb is a max value to grab for the OS, SQL Server and IIS. I'd make it 4 Gb minimun - configure SQL for...

It seems that keys and indexes are getting very confused here. A key is something identify the row as unique. indexes are for accessing the data. Your table key can...

Is it possible that the application is attempting to get sql server error diagnostic information and that portion of the client code is failing ?

have you checked for stored procedures marked to execute on start-up ?

check out BOL - Designing an Index - what you need is a composite index.

You might want to search this site for chNge management and migration processes. There are quite a few great threads on what you want to do.

We use a MOM 2005 for the enterprise and SQL Servers. In addition to this we use the MSX/TSX functionality of SQL Server coupled with an SMTP mail stored procedure.

I have experienced the same issue sporadically. I have found a few causes, the first mentioned above, excessive tempdb activity - but usually during an 'autogrow'. So we try to size tempdb...