VBA is a good item to have in your tool kit. A couple of warnings:

-I have worked in environments where everyone was able to connect to a live instance of...

We had the same problem and I used a table-valued function to limit the data being transferred. In this way, the join was on the function and with a smaller...

For those of us coming from the old ADO world, do the parameter names have to exactly match the sproc parm names? In ADO the ordinal position mattered not the...

Thanks for the reply, 'Junkie. However, this still has the same problem of delayed feedback.

I replaced my print with raiserror ('...PROCESSED RECORD COUNT=%u', 16, 1, @counter). When I ran,...

Last I checked, you could only get the values from out parms if you used the params collection. That was the deciding factor for our shop -- many years ago...

A comment and a question.

We also standardized on the "explicit" parameter declaration. It has been a long time since we made the decision, but from memory it was because it was...

Here is my sad story about NOLOCK. I am a developer that just hired into a shop that (how do I say this...) has no DBA. I cannot believe it...

I check out WTF every day (right after sqlservercentral.com) if I can. They tend to get sanctimonious at times (if you never have deadlines and never do anything new or...

Question (with apologies in advance for my ignorance):

I use ADO in my app to execute the sproc. I create a command object with collection of parm objects standard (works with...