Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored Procedures for many databases
Message
De
09/04/2001 14:27:30
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Stored Procedures for many databases
Divers
Thread ID:
00493692
Message ID:
00493692
Vues:
62
Hi All,

I currently have about 10 databases. One of the databases stores information about all the other databases. I want to write stored procedures that all dtabases will access without having to manage each procedure from within each database, since each will all be the same, respectively.

Is it acceptable to store all my procedures in one database where all my other databases will call the procedures?

Are there performance implications?

Thanks in advance....
Michael
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform