locked
Trigger Problem RRS feed

  • Question

  • User-1615062673 posted

    I Created a Trigger on a Table(maintable)

    when a Records is inserted in that table(maintable) trigger is fire and it insert tha data in other database table using link.

    but some time the otherdatabase connection not found and it give me the error.

    Here i want to make a condition that it will insert the data in otherdb only when connection found otherwise it only insert in the maintable

     

    Thanx...

    Monday, July 9, 2012 9:05 AM

All replies

  • User-661350001 posted

    what do you mean by otherdatabase connection not found is server not available ?

    Monday, July 9, 2012 10:56 AM