Shulou(Shulou.com)05/31 Report--

This article introduces how to change the sa user name in SQLServer, the content is very detailed, interested friends can refer to, hope to be helpful to you.

First, run the following code in the query analyzer of the enterprise manager (note that the user name that enters the query analyzer has the role of System administrator and is the db owner of each database): the copy code is as follows: sp_configure 'allow updates', 1 go RECONFIGURE WITH OVERRIDE go

Then run the following code to copy the code as follows: update sysxlogins set name=' the name you want to change to 'where sid=0x01 update sysxlogins set sid=0xE765555BD44F054F89CD0076A06EA823 where name=' you want to change the name'

Next: copy the 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 user name of SA has been changed to your new name.

On how to change the sa user name in SQLServer to share here, I hope the above content can be of some help to you, you can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.