MS-SQL 2005 Database Name

Question

MS-SQL 2005 Database Name

m_wp

Grasshopper

Points: 20
More actions
July 26, 2010 at 11:46 am

#227243

Hi,
Can I have more than one database name associated to only one and unique database ?
Example:
AdventureWorks is the database name
I would like to have: AW as database name pointed to AdventureWorks.
Here is the reason: Every time users need to type the long database name.
Thanks
Marcos

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

jvanderberg SSCertifiable Points: 6762 More actions · Answer 1

You can create synonyms for individual database objects, but not the database itself. To do it, the database AW would have to already exist, and then a synonym would have to be created for each object (table, view, stored procedure, etc.) that needs to be accessed. Unless there is only a handful, this is probably way to tedious for what you're trying to do. It would also be difficult to maintain.

--J

m_wp Grasshopper Points: 20 More actions · Answer 2

Thanks -j !

This will be a lot of work. I would leave as it is.

Just trying to make the life easier for our users.

Marcos

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

m_wp (7/26/2010)
Hi,
Here is the reason: Every time users need to type the long database name.

I am curious as to why the users are typing the database name?

An option that could work is to restore the database as a different name.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

m_wp Grasshopper Points: 20 More actions · Answer 4

the user has an option to choose which database they want to access to through a handheld machine.

it is a possibility renaming the database, I will think about it, although it is too complicated..sql permissions, backup routines, etc.

thanks anyway.

jvanderberg SSCertifiable Points: 6762 More actions · Answer 5

Do you have any control of the application? Can you give them a drop-down list? You want to limit their options as much as possible.

m_wp Grasshopper Points: 20 More actions · Answer 6

unfortunately, I don't, but I will suggest this to our development department.

thx -J!

sturner SSC-Insane Points: 22411 More actions · Answer 7

rename the database.

The probability of survival is inversely proportional to the angle of arrival.