sys.sql_modules was a new catalog view which got introduced from SQL 2005 onwards. I’ve used it quite a lot in my day to day work. Just thought of sharing some of reasons why its preferred over syscomments view a. Finding object dependencies on…
Category: syscomments
