Category: USER

SET AUTOGROWTH ALL USER DATABASES

IF EXISTS(SELECT name FROM sys.sysobjects WHERE name = N’ConfigAutoGrowth’ AND xtype=’U’) DROP TABLE ConfigAutoGrowth GO CREATE TABLE DBO.ConfigAutoGrowth ( iDBID INT, sDBName SYSNAME, vFileName VARCHAR(max), vGrowthOption VARCHAR(12) ) PRINT ‘Table ConfigAutoGrowth Created’ GO — Inserting data into staging table INSERT INTO DBO.ConfigAutoGrowth SELECT SD.database_id, SD.name, SF.name, –sf.fileid, –SUSER_NAME(owner_sid), –recovery_model_desc, CASE SF.status & 0x100000 WHEN 1048576
Read More »