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 ...

There used to be few good options for a DBA with a bunch of systems stuck on SQL Server 2008. But thanks to one easy trick, businesses on aging infrastructure can take advantage of Microsoft's modern ...

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

As expected, Microsoft made available for download on February 19 the final version of SQL Server 2005. The new update makes SQL Server 2005 compatible with Windows Vista. It also adds a few new ...

Microsoft has released the second service pack for SQL Server, delivering enhancements in several key areas of the widely used database. Full compatibility with Windows Vista is an important change, ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...