Did u try to delete the job and recreate it as new one with the new schedule ???

Some more tips on tempdb : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=277442

Nice article atleast for the beginners.

Hi Sameer.

That was a nice little but great point to note.

Thanks so much !

Use the below statement from the master db. Hope this helps !

use master

select * from sysdatabases order by dbid

Mike, one quick question here:

Sometimes you get the below error message while you try to detach the system databases like sp_detach_db 'model'..

ERROR 7940 System databases master, model, msdb, and tempdb...

If you are able to ping the server and if remote desktop connectivity fails to connect ...then I guess you have problem with services on the DB server...

I believe, u...

select ALL from sqlservercentral.com

Print ('Congrats on achieving this great milestone')

print ('Thanks to ALL')

🙂

Anoop, can you ensure if all the backups are closed properly.

The backups become inconsistent if you shutdown or abort the DB using the shutdown/abort command.

I'm afraid, the backup should be...

Did you try to delete the catalog folder from the drive where it is stored ? I guess, you need to clean it up in the registry too..

The path :...

Plz check this link. You have a downloadable ppt with arthimetic calculations on planning.

http://www.sql-server-performance.com/joe_chang.asp

Is that not possible to view the same in the Cluster administrator --> under Active resources/groups??

I'm afraid, if I recall from Rob Viera's book..u got to have both sql and domain authentication level [simply - mixed authentication] set to run the debugger properly...

I'm sorry if...

Well, in cases where the 'update' has to span and table scan across huge amount of data its better to split into individual batches.

I believe your update runs through dozens...

To work with compatible level, use the below SP.

sp_dbcmptlevel