Advertisement

12.14.2007 at 04:09PM PST, ID: 23024942
[x]
Attachment Details

MSSQL Triggers, multiple ouputs, sp's and more

Asked by the_b1ackfox in SQL Server 2005

Tags: mssql, trigger

I have two databases in which I am attempting to two seperate tables in sync.  The application which came with the DB #2 is crummy and keeps on crashing.  I have checked out the source and destination tables  and have mapped a potential solution to my woes...   but I need some help.    From DB1, when it's table is updated or a row is inserted, I want to extract the common reference with a trigger...  easy as pie... then (this is where I have no footing...)  I want to run a stored procedure using the common reference (soI have the associated data with the reference... then I want to take that info, and connect to a table located on db2 and do an insert.  The sp should give me like 5 bits of data... but I don't know how to get the data from the sp to the insert....  Start Free Trial
 
Keywords: MSSQL Triggers, multiple ouputs, sp…
Title
1 Problem query that works under MSSQ…
2 Ouput to XML
3 Convertion MSSql to DB2
4 MsSQL -> MySQL Sync
5 Footing ... @
6 Copy of DB2 Needed - Which to Use?
 
Loading Advertisement...
 
[+][-]12.14.2007 at 06:28PM PST, ID: 20475824

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]12.14.2007 at 06:34PM PST, ID: 20475852

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]12.15.2007 at 12:22AM PST, ID: 20476596

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.15.2007 at 05:42AM PST, ID: 20477384

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.15.2007 at 05:52AM PST, ID: 20477397

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.15.2007 at 06:00AM PST, ID: 20477420

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.17.2007 at 11:03AM PST, ID: 20486969

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.17.2007 at 11:08AM PST, ID: 20486997

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 12:23AM PST, ID: 20490584

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 12:29AM PST, ID: 20490599

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 12:36AM PST, ID: 20490615

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 12:49AM PST, ID: 20490657

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 02:18AM PST, ID: 20490967

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.18.2007 at 02:29AM PST, ID: 20491011

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: mssql, trigger
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 3
Solution Grade: A
 
 
[+][-]12.18.2007 at 02:50AM PST, ID: 20491086

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628