• hugo-939487 (12/2/2010)


    Although you will find views, rules, defaults, etc. with the word "order" in them, you may not find ALL views, rules, etc. with the word "order".

    For larger objects the text is split among several rows, and the word "order" could be split into two different rows.

    Another reason not to use sys.syscomments and use sys.sql_modules instead (the type of the definition column of sys.sql_modules is nvarchar(max)).

    Tom