The idea is to let me know if the database has only 10% space. I used sp_helpfile to get the current size and max size. Since my database reach the...

I used DBCC INDEXDEFRAG and I think I didn't run DBCC DBREINDEX properly.

Thanks all

Thanks everyone,

I ran DBCC DBREINDEX ('Actions') also dbcc dbreindex ('actions','',80) which give me

DBCC SHOWCONTIG scanning 'actions' table...

Table: 'actions' (199671759); index ID: 1, database ID: 76

TABLE level scan performed.

- Pages Scanned................................: 2396

- Extents Scanned..............................: 1208

- Extent Switches..............................: 1489

- Avg. Pages per Extent........................: 2.0

-...

Sorry, I forgot the table has a clustered index

I don't own the database so I got a limited space. Since the company I'm working for is small, I deal with almost everything.

The table contains only int and varchar(255).

Yup, I tried to recreate the indexes or Defragmenting an Index with no luck.

I a web developer, so I'm not that good at database admin stuff 

Is...

Thanks for your reply Ninja,

I already use dbcc updateusage ('database_name','table_name') or sp_spaceused 'table_name', 'true' and little has change

My alert gets the database size and max size from sp_helpfile.

I assumed that...