Any retired syntax for SQL 2008?

We're in the process of making SQL syntax changes to prepare for an upgrade to SQL 2005, and I don't want to go through this particular exercise again if we can get everything compliant for SQL 2008 while we're making the current changes.

Thank you,

Rob

The BOL from the actual June CTP release contains a list of deprecated keywords and commands.

Jens K. Suessmeyer.

http://www.sqlserver2008.de
|||

Hi Rob

It's good to see that you're thinking ahead regarding usage of deprecated features. SQL Server 2005 Books Online topic Deprecated Database Engine Features in SQL Server 2005, section Features Not Supported in the Next Version of SQL Server, already lists all functionality that is expected to be removed in SQL Server 2008 and future releases. I'd recommend that you consider using suggested alternatives for the syntax that has been announced for deprecation while making your syntax changes.

You can also refer to SQL Server 2008 June CTP Books Online topic Discontinued Database Engine Functionality in SQL Server "Katmai" for features that are no longer supported in SQL Server 2008. Please also take a look at topic Deprecated Database Engine Features in SQL Server "Katmai" in SQL Server 2008 June CTP Books Online for Database Engine features that will be removed in the next release after SQL Server 2008. We’ve made a lot of effort in SQL Server 2008 to provide additional support to track usage of deprecated features via deprecation performance counters and trace events. For details, see topic SQL Server, Deprecated Features Object.

Thanks

Sara

|||

Thank you very much.

Rob