Check the output of select * from sys.server_triggers

Manu

Use Alter Index statement Disable option-->

DISABLE (http://technet.microsoft.com/en-us/library/ms188388.aspx)

Marks the index as disabled and unavailable for use by the Database Engine. Any index can be disabled. The index definition of a disabled...

I don't think you can....

Have you renamed the server in recent past?

http://support.microsoft.com/kb/281642

MJ

Read it here.

http://www.mssqltips.com/tip.asp?tip=1212

MJ

Were you able to resolve it yesterday?

MJ

- It will not report orphaned users belonging to Windows accounts. (In this case, it is better to drop the user using sp_revokedbaccess, and readd the user using sp_grantdbaccess)

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

MJ

Is the date and time shows the time at which the job finished executing ?

Yep.

Manu

Please try the attached SP.

MJ

Slight correction in what Ellis said.

Note:

SQL Server is not guaranteed to allocate the amount of memory specified in min server memory. If the load on the server never...

Make sure browser service is running.

MJ

Have u tried sqlcmd with -A switch?

http://msdn.microsoft.com/en-us/library/ms189595.aspx

MJ

http://support.microsoft.com/kb/290301

Just check sql error logs and make sure that neither agent service nor sql service restarted at job's scheduled time...

MJ

Yes, you need to restore system db's too as those will bring logins, linked servers, jobs, operators etc. on your DR server.

MJ