I want to make a trigger on a table in my internal database (SQL Server 2008) that executes a stored procedure on an external database(SQL Server 2005) when a row is inserted with a certain value.
Database 1 - Table A
> When a row is inserted AND the value of Field A is 1 then the trigger is fired
> The trigger executes a stored procedure on an External database
How do i do this ?
- How can i link the two servers ? Do i have to adapt security settings ?
- How do i have to built the trigger ?