Only possible with t-sql commands.

When you create your backup you can specify a password for the backup file. Then when you want to restore the backup, the password must be...

Better try stopping the agent first and then see if you can drop th table.

MJ

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...

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)

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