Posted by Marcin A. Guzowski on 04/11/07 17:44

wjreichard@comcast.net wrote:
> OK ... I am using UPS Worldship that issues an ODBC query to my MS2K
> server ... Worldship can query either a table or a view and retreive
> shipping info for a supplied orderid.
> (..)
> If not is there some other way I can create a DB table and run a
> select against it ... based on the Worldship query?


IMHO you won't get successful this way...

Perhaps SQL Server trace would be a solution?
You could capture all select queries executed against shipping
table/view and insert collected data into a table and then enforce
particular logic. The question is: how fast do you need the information
that certain orderid was retrieved? The only problem with trace-based
solution is that it can be potentially not fast enough.. (you can't read
the most current trace file if the trace is still running).

You may also try to implement some kind of 'select trigger':
http://solidqualitylearning.com/blogs/dejan/archive/2004/11/25/214.aspx



--
Best regards,
Marcin Guzowski
http://guzowski.info

[Back to original message]