There's not one solution. It will be different for each database.
>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...
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer