<div>
It is not supported to directly query the Databases. Even a read query can introduce a lock that effects operation of the product.<br />
<br />
Consider using this space monitoring tool instead:<br />
<br />
<a href="http://www.thesug.org/blogs/lsuslinky/SSM/Pages/default.aspx" rel="ugc">http://www.thesug.org/blogs/lsuslinky/SSM/Pages/default.aspx</a><br />

</div>


It is not supported to directly query the Databases. Even a read query can introduce a lock that effects operation of the product.

Consider using this space monitoring tool instead:

http://www.thesug.org/blogs/lsuslinky/SSM/Pages/default.aspx [http://www.thesug.org/blogs/lsuslinky/SSM/Pages/default.aspx]


<div>
it may probably be easier if you would run from command prompt on the SP sherver:<br />
stsadm -o enumsites -url <a href="http://YOUR_ROOT_SITE_URL" rel="ugc">http://YOUR_ROOT_SITE_URL</a><br />
This command will display a list of all the site collections in your environment, including the sizes.<br />

</div>


it may probably be easier if you would run from command prompt on the SP sherver:
stsadm -o enumsites -url http://YOUR_ROOT_SITE_URL [http://YOUR_ROOT_SITE_URL]
This command will display a list of all the site collections in your environment, including the sizes.


<div>
irinuc, its a good idea, but I need to know which database they're in. That is why I am doing it in SQL. We have 14 Content databases and I am moving site collections because some of them are getting too big.
</div>


irinuc, its a good idea, but I need to know which database they're in. That is why I am doing it in SQL. We have 14 Content databases and I am moving site collections because some of them are getting too big.

<div>
What version of Share Point do you have? I think in MOSS, this command lists also the database where the site collection is located.<br />
Let me double check that, to make sure; maybe you need to add another parameter to the command...<br />

</div>


What version of Share Point do you have? I think in MOSS, this command lists also the database where the site collection is located.
Let me double check that, to make sure; maybe you need to add another parameter to the command...


<div>
<div class="content wysiwyg-content">
I'm looking for a query that will show my Site Collections with size. I tried select * from Sites and that will give me the size without the URL. &nbsp;select * from webs where ParentWebID is NULL will show me the sub sites which would be fine too, but it doesn't show the size.
</div>
</div>


I'm looking for a query that will show my Site Collections with size. I tried select * from Sites and that will give me the size without the URL.  select * from webs where ParentWebID is NULL will show me the sub sites which would be fine too, but it doesn't show the size.

SQL Query for SharePoint

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.