Restart ur services or detach the database and attach it

i hav created the clustered index but the result is same as it was...

DBCC SHOWCONTIG scanning 'table' table...

Table: 'DEVICE_USER_LINK' (161695924); index ID: 1, database ID: 5

TABLE level scan performed.

- Pages Scanned................................: 15794

- Extents Scanned..............................: 1993

- Extent Switches..............................: 1992

- Avg. Pages per Extent........................: 7.9

-...

CHECKALLOC found 0 allocation errors and 0 consistency errors in database 'abc'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

AFTER CHECKALLOC

DBCC SHOWCONTIG scanning 'TABLE' table...

Table: 'TABLE'...

i dnt hav an heap table there are non clustered index ....... waiting for a good reply .....

check each and every thing if u r using this counters and u r getting the values out of the range then add additional ram into ur server .

Try to...

use this command

set rowcount 1000000