I want to be able to see if stored procedures are supported on (almost any)
platform. I noticed if I connect to some ODBC sources with the OLE-DB provider
I can do
cn.properties("Stored Procedures")

But this property doesn't exist on SQL Server.

So the question is how can I reliably check if a stored procedure is supported.
The point is I will call the stored procedure if it is supported I will have created it otherwise I will execute SQL. I suppose I could just call it and trap the error but I was hoping to use a property if one existed?

Thanks...