Post reply

sa login properties not displaying

  • March 6, 2011 at 12:57 am

    #236058

    hi,

    i wanted to chenge the password of the sa login user. hence i logged in thru windows authentication (which is in sysadmin role) and went to security>logins and when i click sa, the following error popped.

    how can i resolve this ?

    please advise 🙁

    thanx in advance

  • March 6, 2011 at 10:09 am

    #1295117

    Please check which process is causing this one to be deadlocked. You may find this article useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • March 7, 2011 at 4:19 am

    #1295239

    Firstly, you can use sp_who2 to find out what are the processess are runnng and which are causing deadlock.

  • March 7, 2011 at 4:30 am

    #1295245

    Actually, it's difficult, if not impossible, to know after the event what the deadlocking process was unless you had already enabled the appropriate trace flag or started a Profiler trace. Do what the error message suggested, and re-run the transaction. If it succeeds, put the initial failure down to bad luck and move on. If this happens regularly, then you'll need to do some troubleshooting - the link that Pradeep posted is a good place to start.

    John

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

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