Distributed Stored Procedures
From: Kofi (kofi_at_ibeaminc.com)
Date: 02/26/04
- Next message: Daniel Brodsky: "Re: Bug in Visio?"
- Previous message: Tibor Karaszi: "Re: Stored Proc rights and joinning to another database"
- Next in thread: Nico De Greef: "Re: Distributed Stored Procedures"
- Reply: Nico De Greef: "Re: Distributed Stored Procedures"
- Reply: mountain man: "Re: Distributed Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: 26 Feb 2004 08:00:26 -0800
I have an SQL Server that has a structure as follows.
1. There is a common database that contains hundreds of stored
procedures.
2. There are also 50+ identical databases, with the same number of
tables and table structures.
3. The common stored procedures must be able to read/write data to any
of these 50+ databases. How can this be done? I can pass the database
names as a parameter in the stored procedures but that means changing
hundreds of stored procedures and over 500K lines of application code.
Is there a way I can let the stored procedures read/write to these
databases without doing all of this?
Any help will be really appreciated
- Next message: Daniel Brodsky: "Re: Bug in Visio?"
- Previous message: Tibor Karaszi: "Re: Stored Proc rights and joinning to another database"
- Next in thread: Nico De Greef: "Re: Distributed Stored Procedures"
- Reply: Nico De Greef: "Re: Distributed Stored Procedures"
- Reply: mountain man: "Re: Distributed Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
