Glad to hear it .

Did you pass? .

You have no idea .

Let's make a call to Joe Celko now...

There's no stupid question.. However this would fall in as an easy one .

Don't know what else to check.. maybe it's time to repost this question.

I think it's the contrary... have you tried shriking as the very last job?

Nah I can't... it's a touch screen .

Insert into dbo.Schools (col1, col2) values (@Var1, @Var2)

You're right... must have been confused with server 7.0.

Anyways he can pass 250 without any problems... and I'm right on that one.

One more thing to consider... you can always have sql injection attacks use this to their advantage, never forget that threat, ever.

You don't... do it client side. Easier to do and it's the right thing to not make the server do this.

You can pass 1024 parameters .

Because you can put it all in 1 transaction and have it suceed all or fail all.

Everything inside.

BTW It's insert into dbo.TableName (...)

Dude you are allowing anyone to write anything they want to the system tables by doing that. You should NEVER do that permenantly (and rarely, shortly for some DBA tasks)...

May I add that this is by design and in no way a flaw .