I guess you're connected using implicit transactions.

(or use an oledb.begintran statement which switches your connection to "implicit transactions)

just to comfort you a bit :

- 1204 and 3605 are set as startup parameters at all our sqlserver instances

     (24/7/ +-365)!

- We switch...

I tried it, knowing our network is very outdated, and indeed, it chokes quit often.

It's a pitty, you cannot just download it and watch.

It's also a pitty, there isn't...

Did you check http://support.microsoft.com/kb/280101/

 GRANT EXECUTE ON sp_sdidebug  TO public

 EXECUTE  master..sp_sdidebug 'LEGACY_ON'

If I'm correct that cannot be done.

You'll be stuck with creating another instance and moving all the stuff.

or drop the instance (off course keep your datafiles (mdf,ndf,ldf !! and script...

tempdb should return to its starting size when you restart sqlserver.

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