Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
duplicate index key problem
the duplicate index key message is from my application (delphi). i dont really know whether the problem is application related or not. i just know that import/export, which clears the _WA_Sys system statistics resolves the problem till the next time. it currently happens once every couple of...- JohnMcM
- Post #3
- Forum: Microsoft SQL Server: Programming
-
duplicate index key problem
sql 7 adds additional indexes automatically with useage. the names of these indexes can be seen in sysindexes.name and start with "_WS_Sys_". over time, more and more are created. eventually the application comes up with "duplicate index key". my only solution at the...- JohnMcM
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
