Post reply

Login

  • December 7, 2011 at 1:29 am

    #251614

    Hi All

    My server is 2K5 (9.0.4035) on 2003 OS SP2,I created a login and assigned it a db role but the next day the db role is removed, why is that?

    Thanks

    It's better to fail while trying, rather than fail without trying!!!

  • December 7, 2011 at 1:47 am

    #1417840

    Another DBA? Triggers? Database restored?

    John

  • December 7, 2011 at 1:47 am

    #1417842

    Please check with your team. It can't just disappear from server. 🙂

  • December 7, 2011 at 1:55 am

    #1417849

    It's production the db hasnt been restored

    It's better to fail while trying, rather than fail without trying!!!

  • December 9, 2011 at 8:49 am

    #1419449

    The most likely scenario is something or some process (if you have something automated... SQL Server doesn't have anything like this) dropped the role. Without prior auditing, it may be impossible to tell who did this unless someone confesses.

    I'd ask the question diplomatically. Likely a team member dropped it by mistake.

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 4 (of 4 total)

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