Have you enabled full-text indexing for the database?

try this out,

select top 3 * from YourTable

except

select top 2 * from YourTable

or you can use ROW_NUMBER()

;WITH OrderTable AS

(SELECT *,

ROW_NUMBER() OVER (order by id)as RowNumber

FROM YourTable )

SELECT *

FROM...

Write a procedure to do this, it should be fairly straight foward, do you have a date/time field to work out what the old data is?

post some more information...

Its TV.

It depicts the work of a crime scene investigator about as accurately as Boston Legal does Lawyers.

Jack nailed it on the head here:

I agree with this , a candidate should be...

Again i would say that it depends on your needs and budget, have a look...

You definitely can have 3 databases running on one server, whether this is better thatn running them on seperate servers would depend on a few factors, such as size...

you could do this using group by

SELECT FirstName, LastName, COUNT(SSN) AS SSNCount

FROM YourTable

GROUP BY FirstName, LastName

HAVING ...

It is hard to say what the best way to do this without seeing the table and some data,

post the table def and some sample data and I am sure...

Check the SQL server logs to see what the error number is this will give you a clue as to why the login has failed.

I also would not reccommend using...

The way i would approach this would be to load all the data into SQL table with duplicates, make sure you include an unique id.

Then use Select Distinct, or another...

You should be able to double-click on the error message text and it will take you to the offending line.

Without any ID or order it is hard to see why you would need this, but...

You will need to delete the duplicate row before creating the unique constraint.

Check the strored procs and front-end code that you use to insert data for a bug that may be causing this.

If you are not allowed to have duplicates of IDs...