General information
Title:
SP_HELPINDEX via ODBC
In SQL-Server, there is a stored procedure called SP_HELPINDEX which given a parameter of a table will return a cursor of all the indexes and expressions associated with it.
While doing some processing, I want to make sure that if the tables already existed that I don't try to re-create the indexes. So I have in place the methodology to be sure to issue an ODBC call with
SQLExec( handle, "USE ", "rtrnCursor" )
SQLExec( handle, "SP_HELPINDEX ", "rtrnCursor2" )
I always get no result set on the second call... Am I missing something simple? or does the original connection to SQL-Server identify which is the default database to be associated with for each SQLExec() being issued?
Any input appreciated...
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only