My application must support the stored procedure in a SQL Server database. When the application starts, it will create sproc if it does not exist, and it needs to update (discard and recreate) if a newer version is available.
So, I need to somehow save the number against this stored procedure.
Obviously, I can save the row in the table that I create with procedurename, version, and what I will do if there is no better way.
However, I was wondering if SQL Server has the proper mechanism for storing metadata like this. Can I customize the properties of an object or something else?
source
share