Another quick answer to #2. It uses components that should be familiar to any Microsoft shop. IIS/SQL Server/.NET Framework.

Sweet deal! I paid at a discount book seller, but you smoked my price.

Unsupported by MS, but as of SP3, make them members of the targetserversrole in the msdb database. The reason this works is there is a view, sysjobs_view, that allows that...

If you're a member of the db_owner role but you don't alias to dbo (like members of the sysadmin role do), the issue is unless you specify the owner on...

Any of the SQL Server client tools should work if the SQL Server is directly accessible (typically not a good thing). Do you know if this is the case?

It also matters if you've got to restore a database, SQL Server can't read the sysusers table, and for what ever reason you don't have sysadmin rights. Rare, I admit,...

No. Not in T-SQL. However, as long as you don't go beyond 4,000 characters total (including WITH ENCRYPTION), you could build the CREATE PROCEDURE statement dynamically and then issue an...

Yes, it would involve two scripts, because effectively that's what you're doing. The only other thing to do is key off of the servername or some other flag and then...

Yes. When creating in production add the WITH ENCRYPTION line. Probably the easiest thing to do is to write a script that handles adding that line before deployment to the...

Not that Steve needs to be defended, but he's reacting with honest frustration at a limitation that doesn't seem to make any sense. We've all done that. Except in Steve's...

I vote me. dbo should be me. If you don't have an account for me in your enterprise, create one for me and give me instructions on how to come...

Date's book goes into the academic and mathematical foundations of relational database theory and design. You may know a lot of it, but I'm sure you'll find something either better...

Exactly. Auditors seek evidence that you have valid procedures. Depending on the audit, they may not seek evidence you're actually following them. Also, even though you have it documented, that...

I would agree with what you're saying, but one of the examples they gave has NO indication of dating:

http://www.google.com/news/lemurs_in_the_mist/23467.html

If they'll crawl this, why won't they crawl other URLs without two...

I don't see what the digits get them based on the example they sent back. If they're trying to weed out non-news items, it doesn't do 'em any good. Egads....