also heard that Microsoft should stop the usage of SET QUOTED_IDENTIFIER OFF while creating any objects.
Regards,
Hardik Doshi
Out of curiosity in 2008 I checked for depreciated items with the following:
SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%deprecated%')
AND instance_name LIKE('%SET%')
Although eleven SET statements were displayed, SET QUOTED_IDENTIFIER was not one of those.