Alert for create\restore database failed


  • Hi,

    I removed create DB rights from users, but i want to recieve alerts, when somebody trying to create DB on server. What error number i could use for this?

    I already tried to set severity to 14(insufficient permission), but in this case i only have message

    Login failed for user <>. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
    This seems to be a garbage message, becouse sometimes i can see this messages in sql log even for my login.

    2011년 12월 5일 월요일 오전 10:34