none
Alert for create\restore database failed

    Question

  • 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.

    Monday, December 05, 2011 10:34 AM

Answers