Select sp_executesql select and uncomment exec sp_executesql to create the dbs IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N''PRIMARY'')ĪLTER DATABASE ' + dbname + ' MODIFY FILEGROUP DEFAULT SELECT = + 'CREATE DATABASE įILENAME = N''D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\' + dbname +'.mdf'' ,įILENAME = N''L:\MSSQL11.MSSQLSERVER\MSSQL\Log\' + dbname + '_log' +'.ldf'' ,ĪLTER DATABASE '+ dbname + ' SET COMPATIBILITY_LEVEL = 110ĪLTER DATABASE '+ dbname + ' SET ANSI_NULL_DEFAULT OFFĪLTER DATABASE '+ dbname + ' SET ANSI_NULLS OFFĪLTER DATABASE '+ dbname + ' SET ANSI_PADDING OFFĪLTER DATABASE '+ dbname + ' SET ANSI_WARNINGS OFFĪLTER DATABASE '+ dbname + ' SET ARITHABORT OFFĪLTER DATABASE '+ dbname + ' SET AUTO_CLOSE OFFĪLTER DATABASE '+ dbname + ' SET AUTO_CREATE_STATISTICS ONĪLTER DATABASE '+ dbname + ' SET AUTO_SHRINK OFFĪLTER DATABASE '+ dbname + ' SET AUTO_UPDATE_STATISTICS ONĪLTER DATABASE '+ dbname + ' SET CURSOR_CLOSE_ON_COMMIT OFFĪLTER DATABASE '+ dbname + ' SET CURSOR_DEFAULT GLOBALĪLTER DATABASE '+ dbname + ' SET CONCAT_NULL_YIELDS_NULL OFFĪLTER DATABASE '+ dbname + ' SET NUMERIC_ROUNDABORT OFFĪLTER DATABASE '+ dbname + ' SET QUOTED_IDENTIFIER OFFĪLTER DATABASE '+ dbname + ' SET RECURSIVE_TRIGGERS OFFĪLTER DATABASE '+ dbname + ' SET DISABLE_BROKERĪLTER DATABASE '+ dbname + ' SET AUTO_UPDATE_STATISTICS_ASYNC OFFĪLTER DATABASE '+ dbname + ' SET DATE_CORRELATION_OPTIMIZATION OFFĪLTER DATABASE '+ dbname + ' SET PARAMETERIZATION SIMPLEĪLTER DATABASE '+ dbname + ' SET READ_COMMITTED_SNAPSHOT OFFĪLTER DATABASE '+ dbname + ' SET READ_WRITEĪLTER DATABASE '+ dbname + ' SET RECOVERY FULLĪLTER DATABASE '+ dbname + ' SET MULTI_USERĪLTER DATABASE '+ dbname + ' SET PAGE_VERIFY CHECKSUMĪLTER DATABASE '+ dbname + ' SET TARGET_RECOVERY_TIME = 0 SECONDS No cursors, No need to use a template, multiple DBs created provided you have the dbnames in a table as varchar(max)ĬREATE TABLE #db_names(dbname varchar(250)) USE NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE MODIFY FILEGROUP DEFAULT ( NAME = FILENAME =, SIZE = 512KB, FILEGROWTH = 256KB )ĪLTER DATABASE SET COMPATIBILITY_LEVEL = 110ĪLTER DATABASE SET ANSI_NULL_DEFAULT OFFĪLTER DATABASE SET AUTO_CREATE_STATISTICS ONĪLTER DATABASE SET AUTO_UPDATE_STATISTICS ONĪLTER DATABASE SET CURSOR_CLOSE_ON_COMMIT OFFĪLTER DATABASE SET CURSOR_DEFAULT GLOBALĪLTER DATABASE SET CONCAT_NULL_YIELDS_NULL OFFĪLTER DATABASE SET NUMERIC_ROUNDABORT OFFĪLTER DATABASE SET QUOTED_IDENTIFIER OFFĪLTER DATABASE SET RECURSIVE_TRIGGERS OFFĪLTER DATABASE SET AUTO_UPDATE_STATISTICS_ASYNC OFFĪLTER DATABASE SET DATE_CORRELATION_OPTIMIZATION OFFĪLTER DATABASE SET PARAMETERIZATION SIMPLEĪLTER DATABASE SET READ_COMMITTED_SNAPSHOT OFFĪLTER DATABASE SET TARGET_RECOVERY_TIME = 0 SECONDS ( NAME = FILENAME =, SIZE = 10240KB, FILEGROWTH = 1024KB )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |