raresql.com
SQL SERVER – sp_refreshsqlmodule – How to update the metadata of an object
Problem : Whenever you modify the underlying objects (tables, data types etc) of any non-schema-bound stored procedure, user-defined function, view, trigger mostly due to customization then your ob…