Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 was wanting to make THIS stored procedure:
Tag: SCHEMA_ID
Querying Stored Procedure and System Function Parameter Information
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018The following snippet generates a SQL Server View that displays information about the parameters that need to be passed in to System Objects. The data type information that is returned in this view is human readable (i.e. `nvarchar(200) NULL`), rather than the numeric type … Continue reading Querying Stored Procedure and System Function Parameter Information
Return all System Object Definitions (DDL)
Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 The following view returns a comprehensive list of all System Objects on a server. It returns the object name, with and without concatinating the schema to the name. The view can be created and executed as-is.