Skip to content

Instantly share code, notes, and snippets.

@mabutler

mabutler/rename.sql

Created August 10, 2022 15:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mabutler/ac0726685e95c6d3da907251092a7b20 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mabutler/ac0726685e95c6d3da907251092a7b20 to your computer and use it in GitHub Desktop.
Download ZIP
Rename locked MS SQL database
Raw
rename.sql
alter database "Standalone"
set single_user with rollback immediate
go
alter database "Standalone" modify name = "Standalone-suffix"
go
alter database "Standalone-suffix"
Set multi_user with rollback immediate
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment