Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

However, the Compatibility Level property for that database remains at the release it was upgraded from. For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to ...

The task is to be able to copy a databases from production (and the source will always be production) down to staging or testing. Finally, all of these tasks need to be scriptable as SQL statements.