Saturday, 15 August 2015

How to search commented string in sql server stored procedures? -


I have 300 stored procedures.

I want to know whether there is no string in it or not.

Is this possible?

For example: I want to know whether - my.dboTbls has been commented or not.

You can try:

  select p. * Object_Definition (p.Object_Id) '% - my.dboTbls%'     from Sys.procedures p

No comments:

Post a Comment