How can I create database alias?

[vladibo]

How can I create database alias?

I have database with name MYDB_ARCHIVE but I want to call it to MYDB_CLIENT_ARCHIVE (it is required by the software that uses database) but I don't want to rename my database. Can I create just another alias with name MYDB_CLIENT_ARCHIVE that points to MYDB_ARCHIVE?

Thank you

 

[donutman]

I believe there must be a way because their is an alias column in sysservers. You might read up on linked servers in BOL.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[donutman]

Ooops. I was thinking servers and you said database. And on top of it I was wrong there is no column for alias, but there is one for the servername.
Don't know of any way.
-Karl

 

[donutman]

Hmm. What about creating an ODBC DSN on the appropriate workstations?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[SonOfEmidec1100]

I dont believe you can, I had a similar requirement a few years ago, albeit with SQL65 but never solved it - ended up changing the name.

donutman - the question is about databases not servers or am I missing something.

 

[SonOfEmidec1100]

donutman apologies, too quick on the submit.

Your DSN solution made me stop and think, but my problem was a bit more complex - there were several databases with references to the names in views and SPs and lastly the CUSTOMER insisted the names comply with their standards.

such is life.

 

[mrdenny]

There are no aliases within MS SQL Server databases. (Except for the one mentioned with linked servers.)

Denny

--Anything is possible. All it takes is a little research. (Me)