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 mydatabase", "rtrnCursor" )
SQLExec( handle, "SP_HELPINDEX mytable", "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...
Previous
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