can i get some operation infomation from SQLsrv2k ?
-
i thought SQLsrv2k had a interface for 3rd part software to gain operation infomation. For example, while a record is inserted into a table, the 3rd part software might get this information. also it might like the windows message mechanism, any operation may produce a message to windows or others. is this possible ?
-
i thought SQLsrv2k had a interface for 3rd part software to gain operation infomation. For example, while a record is inserted into a table, the 3rd part software might get this information. also it might like the windows message mechanism, any operation may produce a message to windows or others. is this possible ?
DO you mean TRIGGERS? Can set one up On insert / update / delete which can then execute code inside SQL Server, or do you mean the ability for a third party app to recieve change notification? "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
-
DO you mean TRIGGERS? Can set one up On insert / update / delete which can then execute code inside SQL Server, or do you mean the ability for a third party app to recieve change notification? "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
Triggers might be a solution for this. But it need to modify the database. So i prefer a third party application to do this without modify the database. i thought it can receive change notification like windows hook doing. where can i start ? And is there aother way ?
-
Triggers might be a solution for this. But it need to modify the database. So i prefer a third party application to do this without modify the database. i thought it can receive change notification like windows hook doing. where can i start ? And is there aother way ?
Think that you would struggle to do it - the 3rd party app would need to constantly poll the DB looking for changes, which at best would affect performance! "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox