Thanks for the Great Info 🙂

I resolved my issue by recreating the Index.

However the above query which you have written is not working. it is not returning the...

Thanks for your reply.

It is very useful. But how could i know what are the indexes and constraints on column..?

and second is some one has created the indexes and...

Thanks,

Thanks,

It is not upgraded. I have used DBCC UpdateUsage it will work. However it is taking some time. I want to an alternative for that.. ?

I am using sysindexes for Server 2000 and

sys.allocation_units for 2005 and up, to get the reservedpages ( Allocated Size).

is it enough to get accurate values.. ?

Thanks In Advance

Kumar

Actually i am working with alarms. for that i am using the formula

unallocated_size=Size-allocated_size (getting from sysindexes);

as transaction log full, finally i am getting the negative unallocated size, which invoking...

It is MsSql 2005 and up, that too i am dealing with database of size 20 to 50 GB. and i need to get the accurate size of the database...