Domain admin is more power than you need for the account, but won't cause a problem. I've seen other posts that have a similar error, didnt see a fix. Are...

There are some switches you can add to help you debug (or they could be the source of the problem!). If you add -outputverboselevel 2 -output c:\repl.txt to the job,...

Do you have a computed column? This might apply:

http://support.microsoft.com/default.aspx?scid=kb;en-us;301292

I dont think we want to require English. For now I'd rather have users contribute in whatever way they can, realizing that posts/scripts in languages other than English will tend...

You guys are doing a great job looking at set based options, well done. As far as the core question of which is better, while loop or cursor, I'd be...

I prefer per processor licensing, just easier to manage. I believe they require you to license all physical processors if you go that route. If they are hyper threaded -...

Taking a cut with DTS seems sound (though I like transactional replication!). If you've got the Enterprise edition you could even set up a distributed partioned view to keep it...

I'd prefer a set based solution, but simplicity ranks high. Performance, sneakiness, lines of code, non rank too high, but might be used for tie breakers.

Sample code for VB:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;182290

Search google for "multiple recordsets" you should find quite a few references.

Enterprise Manager makes it pretty easy to do. Good way to learn the syntax is do something in EM, then generate the create script.

You can return two resultsets just be doing two selects:

select top 10 * from tablea

select top 10 * from tableb

Both ADO and ADO.Net support it, though in both it's up...

I cant say enough how pleased I am with the replies I've seen so far. Good articles should generate thought - and thoughtful comments!

Couple comments I would like to speak to...

Let me see if I can answer some of those, tell me if I missed any.

- Microsoft TSQL from 6.5, 7.0, or 2000. No Yukon features on this go around,...

Nice work writing that up. I can see that saving me a headache one day.

MAUD is pretty funny. I've heard it referred to as ducking as well, you explain to another person who nods their head continuously like a duck, at some point you...