USE master GO Alter Procedure RenameInPhysicalDrive @databaseName VARCHAR(500), @physicalPath VARCHAR(500), @logFilePath VARCHAR(500) AS BEGIN DECLARE @MyQuery NVARCHAR(500) ='' SET @MyQuery =( 'CREATE DATABASE '+' '+ @databaseName+' ON ( NAME= '+@databaseName+ ',FILENAME='+ @physicalPath +',SIZE=10,MAXSIZE=50,FILEGROWTH=5) LOG ON (NAME=' +@databaseName+'_log'+',FILENAME='+@logFilePath +',SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB) GO' ) EXEC sp_executesql @MyQuery END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)