My 2 cents. It will not put database into SUSPECT mode.

Access from SQL Browser? The error message in the event log may be due to the fact that some other application/user is trying to access with the wrong "sa" password.

Agree with ALZDBA. Most likely your server does not have E drive or the folders that is being referred to in the screenshot.

Yes. You can do it in SQL Server 2000. 'allow updates' should be 1 in sp_configure and after creating the stored procedure all you have to do is modify the...

@EasyBoy,

The database which are OFFLINE cannot be shrunk. Alter your query to exclude those offline files or bring the databases online for your query to work fine.

This is because the access to registry...

You may find the document mentioned in this discussion useful.

Is there any way inside the DB2.dbo.usp_Proc1 SP to determine that the current database of the connection that called it is DB1? (I've done some Googling and couldn't find any...

You may find these discussions useful.

http://www.sqlservercentral.com/Forums/Topic941445-391-1.aspx#bm941974

http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/4be7eb6f-1346-4f6c-8184-a86f39b43e20

You may find these links useful

http://www.developmentnow.com/g/114_2006_11_0_0_847037/Prcess-could-not-execute-sp-MSadd-repl-commands27hp.htm

http://www.mombu.com/microsoft/sql-server-replication/t-prcess-could-not-execute-sp-msadd-repl-commands27hp-1094450.html

http://www.sqldev.org/sql-server-replication/sql-server-2000--log-reader-not-working-65684.shtml

Instead of Mapping the drive, why not backup the database to the network share directly? An example here

However, it is recommended to backup the database locally to disk and then...

TRY....CATCH is an option

SQL Server does not maintain a password policy of its own. It is dependent on the Windows Password policy

I am not sure if we can control the file naming convention in Maintenance Plans. If you want to change the naming conventions, use custom scripts. Some good examples are...

Did the server name change after cluster installation?

Please check this these links help

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

http://support.microsoft.com/default.aspx?kbid=328306