May I know what will happen if I don't re-apply the Service Pack ?

Now, I have a problem :

Agent Job : running a SQL 2000 DTS in SQL 2005, stand-alone...

Thanks

Thanks.

But I don't know why the execution fail :

EXEC dbo.test_user 'tuser001', 'tuser0011'

Error message :

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'tuser0011'.

Any ideal ?

I have installed SSIS on the passive node separately.

Now, both node 1 and node 2 have SSIS service, though not a cluster resources.

But may batch file still failed.

The same error...

Thank for your reply.

But I did use SSIS, I just used DTSRUN.exe and SQLCMD commands and used a batch file and Windows Scheduled Task to execute them automatically.

So I think...

I couldn't find the axscphst.dll but I found an AXSCPHST90.DLL at the C:\Program Files\Microsoft SQL Server\90\COM folders of BOTH the active and passive node.

Are these 2 dll files the same...

During the SQL 2005 Cluster installation, only the SQL Server Database Service and Analysis Services have the "Create a failover cluster" option for us to click.

Integration Services doesn't.

My DTS packages...

Dear Ramesh,

Thank you for your information.

But I need step-by-step instructions, can you tell me some web sites about what you said ?

As we need to shift from our existing SAN to a new one.

But I don't know : Method 1 or Method 2, which one is the correct one ?

Thanks

Do I need to keep the initial backup copy of the Primary database all the time ? Or it can be deleted once the log shipping has been started successfully...

Thanks.

Thank every bodies, I fixed the problem by re-install the whole SQL Server 2005.

Thanks a lot, your information is very very useful.

Thanks

Thanks.

But my SQL Server returns : 'Disabled'.

What does it mean ?

Do I need to correct it ?

How do I correct it ?