Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Script to gain capacity information

By kmlakov,

Recently at my site we had a need to gather current capcatiy of all databases as well as table obejcts on our servers.  although there are some out of the box stored proceudres to assist in this effort as well as some schema objects, they mostly would return information on one database at a time.  Not to mention we wanted to foramt this information into a report that could be distrubuted to server administrators and management.  the follwoing two scripts will return inforamtion for all databases on server as well as individual table inforamtion such as primary key size, index size, total records etc.you can then take these results and paste into excel, i have a dts as well that will paste for me but i belive that is another topic.  please note these procs will call system tables and objects so sa privileges will be required.PLEASE NOTE THESE PROCS SHOULD BE PALCED INTO MASTER DB AND IN QUERY ANALYZER SET TABS AT 4. enjoy

Total article views: 229 | Views in the last 30 days: 2
 
Related Articles
FORUM

How to insert these dates in database

How to insert these dates in database

ARTICLE

Database Snapshots in SQL Server 2005

One of the brand new features in SQL Server 2005 is the database snapshot. New authors Arvinder Sing...

FORUM

database mirroring monitor - remove server or database

database mirroring monitor - remove server or database

FORUM

Backup BizTalk Server Databases

Backup of BizTalk Server Databases

ARTICLE

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases

 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones