Here's how you would call 'byroyalty' stored procedure from 'pubs' DB.

Rs.Open("Exec byroyalty 40", oConn)
-- or
lcSql = "Exec byroyalty 40"
oRs.Open(lcSql, oConn)

>Hi
>
>Pl Any one help me, to get record set from SQL server store proc ?
>
>Here is my code...
>
>rs = CREATEOBJECT('ADODB.recordset')
>rs.cursorType = 1
>rs.OPEN(lcSQL,oConn)
>
>rs is recordset object
>oConn is connection object
>lcsql is sql server store proc
>
>When it is a simple select statement then it works fine , but when i use
>lcSql as some store proc ( store proc has SQL statement and it will return
>more than one record )
>
>I do not know what i have to pass in OPEN method OR what to set in
>recordset object... that will return me a recordset ( recordcount must be
>> 0 )
>
>
>Thanks
>Mihir