SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

This line doesn't work on SQL2005:

SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

Please notice the extra space at the end of the string: 'collation ' .
(without the space everything works fine)

It worked on SQL2000.

The extra space is a stupid mistake someone else made a long time ago, and
it never bothered us.
Now it tottaly messes-up our apps, and we need to issue a new patch for
SQL2005.

Has anyone come across any other "backward compatibilty" issues ?
Are the MS guys aware of this ?

Thanks
Meir S.

This line doesn't work on SQL2005:

SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

Please notice the extra space at the end of the string: 'collation ' .
(without the space everything works fine)

It worked on SQL2000.

The extra space is a stupid mistake someone else made a long time ago, and
it never bothered us.
Now it tottaly messes-up our apps, and we need to issue a new patch for
SQL2005.

Has anyone come across any other "backward compatibilty" issues ?
Are the MS guys aware of this ?

Thanks
Meir S.