Monthly Archives: June 2011

Workaround: Items are not sorted alphabetically in the SQL Server Management Studio Solution Explorer

In SQL Server Management Studio, when you added more items (such as queries) in your project, they are always in the order of latest to oldest from up to down, but not sorted alphabetically. It can be problematic if you … Continue reading

Posted in Tools, Uncategorized | Tagged , | 1 Comment

How to detect database version of SQL Server backups

Oftentimes, we have many different SQL Server (2000, 2005, 2008, etc.) database backups files, and it is hard to remember database version in each backup file. This could cause problems, such as restoring a SQL Server 2008 database backup on … Continue reading

Posted in Uncategorized | Tagged | Leave a comment