because you use SQL2005 you can capture very nice execution plan information !

Don't get frightened because they are XML, have a look an you may be surprised how much info...

you can also use xp_cmdshell to run isql scripts :

declare @myISQLString varchar(5000)

set @myISQLString = 'isqlw -E -S yourserver -d yourdb -i "yourscriptpathandfile" -o "yourresultpathandfile"'

exec master.dbo.xp_cmdshell @myISQLString

yes

yes

It's your codelibrary that has to be 64-bit, so no change in data.

how about :

select [Meeting Start]

,[Meeting End]

,[MeetingTitle]

from Reservations

where [Meeting Start] between dateadd(dd, (-datepart(dw,@yourdt) + 1), @yourdt)

     and dateadd(dd, ((8)-datepart(dw,@yourdt) - 1), @yourdt)

this proc may ease your work ...

-- TEST IT - TEST IT --

Create   procedure Spc_ALZDBA_PK2NonClustered

   @ParentTbName varchar(128)

  , @ParentTbOwner varchar(128) = NULL

 , @Commentaar varchar(128) = ''

 as

-- Declare @ParentTbName varchar(128)

-- , @ParentTbOwner...

- 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.