SQL Server Login

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  October 3, 2012 at 1:37 am

  #262490

  Hi All,

  We have a sql server 2005.

  some one has deleted one SQL Server login from that SQL Server. Is there any possibility to find out who has deleted the login and at what time it got deleted ?

  Thanks and Regards,

  Raghavender Chavva

  Thank You.

  Regards,
  Raghavender Chavva

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  October 3, 2012 at 2:00 am

  #1544716

  Unless you had custom auditing there is no way to 100% say yes you can find out what happened.

  You could try the default trace but depending how busy your sever is it might have rolled over and the event no longer stored in the trc files.