Rename Database

USE master

GO

EXEC sp_dboption Fox8, 'Single User', True

GO

-- if this command fails, use:

-- alter database Fox8 set single_user with rollback IMMEDIATE

-- see: http://copypastenet.blogspot.com/2011/01/spdboption-single-user-command-failed.html

EXEC sp_renamedb 'Fox8', 'Fox8NotUnicode'

GO

EXEC sp_dboption Fox8NotUnicode, 'Single User', False

GO