Newbie Spellweaver
- Joined
- Aug 21, 2008
- Messages
- 7
- Reaction score
- 0
how do i find dupes in my db and delete them?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
EXEC RunDupeCheck2 'Typenameofuseryouwanttocheckhere'
EXEC RunDupeCheckInn 'Typenameofuseryouwanttocheckhere'
Write your own script, or you will never understand how it actually works.Check if you have the procedures :
RunDupeCheck2
RunDupeCheck
RunDupeCheckInn
To detect a dupe start up the Query Analyzer (MSSQL 2000)or "New Query" (MSSQL 2005). Type in :
EXEC RunDupeCheck2 'Typenameofuseryouwanttocheckhere'
EXEC RunDupeCheckInn 'Typenameofuseryouwanttocheckhere'
If you have any problems just tell me.