Triggering on SQL events originating from third-party application
-
We have a third party application that handles some SQL management (SQL Server 2000). We do not have the source code or any documentation on how this application works. In this third-party application, a user has to log on with some credentials and the application checks with a database if the username and password is correct. I don't know if this is possible, but what I would like to do, is to create an application that executes a certain list of commands on the database whenever someone tries to log on within the third-party application. Since I don't have the sourcecode to the third-party application I have to write another one that executes parallell to this one. My question is if it's possible for my application to know that the third-party application is executing a certain Stored-Procedure or a command. Are there any events/messages that I could catch? Any ideas would be appreciated ... Thanks // T