Hi all By turning off the DBCC TRACEON 208 will there be any problems on the db or application. if yes what would be those problems. In order to turn off the above dbcc command. can we use DBCC TRACEOFF 208 OR just DBCC TRACEOFF. Thanks in advance Regards Ashwin Reddy
As far as i know... NO. If you need more details, have a look into... http://support.microsoft.com/default.aspx?scid=kb;en-us;243352 Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
No issues as it do QUOTED_IDENTIFIER to ON. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.