Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
explore_db
Starting Member
2 Posts |
 Posted - 2007-09-21 : 01:09:26
|
| Hi, I want to know is there any way by which we can come to know which query is going to be executed by the Engine prior to its execution. I think if this is possible then this will affect the performance. But It will be very helpful for me. Is this is possible and how we can achieve this. Plz help me out its very urgent . Thanks for the help in Advanced.Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-21 : 03:23:53
|
| Are you meaning the output you can get from SQL Profiler?Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-21 : 23:27:27
|
| Imporssible, just like I don't know what you'll say before you say anything. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-21 : 23:32:47
|
What are you trying to do with this information? As Kristen said you can use profiler to get the queries that are being processed real time. Are you trying to perform an action based on the information?
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-22 : 22:43:59
|
| What explore_db asked is to let sql act as code reviewer, doesn't run any 'bad' query. |
|
|
|
explore_db
Starting Member
2 Posts |
Posted - 2007-09-24 : 02:47:34
|
| I want that let sql act as code reviewer , and if there is any bad query for example (delete ,drop ,truncate ) then it should be avoid. I want to make an User Interface that alert if anyone is trying to do such ,and if someone delete or drop or truncate then it will take back up of the table. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-24 : 03:01:00
|
| Setting appropriate permissions will take care of DELETE, DROP and TRUNCATEKristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-24 : 23:31:55
|
| And use trigger to save data. |
|
|
|
|
|
|
Query Execution............