Try running profiler at the time when this job gets called up and see from where request is arriving at this server.

Manu

Installing SQL Server 2005 SP2 on a Failover Cluster Instance:

Note the following information before you install SP2 on a failover cluster instance:

Do not stop the cluster service before you run...

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