rename a database under mssql 6.5?

rename a database under mssql 6.5?

Post by david spaisma » Tue, 18 Apr 2000 04:00:00


I am supporting a mssql 6.5, sp 4 application.

We have set up an user acceptance server with a database that is the same as
production. However, I have been told that this database and server may be
used for applying fixes rather than user acceptance.

To avoid confusion over which database is on which server, it might be a
good idea to rename the database. I am not sure if this can be done un der
mssql 6.5?

1)Can I rename a database?

2)If so, how can I do so?

Which system tables would I use to update?

Any information you can furnish will be appreciated. THanks.

David Spaisman


rename a database under mssql 6.5?

Post by Patrick Loga » Tue, 18 Apr 2000 04:00:00


Database must be in single-user mode first, use sp_dboption.

Patrick Logan, MCSD
Senior Technical Development Advisor
McKessonHBOC -- Extended Care Solutions Group

Opinions expressed are my own and not necessarily those of McKessonHBOC.


1. compare mssql 6.5 database and mssql 7.0 database


I am using a product from red-gate --called SQL COMPARE-- to compare two
mssql 6.5 databases. It works quite well.

However, we are planning to upgrade our core production database shortly
from mssql 6.5 to mssql 7.0 using the upgrade wizard.

I have not seen any production that can be used to ompare a mssql 6.5
databae and an mssql 7.0 database.

Does any one know of a product or utility which would permit us to do the
comparison of database objects between a mssql 6.5  and a mmsql 7.0 database
(after migration from 6.5 to 7.0)?

Any information which can be porvided would be very helpful.



2. bcp routine

3. upgrade of MSSQL 6.5 to MSSQL 2000


5. Backup in MSSQL 6.5 and restore to MSSQL 7.0

6. ERROR r installing SQL server?

7. Drop table error in MSSQL 6.5 and MSSQL 2000

8. set mssql 7.0 compatible to mssql 6.5?

9. Administering MSSQL 6.5 using EM from MSSQL 7.0

10. import/export MSSQL 6.5 and MSSQL 7.0

11. systypes in mssql compatibility mode for mssql 6.5?

12. Administerring MsSQL 6.5 using EM from MSSQL 7.0?