Found..ITs a bug in MSSQL 2005.

http://support.microsoft.com/kb/2006312

top 5th Salary of every department

SELECT * FROM (

SELECT EMP_ID, DEPT_ID, SALARY, NAME

,RANK() OVER (PARTITION BY DEPT_ID ORDER BY SALARY DESC) AS RANKID

FROM EMP) A WHERE RANKID = 5

This is quite a contrary queston..The max size of the database is a capacity planning chapter. If your Physical server can support, you can have a DB size in TB's....

This is indeed amazing, However, there is a possiblity that sometimes the sysobjects table may go correct and so the Database engine does not finds the table.

Possible reason ??

The duplicate records delete query solved my issues.. thanks to the community..