paul walker

paul walker

  • 2.1k
  • 36
  • 846

Comments in Stored Procedures, SQL Server

Jun 17 2022 1:01 PM

Rather than use Extended Properties (not my decision), we want to document our stored procedures at column level.

To do this we are to comment as follows:=

ColA = A + B,

/*<COLS>ColA<COLE><CMTS>A concatanation of A + B<CMTE>*/

We then want to be able to search systables for <COLS>

Does anyone have any SQL that will retrieve these comments??

Failing that, which systable the comments are held in?

Cheers 


Answers (3)