Very Computer

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

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.