Out with the Old (SQL 7.0) and in with the New (SQL 2008 SP2)

We are fast approaching the end of support for SQL Server 7.0. It has been in “extended support” for a while, meaning you could call for help but no non-security hotfixes would be created. But after January 11, 2011 extended support for SQL Server 7.0 ends and you will no longer be able to contactContinue reading “Out with the Old (SQL 7.0) and in with the New (SQL 2008 SP2)”

SQL Server lifecycle and the compatibility level settings

I’ve had several people ask how the compatibility mode/level fits in with the SQL Server lifecycle. For example, the question might be: once we no longer support SQL Server 2000, does that mean we don’t support databases restored/attached to later versions of SQL and still set to 80 compatibility mode for example? The answer isContinue reading “SQL Server lifecycle and the compatibility level settings”