Este script entrega el tamaño en detalle de las bases de datos y además entrega los objetos nuevos de cada una de ellas, este script lo utilizo mucho en mis monitoreos.
print 'Tamaño de las bases de Datos y objetos nuevos dentro estas'
declare @dbname varchar(100)
Declare @SQL VarChar(1000)
declare curdb cursor for
SELECT DB_NAME(dbid) AS DB_NAME
FROM sysdatabases
--WHERE DB_NAME(dbid) IN ('BINARIA','CARGA_SOTEK','SOTEK','SOTEK_GESTION')
ORDER BY dbid
open curdb
FETCH NEXT FROM curdb INTO @dbname
while @@FETCH_STATUS = 0
BEGIN
PRINT 'BASE DE DATOS: '+@dbname+' PROCEDIMIENTO SP_HELPDB'
exec sp_helpdb @dbname
Select @SQL = 'use '+@dbname+' exec sp_spaceused '
PRINT 'BASE DE DATOS: '+@dbname+' PROCEDIMIENTO SP_SPACEUSED'
Exec ( @SQL)
SELECT @SQL = '
SELECT
SYSUSERS.NAME Propietario,
SYSOBJECTS.NAME Nombre,
CASE SYSOBJECTS.XTYPE
WHEN ''C'' THEN ''Restricción CHECK''
WHEN ''F'' THEN ''Foreign Key''
WHEN ''K'' THEN ''Primary Key''
WHEN ''P'' THEN ''Procedimiento''
WHEN ''S'' THEN ''Tabla de Sistema''
WHEN ''TR'' THEN ''Trigger''
WHEN ''U'' THEN ''Tabla''
WHEN ''V'' THEN ''Vista''
END ''Tipo de objeto'',
LEFT(CONVERT(VARCHAR, SYSOBJECTS.CRDATE, 120), 10) AS ''Fecha Creación''
FROM
SYSOBJECTS,
SYSUSERS
WHERE
SYSOBJECTS.CRDATE > GETDATE() - 10
--AND SYSOBJECTS.UID = SYSUSERS.UID
ORDER BY
SYSOBJECTS.XTYPE,
SYSUSERS.NAME
'
PRINT ''
PRINT 'OBJETOS NUEVOS EN LA BASE DE DATOS '+@dbname
Exec ( @SQL)
FETCH NEXT FROM curdb INTO @dbname
END
CLOSE curdb
DEALLOCATE curdb
GO
3 Comments:
coach factory outlet
nmd adidas
ray ban sunglass,ray ban sunglasses,ray ban outlet,cheap ray bans,cheap ray ban sunglasses,cheap ray bans,ray bans
stan smith adidas
cartier
polo ralph lauren
yeezy boost 350
fitflops
instyler max
white converse
ray bans
michael kors outlet
sac longchamp pliage
calvin klein dresses
ralph lauren
michael kors outlet online
fitflops shoes
burberry outlet canada
reebok classic
pandora jewelry
adidas gazelle
supra store
omega speedmaster
nike roshe run
burberry outlet
air jordan shoes
under armour
fitflops sale clearance
coach outlet store online clearance
mlb jerseys wholesale
michael kors handbgas
nike shoes for cheap
oakley sunglasses outlet
michael kors outlet
fitflops sale clearance
reebok outlet store
adidas pure boost black
dior sunglasses 2016
michael kors outlet online
bottega veneta shoes
chenzhen20160511
true religion jeans outlet
michael kors outlet online
cheap jerseys
cheap air max
cheap ray ban sunglasses
kate spade outlet online
nike air huarache
rolex watches for sale
coach factory outlet online
adidas nmd runner
zhi20161219
cheap oakley sunglasses
vans outlet store
rolex replica watches
michael kors handbags
christian louboutin outlet
nike air max 90
ralph lauren outlet
polo outlet
adidas nmd
louis vuitton outlet
0424shizhong
Post a Comment