Ok the first one i used is :

DELETE

FROM dbo.SMRights

WHERE gRightSID NOT IN

(

SELECT a.gRightSID

FROM (select row_number() over( partition by cRightID,cDesc,cDataDef,cGroup,cHelp,cDataHelp

order by cHelp) as rownum, gRightSID from dbo.SMRights)

a where a.rownum=2)

I...

So you are saying that these error messages are ignorable? and I should keep running the query and it will remove the duplicates from the table?

Guys, thank you for your reply,

But i am getting this error:

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Msg...

Hi gheorghiu_horatiu,

There is a problem at the last statement near the where clause

a where a.rownum=2)

Thank you for your reply,

In the task manager under processes tab it showed that sql service is using about 6.67 gb of ram alone