Post reply

Alias a database??

  • April 30, 2007 at 3:39 pm

    #119846

    Hi All:

    Does anyone know if it is possible to alias a database?

    Thanks

    Bill

  • May 1, 2007 at 7:32 am

    #703530

    Not sure if you can alias a database name.  However, you can setup aliases for the server name using the SQL Client Network Utility.

    Have a good day,

    Norene Malaney

  • May 1, 2007 at 11:11 am

    #703618

    you can use a Linked-Server [yuch!] as an indirection pointer, or on SQL2005 you can

    CREATE SYNONYM [ schema_name_1. ] synonym_name FOR < object >< object > :: ={    [ server_name.[ database_name ] . [ schema_name_2 ].| database_name . [ schema_name_2 ].| schema_name_2. ] object_name}

  • May 1, 2007 at 11:26 am

    #703625

    After sleeping on this, I think that I might be able to setup a redirect through the local ODBC connector on the workstation???

    I'll let everyone know

    Thanks

    Bill

Viewing 4 posts - 1 through 3 (of 3 total)

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