Modification and deletion method of the default SA account in SQL2000 _mssql

There are too many places to use MSSQL. There are a lot of technology to do the PC also installs the SQL Professional Edition, because it uses more, but the use of people know that SQL has a superuser SA, this user by default, it is assigned to the fixed server role sysadmin, and can not make changes. Generally know a little security problems of the technical staff will change this password, but modify the complex password is not absolutely safe, some violent crack software, rookie will use.
So what to do, the best way is to delete or rename, the following provides a method.

Security increases significantly in order to enhance security by getting rid of the default SA user.

Alter LOGIN SA DISABLE
Alter LOGIN SA with name = [New user name]

To modify the SA user name:

One: In Enterprise Manager, right-click: (local) (Windows NT), select Properties, choose Server Settings, and in server behavior, "allow direct modifications to the system directory" in front of the box tick. Just a little bit more certain.
Second: And then open the Query Analyzer, log in (oh, whatever your account to enter, but must be in the master database has db_owner permissions) input

Copy Code code as follows:

Update sysxlogins set name= ' You want to change the name ' where sid=0x01
Update sysxlogins set sid=0xe765555bd44f054f89cd0076a06ea823 where name= ' you want to change the name '

, OK, successful implementation, diverted Enterprise Manager in the Refresh security login, see, SA is not become your own want to modify the user

To delete an SA user:

The stored procedures that are used to modify the method sp_configure,sp_configure display or change the global configuration settings for the current server.
Grammar:
Open Query Analyzer, enter
sp_configure [[@configname =] ' name ']
[, [@configvalue =] ' value ']

Instance:

Copy Code code as follows:

sp_configure ' allow updates ', 1
Go
Reconfigure with OVERRIDE
Go

Okay, so we can update the system, and then, like the previous practice, pull update sysxlogins set name= ' The name you want to change to, ' where sid=0x01, and then delete the name you renamed.
Be aware, however, that no parameters (or only the first parameter) on the sp_configure have EXECUTE permission permissions that are granted to all users by default. The Execute permission permissions for a two-parameter sp_configure (for changing configuration options) are granted to the sysadmin and serveradmin fixed server roles by default. Reconfigure permissions are granted to the sysadmin fixed server role and the serveradmin fixed server role by default and cannot be transmitted.