Situations like this are where unit testing is a great thing. I'd suggest creating a test suite for your database code going forward...probably not feasible to do it for...

True, but the generate script utility gives you an option to script object permissions as well so that is not a big deal. Regardless, you can use that script...

Ahh, easy I was just looking in the wrong options window. Go to Tools->Options and then Query Results->SQL Server->Results to Text and set the "Maximum number of characters...

Ohh triggers complicate things 🙂

Unfortunately, there is not a way to do just triggers using that wizard. I have no idea why they put that limitation into the tool.

If...

How would you go about verifying that your backup/restore plan a.) works and b.) meets restore time and data loss SLA's?

As BOL says, SQL Server Reporting Services itself is not Microsoft cluster aware, meaning you cannot install it as a cluster resource. What you want to do is create...

Sorry, forgot something. In order to generate the DROP part of it, there is a "Script drop" option that you will want to set to true on the "Choose...

You could just use management studio to generate the scripts for you...right click on the database in object explorer, and go to Tasks->Generate Scripts. The wizard will ask you...

Check out Recursive CTEs (common table expressions) in BOL here: http://msdn2.microsoft.com/en-us/library/ms186243.aspx.

Agreed that you should check books online. Also, if you are still using SQL Server 2000, there is a great book by Chip Andrews, David Litchfield, and Bill Grindlay...

Check to make sure the login that you are connecting to the server with has connect permissions in the database you are connecting to. If you are not specifying...

The only problem I have run into with this method is if a backup fails for whatever reason mid way through - for example, if the disk runs out of...

Also, if you are interested in looking anything up that might not work and what the new solution is, Microsoft included a backwards compatibility guide in BOL which you can...

As mentioned by the previous person who replied, SQL Server 2005 has backwards compatibility views for virtually all of the old (documented) system tables and functions. I didn't pour...

I would disagree with your assertion that set based programming is code that touches rows once or very few times and that the query you specified is not set based....