Thankyou. I found it easier to do the querying from Visual Basic. Just grouped the data by Email field. Compared ist record with the next record. If email matched, then...

Thanks for your reply. In Master database and one other Existing database in SqlServer7.0, there are storedProcedures starting with names

dt_******* with type='System'. I was trying to understand how they were...