This is a great script, but the version used for SQL Server 2000 doesn't work with SQL Server 2005 because the sysxlogins table doesn't exist.

Microsoft published a new version...

I just wanted to offer a follow up on this issue. It turns out that if you disable the password policy enforcement and then re-enable it, you can unlocked an...

Initially I tried it from SSMS and it didn't ask for a password, but it didn't unlocked the account either. It simply let me close the properties window by saying...

Thanks for that fast response, this really brings some meaning to that design decision. However, I'm confused as to why SQL Server will handle the management of locked accounts different...

Thanks for making some suggestions on how to configure service accounts. I'd really appreciate if you could expand a little bit more on the pros and cons of utilizing a...

There is a diffference between spaced used and space allocated. When you truncate the trans log, you are mainly reducing the amound of space used on the transaction log.

To...