DESC[RIBE] for MSSQL Files

How to install:

1. Open the downloaded codes in Microsoft SQL Server Management Studio (SSMS)

2. Execute (compile) the codes.

3. Mark procedures as system objects:

   EXEC sys.sp_MS_marksystemobject sp_desc;
   EXEC sys.sp_MS_marksystemobject sp_desc_more;

4. Grant to public:

   GRANT EXEC ON sp_desc TO PUBLIC;
   GRANT EXEC ON sp_desc_more TO PUBLIC;

5. Execution example:

   EXECUTE sp_desc '[AdventureWorks].[Person].[Address]';
   EXECUTE sp_desc_more '[AdventureWorks].[Person].[Address]';

   If your query window was opened for AdwentureWork database, you can skip the
   database name. Likewise you may skip schema name if the object to be described
   is in the default schema. As the procedures are marked as system objects the most
   common cases you can use a very short formula (you can leave the exec command
   and even the quotation marks if the object name is simple):
   
   sp_desc ErrorLog

Note: don't forget to use schema names during the installation, if you want to
      use the procedures in other schema than dbo.