i mean to say comparing with SQL 2000

selecting serverproparty('collation') will return defaulr SQL_Latin1_General_CP1_CI_AS (if i am not wrong).

but As 2005 introduce Schema feature which becomes

Case-Sensitive combination of schema and tablename.

which becomes more tedious job then earlier.

Regards

Manoj