Re: Querying multiple databases = multiple sets of sprocs?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike John (Mike.John_at_knowledgepool.spamtrap.com)
Date: 07/24/04 

Date: Sat, 24 Jul 2004 08:11:33 +0100

If your design requires many databases with the same table structure I would think again. If you have procedures in each database that "should" be the same you will be creating something very difficult to maintain. With "hundreds to thousands" of separate databases change control, and backup/recovery will all get extremely difficult!

Why do want/need so many dbs??

Mike John

"xs" <blizzardstorm8899@yahoo.com.sg> wrote in message news:%23iuegQUcEHA.2504@TK2MSFTNGP12.phx.gbl...
> Hi All,
>
> I am going to create lots of databases. At the mean time I don't know how
> many are there. In could be hundreds to thousands. I am creating an ASP.Net
> application to access these database using sprocs. Should I create a set of
> sprocs for each database or create only 1 set and execute it from a main
> database for easier maintainability?
>
>
>

Relevant Pages

  • Re: Limiting a user to only executing a stored only that access anothe
    ... Your suggestion of creating a db that only contains sprocs and ... login' does not exists in the db containing data. ... is created they can see iyr views tables, stored procs, and any other ... What I would like is to create another database, ...
    (microsoft.public.sqlserver.security)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... I dont see the risk with letting people create views and sprocs. ... them their own sandbox.. ... shit; i'll give each person their own database ...
    (microsoft.public.excel)
  • Deleting all SPROCS and UDFs
    ... I want to be able to delete all the SPROCS and UDF's in my DATABASE - pretty ... I want to do this in a QUERY - in query analyzer. ... I do not want to hardwire the names of each SPROC and UDF as more and more ...
    (microsoft.public.sqlserver.server)
  • Querying multiple databases = multiple sets of sprocs?
    ... application to access these database using sprocs. ... sprocs for each database or create only 1 set and execute it from a main ... database for easier maintainability? ...
    (microsoft.public.sqlserver.programming)
  • Re: defining keys and relationships in VBA
    ... Dim dbs As Database, tdf As TableDef ... Dim idx As Index ... > Dim dbs As Database, ...
    (microsoft.public.access.modulesdaovba)