Thursday, April 6, 2017

Query to get all procedures which may have NOEXPAND hint

SELECT * FROM sys.Procedures WHERE is_ms_shipped = 0 
AND OBJECT_DEFINITION(object_ID) LIKE '%NOEXPAND%'
Posted by at

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)