• Be aware that if you have any remote logins set up on the instance, e.g. if you are using replication, the sp_dropserver command will error; you'll need to drop the remote logins first.