Tim,
You could check the sysobjects table:
SQLEXEC(nSql, "SELECT name from sysobjects WHERE type='P' and name= < YourSproc > ", "CheckSproc")
IF RECCOUNT("CheckSproc")=1
ELSE
ENDIF
HTH
>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...
Daniel