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

This article introduces how to delete SA account in sqlserver, the content is very detailed, interested friends can refer to it, I hope it can help you.

First open SQL Enterprise Manager, then select SQL server configuration properties in the Tools tab, click Server Settings, see the box in front of Allow direct modification of the system directory, click, OK.

Then open the query analyzer and log in.(Hehe, you can use any account to enter, but you must have db_owner permission in master) Enter update sysxlogins set name='ddd' where sid= 0x01,update set sid=0xE765555BD44F054F89CD0076A06EA823 where name='ddd', OK, the execution succeeds, OK, turn to the enterprise manager to refresh the login in security, see if sa becomes ddd, haha, Select ddd right click, how is not the option to pull delete, ha ha, delete. See if SA is not already pulling.

How to delete sa directly in the query analyzer, the practice is similar to that mentioned above, using the extended stored procedure provided by sqlserver to complete this task. Here's what I call the stored procedure sp_configure, sp_configure that you need to utilize to display or change the global configuration settings for the current server.

Its syntax sp_configure [ [ @configname = ] 'name']

[ , [ @configvalue = ] 'value' ]

sp_configure 'allow updates', 1

go

RECONFIGURE WITH OVERRIDE

go

OK, so we can update the system table pull, and then pull update sysxins set name ='ddd ' where sid= 0x01 as before, and then delete ddd, but note that no parameters (or only the first parameter) on sp_configure execute permission is granted to all users by default. Execute permission for sp_configure (to change configuration options) with two parameters is granted by default to sysadmin and serveradmin fixed server roles. RECONFIGURE permissions are granted by default to the sysadmin fixed server role and the serveradmin fixed server role, and cannot be transmitted. It must also be db_owner in master.

About sqlserver how to delete sa account to share here, I hope the above content can have some help for everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.