Deprecated features highlights in SQL "Katmai" 2008 release
SQL 2008 books online confirms the deprecated features that are not supported with the release of RTM, those few lists are as follows:
-
SP_DBCMPTLEVEL is replaced with ALTER DATABASE .. SET COMPATIBILITY_LEVEL
-
SP_HELPDEVICES is replaced with sys.backup_devices system table
-
SP_RENAMEDB is replaced with ALTER DATABASE .. MODIFY NAME
-
DBCC DBREINDEX is replaced with ALTER INDEX .. REBUILD
-
SP_RESETSTATUS is replaced with ALTER DATABASE .. SET{Online|Emergency}
-
DBCC SHOWCONTIG is replaced with DMV sys.dm_db_index_physical_stats
-
SP_LOCK is replaced with query against sys.syslock_information
-
SP_CHANGEOBJECTOWNER is replaced with ALTER SCHEMA or ALTER AUTHORISATION statements.
-
Deprecation of Internet Explorer 5.5 support was announced in Reporting Services 2005 Service Pack 2. This version of Internet Explorer is not supported in the SQL Server 2008 release of Reporting Services.
-
The HTML with Office Web Components (OWC) rendering extension is discontinued in this release.
-
There is no side-by-side support for SQL Server 2000 in this release.
-
Multiple instances of SQL 2008 (this CTP) are not supported on a single computer, within 64-bit platform Katmai only supports x64 in this release and there is no IA64 supported is enabled.
This means you have to re-write the code and stop using the previous SQL versions statements that are mentioned above.