今天突然出现了Property IsLocked is not available for Login '[sa]'，我太阳，下面有绝招对付它！

Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

都不知道为什么出现这个东东。难道是昨天装了NOD32和OUTPOST的原因？

不知道。太阳！

解决办法：

 

alter login sa

with password = 'yourpwd' unlock,

check_policy = off,

check_expiration = off

posted @ 2009-04-27 18:02  Benny Ng  阅读(527)  评论(1)  编辑  收藏  举报