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!

Good call... just make sure to put the waitfor at the top of the loop so that it does not affect the rowcount!... or save that value in a variable...

Are those errors in the non clustered indexes or in the base table?

You don't need any cursor. Do a test on a smaller table to understand how it works.

Just use the script as I put it, it will delete all the...