This content has been marked as final. Show 4 replies
In regular SQL, we can open the management studio and run a query in the database to list all the table sizes. If you can do that with your version, you'll have a head start. Good luck.
Thanks for the info. I am not a SQL person and don't know how to query for table size. We do have SQL Studio Management Express 2005 installed. When I click the database and click "new query" it opens up some command windows looking for some sql commands. How do I query the table size within Studio Management.
Just found the SQL query on the internet. It is listed below:
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
It is showing that the biggest table we have is the EPOProductSettings table. Does anyone know why that table would keep growing and how to clear it out?
That may be the lasgest table but hopefully you will run the query again to find out if it's growing.
I was using dbcc checkdb (epo4_epo45) with the ('s to find out how many rows are in my tables and comparing them over time.
I do not know the resolution for your particular issue. Good luck.
Are product settings the policies? Is there a policy migrator that keeps running?