What features of T-SQL 2000 NOT in T-SQL 2005

microsoft.public.sqlserver.programming

25 Aug 2005 1:33 PM

Sri

Hi,

I just want to know what features/functionalities that was available in
T-SQL 2000 but NOT in T-SQL 2005.

If some one could point to articles and url's related to this that would be
great.

Thanks
Sri

25 Aug 2005 2:17 PM

David Browne

"Sri" <S**@discussions.microsoft.com> wrote in message
news:A959DAA4-B366-4836-A2C4-19329006C839@microsoft.com...
> Hi,
>
> I just want to know what features/functionalities that was available in
> T-SQL 2000 but NOT in T-SQL 2005.
>
> If some one could point to articles and url's related to this that would
> be
> great.
>

This is in the SQL Server 2005 BOL, which you can get here:

http://msdn.microsoft.com/sql/

Breaking Changes:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/47edefbd-a09b-4087-937a-453cd5c6e061.htm

Behavior Changes:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm

The entire series of topics under "Backward Compatibility" is worth a look
for various components of SQL Server.

David