SQL Server method to change the SA user name _mssql

First, run the following code in the Enterprise Manager's Query Analyzer (note that the user name that goes into the Query Analyzer is the system administrator and is the DB owner of each database):

Copy Code code as follows:

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

And then run the following code

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 '

Then:

Copy Code code as follows:

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

Then, if you look at the role of SQL Server, you will find that the SA's username has been changed to your new name.