- did you create the parameters in your app of the same type and length as for the sp ?

- are the parameters used in the sp of the same...

Please post some of the errormessages you get ?

It is the only way !

When you generate the script for it with EM, you'll see it starts with dropping the relationship(s), dropping the PK, creating the PK and recreating...

FYI to solve linked server issues sql2005 to sql2000 sp3/sp4

--

-- KB ref at http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

--

just a litle thought...

wouldn't this be easier to get a first glimp of what the last query is doing ?

SELECT

RA

... Picture no stored procedures, sql server viewed somewhat as a dumb shoe box ...

They must have a raising TCO

People tend to...

First of all : don't panick

If you still have a copy of the sql2000 (or a backup of it):

have a look at

can you post the sqlagent.out file ?

All our sqlagent's are served using a windows account.

you may want to have a look at :

i.e. SQL Server 2005's Undocumented Solution for Unattended Installs

Aarch yes.... the hotfix is "AWE hotfix SQL2000-KB899761-v8.00.2040-x86x64-ENU"

KB904660 has more on the cumulative hotfix.

should  be FASTFIRSTROW.

search for "table hints" in BOL

implicit_converts will indeed messup things.

rule 1 for any RDBMS : tell the system what you know !

SQL2005 can generate nice xml-plans which show you implict conversions !

<