Table change Watch In SQL 2000
-
Hi, Is there anyway to have SQL Server 2000 run a function on a database if a specific table is updated or a row added? my problem is this I am having to work with two seperate databses for 2 sepreate programs, I need data from the first program in my second program, but if anybody adds a new row or record to my table in database 1, I want to update the table in my second database using an sql server auto function, and the server must run a change on db2 if the table in db 1 is changed. I hope this made sense, the main reason for doing this I do not have access to the source code for the first program so this must happen on the DB side.
-
Hi, Is there anyway to have SQL Server 2000 run a function on a database if a specific table is updated or a row added? my problem is this I am having to work with two seperate databses for 2 sepreate programs, I need data from the first program in my second program, but if anybody adds a new row or record to my table in database 1, I want to update the table in my second database using an sql server auto function, and the server must run a change on db2 if the table in db 1 is changed. I hope this made sense, the main reason for doing this I do not have access to the source code for the first program so this must happen on the DB side.