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...
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement