Feeds:
Posts
Comments

Posts Tagged ‘size of databases sql server’

 

EXEC
SP_HELPDB

 

–OR

 

CREATE
TABLE #DatabaseSize

(

            NAME VARCHAR(100),

            DB_SIZE
VARCHAR(100),

            OWNER VARCHAR(100),

            DBID INT,

            CREATED
DATETIME,

            STATUS VARCHAR(500),

            COMPATIBILITY_LEVEL
INT

)

 

INSERT
INTO #DatabaseSize

EXEC
SP_HELPDB

 

SELECT
NAME,DB_SIZE
FROM #DatabaseSize

 

Advertisements

Read Full Post »

%d bloggers like this: