I have tried using the DBCC updateusage('master') with count_rows

and sp_updatestats.

But still I am getting different values in fileproperty and .

Can anyone try this out and tell me why this is...

is there any query that says whether that particular instance is installed on a cluster or not??!!!

Hi

    I just need one more clarification....I dont hav the privilege to do a DBCC update...so I cannot use sp_spaceused with @updateusage parameter. therefore can I use the select...

Hi All

      I just went through the implementation sp_spaceused of SQLServer2005 and I am most certain that they have included the non-clustered indexes also for the space calculation..The non-clustered...

thanks for the reply guys...that was really helpful and I will let you all know if theres any difference in the implementation of sp_spaceused from 2000....

-Vijay

Hi peterhe

     How to get the implementation for the system stored procedures??!!!

     Thanks for the reply.

Vijay

Hi

     select * from sys.dm_db_index_physical_stats (database_id, null, null, null, 'detailed') by default will work only for certain databases..

      grant control server to user_name

use this statement to make it work for all...

thanks for the reply guys...

-Vijay

thanks a lot.....

Sergiy, thanks for correcting me....I didnt notice the datatype is ntext and I was talking about varchar.

sry folks, I havent looked it carefully..will be more careful from now on.

-Vijay

Hi

   There is a limitation to the maximum size of a record in SQL Server 2000.

the combined size of all the columns in a row can be 8060 bytes(max)--refer...