[sql]
USE master
go
IF object_id('sp_get_table_max','P') IS NOT NULL
DROP PROCEDURE sp_get_table_max
go
CREATE PROCEDURE sp_get_table_max ( @db NVARCHAR(128) = '' ,@top INT = 100 )
AS
SET NOCOUNT ON ;
CREATE TABLE #TableSpace
( DB_NAME VARCHAR(128) DEFAULT ( db_name()),
TableName VARCHAR(128) ,
SCHEMA_NAME VARCHAR(128),
RowsCount CHAR(32) )
DECLARE @sql NVARCHAR(max)
SET @sql = ''
SELECT @sql = @sql + REPLACE (
'
USE [@dbname]
INSERT INTO #TableSpace ( TableName , SCHEMA_NAME, RowsCount )
SELECT b.name AS tablename ,SCHEMA_NAME(b.schema_id) SCHEMA_NAME, c.row_count AS datacount
FROM sys.indexes a ,
sys.objects b ,
sys.dm_db_partition_stats c