Thats a great point. Hard enough to master one language, but if you get everyone using their flavor you'll have procs written in Perl, Cobol, etc - after all in...

Deuce - if you're using union you'll only get one recordset. In some cases returning multiple recordsets will make more sense...union won't work, you need it separated anyway, etc. Multiple...

Might want to look at the logging verbose setting, might be a way to tweak it there.

Andy

Turns out to be an easier solution:

dbcc checkdb with tableresults

Found the answer here:

http://groups.google.com/groups?hl=en&threadm=O5ss5Akm%24GA.214%40cppssbbsa03&rnum=6&prev=/groups%3Fq%3Ddbcc%2Bcheckdb%2Brecordset%26hl%3Den%26rnum%3D6%26selm%3DO5ss5Akm%2524GA.214%2540cppssbbsa03

Andy

Costly to make, or slow to run? Normally a view is a good solution. Rather than importing if you decided not to use the view I'd consider transactional replication. Running...

Sure - try this one:

http://www.microsoft.com/traincert/exams/70-229.asp

If you're not familiar with it, scroll down to where you see "Skills Measured", thats the important part!

Andy

You might check the errors collection to see if the info is being returned there. BOL says it returns a resultset, have not tried it myself. Interesting.

Andy

Lots of questions!

First of all, I dont believe in underestimating any test. While study guides are good, I think the tasks MS outlines for each test (on the MCP site)...

I think it might do all programmers good to spend 6 months as a DBA...and vice versa. Brian, interesting hiring scenario - a great example that the days of calling...

If you're backing up to tape, then you absolutely have to check the event log each day (or build a way to have it send you status) to make sure...

Two spares is interesting - not sure I'd do it, but interesting! Seems like a lot would depend on your support contract. We have guaranteed 4 hr delivery of parts...

I think you might have a problem relating to the package owner. You don't need DTS to use ADO - you could test it using a simple .vbs file.

Andy

I wouldnt mind seeing a lab environment type test. Just pretty expensive to implement - not so much hardware, but staffing, generating new versions of test to keep it secure,...

MySQL is still missing a few things isn't it...like sub queries? Have not looked at Postgres. I like the idea of a freebie, just not willing to give up too...

DMO has two methods, CheckIdentityValue and CheckIdentityValues that deal with this. The first works on a table, the second checks ALL tables in a db - equivalent to the script...