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…
Your centralized learning repository for data platform topics