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 |
|
ayeletd
Starting Member
1 Post |
 Posted - 2009-02-24 : 09:55:57
|
| Hello.I have queries incoming into my DB which are out of my direct control (performed from an external app). I would like to trap these queries and change them so to get better results. Is there any way to trap incoming queries?Thanks,A. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 09:59:41
|
| With SQL profiler with applied filter. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-24 : 10:00:07
|
| Read about plan guides in BOL or online. They're meant for exactly this type of situation. You can't change the query so much as control the exec plan but it should help.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Repleacing incoming queries