Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is aliasing possible for a database name?
Message
De
30/09/2002 17:30:36
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Is aliasing possible for a database name?
Divers
Thread ID:
00706151
Message ID:
00706151
Vues:
52
I am working with a pre-existing sql script. The sql script gets called from an Exe that I don't have the source for (visual accountmate). The script is designed to be used 'generically' insofar as you use the executable program to specify the name of the target database to populate - in my case 'bss'.
But all the code in the script references a database name ms501 - e.g.

insert into ms501.dbo.arcust

When the script finishes executing - my database - bss - has been populated. Even while running - I see no reference to ms501 in enterprise manager. My question is: Is it possible to 'alias' the database name - not a table - the database. I am guessing that such a transact sql statement or sp - is called in the exe befor the sql script runs.

Otherwise, how would the system know to populate 'bss' when the references are to ms501.

TIA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform