[Help] how to find dupes?

[metalic054]

how do i find dupes in my db and delete them?

 

[equalled]

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.

 

[metalic054]

ty, i already know that but don't know how to find the dupes and would be good if someone posted something that finds duped serial codes on items

 

[spamman]

write a procedure yourself.

 

[powwow]

bump

 

[spamman]

no1 here is going to be able to tell you what you ask. they will only give you things other people wrote.
A perfect example of this is

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.

Write your own script, or you will never understand how it actually works.

 

[metalic054]

bump still need help on this

 

[DJ_skinner]

If ur DB has 1000 Users it means u have to do it 1 by 1.. isnt there a script that can check the entire DB by getting the user ID's from TB_User table?

 

[396259877]

Code:
EXEC RunDupeCheck2 'Typenameofuseryouwanttocheckhere'

EXEC RunDupeCheckInn 'Typenameofuseryouwanttocheckhere'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~``
after it what will happen?i dont understant so pls tell me up