How do you run a system stored procedure

How do you run a system stored procedure

Run a system stored procedure

To run a system-stored procedure, you can use the following codes.

'OPEN CONNECTION AND GET RECORDSET
Set objADOConn = Server.CreateObject("ADODB.Connection")
objADOConn.Open "dsn=webPUBS;uid=sa;pwd="
Set objRst = Server.CreateObject("ADODB.Recordset")

'GET RECORDSET VIA STORED PROCEDURE
strSQL = "EXEC sp_helpdb"

objRst.Source = strSQL

Set objRst.ActiveConnection = objADOConn
objRst.Open