If SORT_IN_TEMPDB is set to ON, there must be sufficient free space in tempdb to store the collection of sort runs for the largest index, typically the clustered index, and...

Please run sp_spaceused @updateusage 'true' on both the databases and compar the size thereafter.

MJ

Are your database stored procedures/adhoc-queries making too much use of "with recompile" clause in them?

MJ

Did you performed the below mentioned step:

Allow system table updates by using the system stored procedure sp_configure and RECONFIGURE with override, and then update the [database_name].dbo.sysfulltextcatalogs path column to the...

Create an Excel file named testing having the headers same as that of table columns and use these queries

1 Export data to existing EXCEL file from SQL Server table

insert into...

Do you have client tools on both the machines? May be this(http://blogs.msdn.com/sqlserverfaq/archive/2009/04/09/sql-server-2005-sp2-installation-got-hung-on-a-2-node-cluster-with-this-message-awaiting-first-complete-passive-cluster-node.aspx) can help.

MJ

It would be gud if you include the steps which are inter-dependent in one job step.

MJ

Why don't you try fetching that info using the standard reports if your instance version is SP2 or later.

MJ

If possible, try dropping the link server and create it again. This might allow the process to terminate faster.

MJ

Let's wait for an expert comment on this. I believe sp_reset_connection works on connection basis only.

MJ

Would advice you to send output of the checks to a file and mail that file to yourself using dbmail.

MJ

Yes.

To reduce the max server memory you may need to restart SQL Server to release the memory(http://msdn.microsoft.com/en-us/library/ms178067.aspx).

MJ

I think yes.

It will clear any work or temporary tables that are created by the connection.

From

http://stackoverflow.com/questions/596365/what-does-spresetconnection-do

MJ

Remove -m -c -T3608 from startup parmeters. Also, is there any other enterprise manager or query analyzer window already open?

MJ

SET NOCOUNT ON

DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5)

SELECT @crdate=crdate FROM master.dbo.sysdatabases WHERE NAME='tempdb'

SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60

IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0

SELECT @min-2=(DATEDIFF ( mi, @crdate,GETDATE()))

ELSE

SELECT @min-2=(DATEDIFF ( mi, @crdate,GETDATE()))-((DATEDIFF(...