SQLServer version and sp / hotfix ?

this may be a documented bug.

maybe you can consider using this function :

use master

if exists (SELECT ROUTINE_NAME

  FROM INFORMATION_SCHEMA.ROUTINES

  WHERE ROUTINE_TYPE=N'FUNCTION'

    AND ROUTINE_SCHEMA=N'dbo'

    AND ROUTINE_NAME = N'fn_ALZDBA_convert_date2WeekRange' )

  drop function [dbo].[fn_ALZDBA_convert_date2WeekRange]

GO

CREATE FUNCTION dbo.fn_ALZDBA_convert_date2WeekRange...

This query may help out .... If you are sysadmin for the sqlserver.

SELECT

ES

.session_id

, ISNULL(

I forgot to mention ... What kind of trinsaction isolation level are you using for the connection / command ?

SSMS with uses read committed by default.

I guess your application may...

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