今天突然出现了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编辑  收藏  举报