Hi,
Please Alter your Procedure with this
ALTER PROC [dbo].[CreateDatabase]
(
@DatabaseName NVARCHAR(MAX),
@TableName NVARCHAR(MAX) = 'LogAlarm',
@path NVARCHAR(MAX) = 'D:\BackupDatabase\'
)
AS
BEGIN
DECLARE @Query NVARCHAR(MAX),
@DBName Nvarchar(100),
@LogName NVARCHAR(100),
@LogFile NVARCHAR(100)
SET @DBName = @DatabaseName+'.mdf'
SET @LogName = @DatabaseName+'_log'
SET @LogFile = @DatabaseName+'_log.ldf'
SET @Query =
'
IF NOT EXISTS
(
SELECT * FROM sys.databases WHERE [name] = ''' + @DatabaseName + '''
)
BEGIN
CREATE DATABASE [' + @DatabaseName +'] ON PRIMARY ( NAME = N'''+ @DatabaseName + ''', FILENAME = N'''+@path+@DBName+''', SIZE = 3072KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'''+ @LogName +''', FILENAME = N'''+@path+@LogFile+''' , SIZE = 1024KB , FILEGROWTH = 10%)
END'
EXEC (@Query);
END
Regards,
Ahmed Mandour