Database Alias

Hello everyone,
Does anyone know if it is possible to create a database
aliase for an existing database name in SQL Server 2000
Enterprise Edition.Can you give an example of what you would want to do with this? There isn't
a specific ALIAS DATABASE command. But perhaps we can offer a suggestion
that meets your need if we know why you would want to alias the DB name.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Liz" <lrodriguez@.sanantonio.gov> wrote in message
news:06a101c37724$7668e620$a301280a@.phx.gbl...
> Hello everyone,
> Does anyone know if it is possible to create a database
> aliase for an existing database name in SQL Server 2000
> Enterprise Edition.|||We have over 100 users linking to SQL Server via MS Access and oppose to
modifying their odbc connection with new database name I was wondering
if there was a way to create a database alias name.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!