From Rory.wiki
MS SQL Notes
From here. Dumping a database to a text file can come in handy. In MS SQL 2008 it can be done using the SQL Management studio Generate Scripts option.
From here. Handy list correlating version numbers returned by SQL server and which version/service pack that is.