Disable SQL login possible?

I am doing some maintenance on my SQL server 2k databases and have a number
of sql authenticated accounts I believe are no longer in use. Rather than
deleting them I would like to disable the account from accessing the
database. I know with Windows authentication this is very easy. Can the
same thing be done with a SQL authenticated account?Don (Don@.discussions.microsoft.com) writes:
> I am doing some maintenance on my SQL server 2k databases and have a
> number of sql authenticated accounts I believe are no longer in use.
> Rather than deleting them I would like to disable the account from
> accessing the database. I know with Windows authentication this is very
> easy. Can the same thing be done with a SQL authenticated account?
On SQL 2005 there is ALTER LOGIN DISABLE. But on SQL 2000... the best I
can think of is changing the passwords to some random gibberish.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx