Post reply

Policy Based Management

  • November 20, 2014 at 5:37 am

    #301314

    Hi,

    I am looking to create a policy for our sql instances, I want to be notified every time the "CREATE DATABASE..." statement is ran.

    I am looking at SQL PBM, but was not sure which facet to use? Is it Database or Server?

    Thanks

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

  • November 20, 2014 at 5:41 am

    #1759796

    That sounds more like a server-scoped DDL trigger.

    PBM is for enforcing policies (like ensure no databases are named in such a way, ensure all databases are in full recovery, etc). If you want to be emailed whenever a database is created, that's a DDL trigger on CREATE_DATABASE

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 20, 2014 at 5:52 am

    #1759801

    Thanks Gail, I was playing with PBM last week and for some reason thought I could achieve the same.

    Cheers

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply