Hi All,
I would like to whether the following details is possible ::
1. 'How Many TSQL Statements Is Executed within a particular time frame say 8 hours and at the end of 8 hours i want a script to be generated of all that TSQL statements Like [Insert, Update, Delete and so on] and then i want this TSQL scripts to be read by a window Service which is installed locally.
2. After the above step i want my Windows Service to send this script to the web service
3. I had a web page remotely which will call this web service and execute the script on the local database which will execute all the script and update the database there.
Firstly i would like to know whether it is possible and if yes then please provide me help with some technical details regarding the same. All this is done through Dot Net..
Your help will be highly appreciated.
Thanks in advance.