triggers

[jacob94]

Is it possible to set a trigger on a sql server table and have it append results to another sql database on another server (I have access to all servers).

If so, does it put more strain on the trigger?
Is this done through linked server?
I want to avoid a DTS if possible.

Please let me know some thoughts on accomplishing this.

Thanks.

 

[ptheriault]

yes you can do that with a trigger, You would have to use a link server. As far as added "strain" on the server that depends on how large the transaction is. What are you trying to accomplish? There are also other methods of moving data from one SQL Server to another. Like transactional replication or log shipping if you needed to keep the a whole database insync with a primary database.

- Paul
- Database performance looks fine, it must be the Network!

 

[jacob94]

Thanks for the feedback. I need to fire a trigger when records in a table are updated or inserted on.

Is it possible to only fire the trigger if a field that is updated on or added meets a certain criteria?

I want to ship records over to another server's database if the Type field = 'SHIP'.

I really don't want the trigger to fire everytime their is an update or insert just rather if a record meets the criteria above and I am not sure that is possible...

Any more help on this and the linked server would be great.

 

[ptheriault]

a trigger is going to fire on a DML event. you can not specify for it to fire only when your field is 'SHIP'. Check out triggers in BOL.
Here is a link on how to create a link server.

http://www.databasejournal.com/features/mssql/article.php/3116011

- Paul
- Database performance looks fine, it must be the Network!