Policy-based Management

• Lempster

  SSCoach

  Points: 15651

  More actions

  June 26, 2009 at 3:24 am

  #211380

  I've set up a Policy with a Condition that checks for any user-created stored procedures that start with sp_

  When I evaluate the Policy I get some unexpected results - see attachment. (BTW, how do I post an image to the forum rather than having to use an attachment?)

  Because my condition specifies 'NOT LIKE sp_%' I would not expect stored procs with a name that did not start with sp_ to fail the evaluation. The only ones I would expect to fail are those that start with sp_ i.e. the target of my Policy.Perhaps I have misunderstood the logic...or is there a known issue with this aspect of Policy-based Management?

  Thanks.

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  June 26, 2009 at 3:42 am

  #1015865

  i suspect this may be your like clause

  _ is a wildcard in "like"

  try NOT LIKE '%sp[_]%'

  MVDBA

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  June 26, 2009 at 3:45 am

  #1015867

  _ (underscore) : def : Any single character.

  example:

  WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean, Sean, and so on).

  use

  Not like 'sp[_]%'

  Tanx

• Lempster

  SSCoach

  Points: 15651

  More actions

  June 26, 2009 at 3:49 am

  #1015868

  Ahh!

  Yep, that's fixed it. Many thanks to both of you.