Some links that have been useful to me. The documentation that comes with SQL Server is pretty good, although sometimes there aren't enough examples. Never forget to search Google and MSDN when Books Online doesn't suffice.
Awesome SQL database comparision tool!
This tool rocks! I used it to update two MSSQL ? databases (on seperate servers) that are almost the same, but because of development and fixes happening on either one were out of sync. AdeptSQL Diff very quickly compared the 108 stored procedures, 48 tables, and the various keys and indexes. It's a breeze to diff individual objects or data, and update either database, delete objects, etc.
Back to Databases