Monday, May 09, 2011

See table usage of Dynamics CRM in SQL Server

How we can see which table is how many rows and index size etc etc

1. OPEN Query analyzer of SQL Server
2. OPEN MS CRM database

Run the query like this

exec sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

It will show you all table statistics with index size, row size etc etc.

Hopeful it will help

Regards,
Imran


[MVP CRM] = https://mvp.support.microsoft.com/profile/imran.mustafa

MSN/IM= mscrmexpert@gmail.com
SKYPE= mscrmexpert
BLOG= http://microsoftcrm3.blogspot.com
Linkedin = http://www.linkedin.com/in/mscrmexpert
Twitter = @mscrmexpert