You can either:

1) Look into implementing log shipping between the production and the reporting server..a lag of 15 minutes or whatever interval you want for the sync. up will...

Didn't have this problem after applying SP4.  Are you sure that no renaming of the server has been done ?  Because that would do this.

You can get this information from sysprocesses i.e. the process holding the lock and the processes that are blocked because of it and the time since they have had any...

What is the data-type for the exp_dt column ? And what kind of values do you have in that column ?

exp_dt = cast('9999-12-31' as datetime)

maynot yield right results at...

You can get that information by using the distributed queries procedures like sp_linkedservers, sp_helplinkedsrvlogin etc.. Look up BOL for "System Stored Procedures" and in there look for "Distributed Queries...

If you search, you will find a couple of scripts on this site that will give that information to you.  One of those that I find useful is (this answers...

Backup and restore (with the move option) of the user "databases" will work fine.  The system databases (master, model, msdb and tempdb) can be left as is if you do...

This is such a vast topic that no post will be able to do justice to it.  Read more about it on MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp

If you have taken the back-up using T-SQL, you can use the RESTORE command options "RESTORE FILELISTONLY", "HEADERONLY" or "LABELONLY" to get more information on the back-up file.  Look up...

That is because you are missing the where clause in the update statement.  As a result where the names do not match between the two tables, the SQL will try...

The issue is that you are trying to insert into a temp table which resides in the tempdb database and since your account does not have the insert priv. and...

If you just want to clean up the data, you can put this data into a temp table that has an identity column in it, then delete the data and...

Why would you want a hint to force a query not to use indexes ?  SQL Server will typically make the right judgement call if the query is optimal and...

You can either:

a) Specify a default language for the login (using sp_defaultlanguage), or

b) use the SET DATEFORMAT accordingly for the session.

Just a little addition to that list from Diego.  In order to distinguish between SP3 and SP3a (since the versions returned via @@version are the same for both), you can...