|
|
Posted by Bobbo on 07/31/06 16:14
Ed Murphy wrote:
> Our client's application software requires all stored procedures to
> have quoted_identifier set a certain way. I've tripped over this a
> few times and promptly fixed it, but this morning, I had to
> troubleshoot a case where someone else tripped over it. In such a
> situation, how can I identify which SP(s) have it set the wrong way?
You can query against the SP text as follows.
select o.[name] as 'ProcName', c.[text] as 'ProcText'
from sysobjects o
join syscomments c on o.[id] = c.[id]
where o.[name] like 'usp%'
This is based on the assumption that all your SPs start with 'usp'.
Applying a WHERE clause should enable you to filter out certain procs.
Somebody please step in and correct this as I have a feeling it's not
the best way.
Navigation:
[Reply to this message]
|