Mapping Tables within different databases with a Stored Proc

Good Day:

We are working on a web application project utilizing SQL Server 7 SP3 and ASP. Through the year our client has developed and is currently utilizing multiple databases on the server. These databases have certain tables that are similar and need to be updated simultaneously in real-time.

We could create a single ASP page that would update all databses, but we are looking for a more elegant approach on the DB Server's end. The solution we have envisioned is one where updating one table would set off a trigger that would run a particular stored procedure to update all other tables in various databases.

Is this solution possible within SQL Server? If so, do you have any useful resources to which you could point us? We have had no luck on MSDN nor on MSKB. So, any constructive input you may have will be quite helpful and much appreciated.




Happy Computing,
Arash Sayadi
15530-B Rockfield Blvd. Suite 4
Irvine, CA 92618
949-830-1623 x36
949-830-2120 Fax
www.pts1.com
arashs@pts1.com


Comments

  • : Good Day:
    :
    : We are working on a web application project utilizing SQL Server 7 SP3 and ASP. Through the year our client has developed and is currently utilizing multiple databases on the server. These databases have certain tables that are similar and need to be updated simultaneously in real-time.
    :
    : We could create a single ASP page that would update all databses, but we are looking for a more elegant approach on the DB Server's end. The solution we have envisioned is one where updating one table would set off a trigger that would run a particular stored procedure to update all other tables in various databases.
    :
    : Is this solution possible within SQL Server? If so, do you have any useful resources to which you could point us? We have had no luck on MSDN nor on MSKB. So, any constructive input you may have will be quite helpful and much appreciated.
    :
    :
    :
    : Happy Computing,
    : Arash Sayadi
    : 15530-B Rockfield Blvd. Suite 4
    : Irvine, CA 92618
    : 949-830-1623 x36
    : 949-830-2120 Fax
    : www.pts1.com
    : arashs@pts1.com
    :
    :

    A few great web site i would recommend is:

    - www.sqlperformance.com
    - www.sqlwire.com
    - www.searchdatabase.com
    - www.devex.com


    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion