:w00t:, after 3 times you'd think that it would be enough. So I won't tell you again.

I will however suggest that you can have this functionnality by moving the...

23 MB left instead of 23 GB? That will make a small difference :w00t:.

I don't have the right name, but if you search for utility in books online, you will get that list and sample code.

The QOTD section also has a section for...

Do you have any script, link to prove that? I have not been able to reproduce this behavior at all.

http://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/

There are decrypting scripts on this site and on google.

Take a backup of the db and restore it on another server. Then run those scripts on tha RESTORED version.

Get...

Yup... there are already at least three of us waiting for the code to cure it :hehe:.

... or use identity insert on

You have a trigger(s) that update rows one at the time.

Thanks, they are already aware of this one... and hopefully it's on top of their todo list.

What kind of package do you have in mind?

What do you need to learn to get on with your day to day business with as little surprises as possible?

Please share it with us. It will help someone in the future.

Your Dev want to touch the system tables too?

When was that?? I never saw it work like I want it to ;)... like the old one.

Make 3 different procs to do the selects.

In the main proc, do something like this :

Insert into @HoldingResults (Cols, list) EXEC dbo.CallTheRightProc @Param1, @ParamX

You just have to call the...