Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 drop sa login

Author  Topic 

antony_dba
Starting Member

26 Posts

Posted - 2010-12-01 : 05:48:40
how to drop the sa login
please suggest ...

kris

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-12-01 : 06:03:09
You can't.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-01 : 06:30:07
You can disable the sa login. You can rename the sa login. You cannot drop it.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-12-01 : 11:05:53
You can also give it a really long and complex password that no one will ever be able to guess.



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -