I don´t know if it is possible to prevent SQL server 2005 from writing a query or a command to the cache!
I´m writing a procedure witch witch will get the unpaid invoices and send them by SMS to the customers mobile.
while writing the procedure SQL buffers the URL witch I´m sending to the webbservice that means that I´m geting every time the same result from the sebbservice if the URL is not changing.
Is there any ideas how to go arround the problem I´m wring the procedure in a production envirement?
View Complete Post