Is there any permanent solution for this issue?

It is happened recently... Before that i could able to create jobs and all...

now when i open the SSMS and in the 1st attempt i can edit/create job.. when...

Yes. When I rebuild the clustered Index ,I am Getting the result and it returns all the rows.

select * from tablename where field_id =2 returns the row.

But Why it...

CREATE NONCLUSTERED INDEX [IX_FIS_Pub_Author_Publication_ID] ON [dbo].[FIS_Publication_Author]

(

[Publication_ID] ASC,

[IsDeleted] ASC

)

INCLUDE ( [Author_ID],

[Seq_No]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE...

If we force clustered index it is display all the columns .

select * from <table_name> with (index (cluster index name>)) where field_id = 2

its gets result.

Execution plan attached

No. It is Table.

Column_name Type LengthNullable

Publication_Author_IDbigint8 no ...

Here is the attachment

Thanks a lot!!!!

Yes I got the solution !!

SELECT Column1

FROM

(SELECT ROW_NUMBER() OVER (PARTITION BY Column1 ORDER BY Column1) As RNO, Column1

from

<Table_Name>)A WHERE RNO = 1

Thanks a lot !!!