Thank this author by sharing:
By Fernando Casas Osorio, 2013/03/14
I created the following script which will allow us to list all tables in a SQL Server database with the details of the space used and indexes types in each them; this information is helpful to manage our SQL Server databases.
This script is also posted on my personal blog which is http://recursossqlserver.blogspot.com
This Job has been tested in SQL Server 2005 and 2008 R2.
Rename SQL server Server
Server to server backup
SERVER NAME
VM SERVER
Cloned Server
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
