Check the autoshrink, autogrow settings on sql 2k5.

If the files need to grow during the process, that'll hurt a lot (as much as 40-50% slower). Autoshrink could add fragmentation...

How do you "notify" the other application?

I'm only guessing here... but I'd assume that the server is waiting for the application to close, and maybe also a success / failure message to report back to you.

What...

On which insert does it fail?

the first one or the insert after this statement (if(@pid is not null ))

That's where I'd start looking if I were you.

ALso do you have...

We understood you the first time.

Where are you blocking at?

DROP INDEX dbo.TableName.IxName

CREATE NONCLUSTERED INDEX IxName ON dbo.TableName (Columns, Names) ON [PRIMARY]

Please keep in mind that Primary is a reserved keyword so you have to use the brackets around it!

Check out this tool, it might be your only hope!

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm

Fire up profiler and see what's going on. Try catching exceptions in the trace so that you have the real error right away instead of a general adodb error...

How are you login in to the DB? Are you connecting user sql login/password instead of windows authentication?

Does the network services has been granted access on the server and on...

If you can make sure that the users cannot input bad stuff in the string (search sql injection for loads of articles on the subject). Then use dynamic sql...

You'd need to use dynamic sql for that, which is usually a no-no.

Why are your business requirements?

SELECT [put the list of columns in here] FROM TS WHERE tstamp > @starttime AND tstamp < @endtime

You were selecting the third parameter of the proc, that's why you only...

Thanx for the answer... afaik it was the first time I asked for this :).

I'm guessing you need to put the first line with the filterid of 10 about 10 lines further in the code (after all the 14s).

Ya, hit the off button dude!