Some steps:

1.) Reset the status from "Suspect':

EXEC sp_resetstatus 'myDatabaseName'

2.) Set the database property "allow updates':

exec sp_configure 'allow updates', 1 RECONFIGURE WITH OVERRIDE

3.) Set the database to "Emergency Mode":

UPDATE master..sysdatabases SET...

Restrict the maximum memory usage by sql server to something around 14GB by setting max server memory to 14GB. SQL will eat all available memory when required so you need...

What is the min and max server memory settings? I think this is not a dedicated box for sql server.

MJ

Is browser service started?

MJ

What is the file size and what error do you get if you try compressing it by using rar32.exe directly without using sql cmdshell SP?

MJ

Nope you can't view them.

MJ

I don't know much about partitioning. I tried something tht worked finally.

Step 1:

CREATE TABLE [dbo].[Transaction_Summary](

[Transaction_Serial_No] [bigint] NOT NULL,

[Channel] [nchar](4) NOT NULL,

[Card_Organisation] [nvarchar](11) NULL,

[Days_to_Expiry] [int] NULL,

[Ratio_Current_Amount_AVG_3M] [decimal](19, 2) NULL,

[Card_Function_Identifier] [nvarchar](6) NULL

)...

In which table you find it eventually as I can't see any entries for temp variable in syscacheobjects.

TIA.

MJ

It just requires you to have SP2 applied to SQL Server 2005 instance.

MJ

Why don't you restore it on test server and change the database collation under 2005 and test the functionality if you are not getting 100 correct answers.

MJ

Try uninstalling client components first and then install them again. Do you have any other sql server running on this machine like 2008 etc.?

MJ

What exactly you want to pull out using this code?

MJ

Try installing component tools again in case nothing else works out.

MJ

Use the below mentioned code:

Make sure first you create a table named servers under master database with servernames in it.

GO

/****** Object: StoredProcedure [dbo].[usp_linked_query] Script Date: 08/28/2008...

What is the sql server version, memory configuration, OS and CPU utilization?

MJ