Been there, done that

Thank you Jeff for this reference.

- I've contacted MS and they confermed in x64-sqlbrowser, it does not pulish, but only supplies connection-routing. That's why I couldn't see the instance but...

I 've forgotten to mention the setup of my script.

So it creates an #-temptb and it fills it up with all the data.

Then each while loop deletes 1 row from...

Start with just that code at line 1319

just my 2ct to find the bogus data ...

create table #tmp (RNo bigint identity(1,1) not null primary key, ObligationNo varchar(15))

declare @Rowcount bigint

insert into #tmp (ObligationNo )

select ObligationNo

  FROM         CollExceptions

set @Rowcount  =...

well, this may sound a bit odd, but did you try retyping that querypart from the and clause up to the end of the full query ?

actualy JeffB and Peter Larsson altered your query simanticaly

This...

Did you check what statement is at line 1319.

In sql2005 management studi, there is this handy option for the query editor to show linenumbers.

tools/options/texteditor/all languages

check line numbers

copy/paste the query in SQL Server Management Studio (sql2005 !)

You'll notice it has problems with carriage-returns char(13).

You'll have to replace them with char(10).

Run the script in SQL2005 SQL Server Management Studio.

It has problems with char(13) linebrakes.

Change them to char(10)

- Is there a primary key or unique key on this table ?

- Wich is the clustering index. (=the physical order of rows for...

- So let's guess you are using repeatable read (lock as long as possible so you can redo everiting like from the beginning)

-...

- So let's guess you are using repeatable read (lock as long as possible so you can redo everiting like from the beginning)

- with sql2000 I do this by defining an alert that is coupled to a job and have the user just perform the raiserror

- PROCEDURE sp_start_job

  @job_name    sysname          = NULL,

 ...

to view binary content you must use another application to read the LOB and to transfert to a component that can handle it.

this binary column can be up to 2Gb...