Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 2,050,846 hits
  • Select GETDATE()

    September 2014
    M T W T F S S

7 Responses to “Help : Who dropped login from server?”

  1. Uri Dimant said

    Hi Balmukund
    I needed your help regarding the memory on our server. I sent you file, have you got it?

    • blakhani said

      Hi Uri,
      I received and reply back as well. Unless we have .mdmp file (i didn’t see them in zip) we can’t find root cause.

      • Uri Dimant said

        Hmm ,I did not get your email.. But at this time SQL Server did not generate .mdmp file just
        * 09/14/14 05:04:19 spid 4580
        * Non-yielding Scheduler

  2. Uri Dimant said

    Ohh, I just found the crashed files. Send you

  3. Uri Dimant said

    Please let me know when got the files.. Thanks

  4. SD said

    Thanks a lot for this SQL. It helped us to figure out who dropped a user in the production database.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: