Tag Archives: SQL Server

Find out the SQL Server Patch from Build Number

If you ever have to find which SQL Server patch has been installed, you can do it form the Version number Then look it up on this web site. http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx Tweet

Prevent SQL Server orphaned databases. Make the ownser sa.

All databases shoudl be owned by “sa” as this is the only account that cannot be dropped from SQL Server. This prevents orphaned databases should the owner account be dropped from the server. Tweet