search for: sysindexes

Dear all, I need to test for the existence of an index on a table. This cannot be done with sqlPrimaryKeys as it is not a primary key. Therefore I select directly from the systemtable of SQL-Server 2000 named sysindexes. This works well with RODBC Version 1.2-5 but not with version 1.3-0. Here is the code of the test example: sink(file = "proto.txt", append = FALSE, type = "output",split = TRUE) library(RODBC) sessionInfo() str <- "DRIVER=SQL Server;SERVER=NN;APP=Test;DATABASE=Nort...