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.
meir@clearforest.com
Leer las respuestas