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