still works the same way, as long as you don't use dmv's.

Even better, if this standard date conversion is only calculation or formatting, you may want to take a quick...

you could use windows authentication in the dts-connection-objects, and only provide the needed rights on your prod-servers to the service accounts that runs sql-agent (so it starts the dtsrun.exe)

if your processing does not need to be executed online-realtime, only execute it online-neartime.

have your update-trigger raise an error (nonblocking, but logged) and define an alert for it , so...

it's not because your queries slow down, that your network slows it down !

For sqlserver it depends wich trace-flags are activated for the trace.

e.g. do you only capture sqltext or...

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