Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bt7403
  • Content: Threads
  • Order by date
  1. bt7403

    Run Delete trigger from Server A to Server B

    I need to create a trigger on Server A to delete two tables on Server B. Tables are same name and replicated. The trigger would run after replication successful on Server A. Pls. advise on syntax for accessing Server B table from Server A.
  2. bt7403

    Run SQL job based on record insert in table

    I need to run sql job based on a record being inserted to a table. The record gets inserted baed on merge replication from other clients, after insert I want a job to invoke. How to make this happen? running SQL 2K5-familiar w/ running sql jobs, never used triggers-not sure how to create...
  3. bt7403

    can't insert MSCOMM object in Excel form

    Using Excel 2002 on NT4 box can not add MSCOMM.ocx object to worksheet-error msg. 'can't insert object' no further help. Pls. advise on how to add object. thx..bt
  4. bt7403

    SQL Job Agent-Record Locking issue

    I have a SQL job w/ 5 steps: 1. Fetch records routine and update Table A 2. run SSIS pkg. 3. delete records from Table B 4. delete records from Table A 5. delete records from Table C Although Step 1 ran okay, update could not perform because values were not avail. at the time. However the...
  5. bt7403

    How to trigger SSIS pkg to run

    I have two SQL jobs running on set schedule (every 15mins.) One job is a Fetch routine; the second job is an SSIS pkg. My concerns are decreased db performance as these jobs consume alot of time to execute. I can add both job tasks into one SQL job to run, but I want a trigger to execute the...

Part and Inventory Search

Back
Top