Re: Return Results of sp_helptext via ADO

Solved:

needed to execute fllowing against server, as opposed to sp_helptext
directly:

'basic sql for getting stored procedure text
strSQLStoredProcBase = "select syscomments.text From sysobjects,
syscomments " & _
"where sysobjects.id = syscomments.id and sysobjects.type =
'P' " & _
"and sysobjects.name = '"

then loop through recordset, appending row to prvious:

'evaluates error, if no recordset, writes error message
'else, write stored proc
If adorsStoredProcText.EOF Or adorsStoredProcText.EOF Then

daorsStoredProcs(1) = "Stored procedure not found or
resulted in error"

Else

'sets stored proc text to string
'loops to concatenate stored proc text as string
While Not adorsStoredProcText.EOF

strStoredProcText = strStoredProcText &
adorsStoredProcText(0)

adorsStoredProcText.MoveNext

Wend

.

Relevant Pages