February 22, 2012 at 9:19 am
Hi -
We have a stored procedure or connection setting the quoted_identifier off and need to find it's origination.
W/in Profiler, i've set the textdata filter = '%identifier%', = 'identifier' and every other wild card option w/out success.
In SSMS studio, if i manually run Set QUOTED_IDENTIFIER OFF - profiler captures the process..
But, if I execute a stored procedure that sets quoted_identifier and simply selects 1, profiler displays the procedure name and simply the 'select 1'.
In Profiler - i'm capturing the following events: all Security Audit, TSQL and Stored Procedures.
So - my question - has anyone leveraged Profiler to caputure the QUOTED_IDENTIFIER status?
Thanks in advance.
February 22, 2012 at 11:03 am
The quoted_identifier set option of a procedure is set during the time that it is created and not according to the session that uses the procedure. If what you need is to find out which procedure has it's quoted_ identifier option set to off, you can use this query:
select schema_name(schema_id) as ScehmaName, name, objectproperty(object_id,'ExecIsQuotedIdentOn') as QuatedIdentOn
from sys.objects
where type = 'P'
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply