September 25, 2006 at 12:27 pm
Please Help!!
We have an application using SQLOLEDB connection to a SQL Server 2005 database. Per domain policy, the users are required to change their password every 60 days.
The accounts are established to 'Enforce password policy'.
When we try to execute the 'ALTER LOGIN' command to change the password, locks are being established and will not free the account without bouncing the instance.
After issuing the command, any interaction with the server using this UserID results in a "lock request time out" error 1222.
I have tried issuing this command using both the application and through SQLServer Mgmt Studio Express and the results are the same.
Any idea would be greatly appreciated.
Rusty Rickmon
September 26, 2006 at 8:56 am
This is because it switches out of READ UNCOMMITTED about halfway through. Use sp_who2 in query analyzer instead. If you're interested in locking/blocking check out http://www.sommarskog.se/sqlutil/aba_lockinfo.html for a good stored procedure.
Joshua Perry
http://www.greenarrow.net
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply