From a query window run the following SQL:

SELECT * FROM MASTER..SYSMESSAGES

This will give you a list of the SQL server generated messages.

Also it's worth going into Enterprise manager go to...

You can set up an Alert via SQL Server Agent to monitor for Error number 18264 (Successful DB Dump). Also from here you set the alert to e-mail any addresses...

Kashif,

My apologies Antares686 is correct in saying you can set collation at DB level, I missed the fact your working with SQL2k. Tend to have my head stuck in SQL...

Unfortuantly you will have to re-install SQL Server with correct collation. If you have any databases you wish to retain then you will also have to think how your going...

If the database is only used for read only and from the information you have supplied my personal approach would be the following.

Have the option 'Truncate log on checkpoint' and...

NOLOCK only applies to the SELECT statement. Is it possible you may have an INSERT, UPDATE or DELETE statement in your SP which is causing the tablelock.

Rick.