how to insert/update  7 different databases at the same time ?

Posted on 2011-05-11
Last Modified: 2013-11-05
i am using store procedure for my all the inserts and updates. Now based some condition i need to insert /update the details in the 7 different dabases. I have tried in the same store procedurte put its taking time and some time it is not inserted/updated properly in the all the 7 databses. Please provide me the solution for achive the task ...
Question by:Varshini
    LVL 51

    Expert Comment

    one sp in master db, 6 dblinks on others
    call sp @ master, it will insert into master table and 6 tables on dblinks...
    LVL 142

    Accepted Solution

    can you explain the scenario a bit having 7 databases?
    you might either check to use replication, or linked server in either direction to view/replicate data ...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now