>Hi Try doing it like this:
>
>DECLARE @lcDB CHAR(512)
>
>SET @lcDB = 'CREATE DATABASE ' + @myDBName +
>' ON
>( NAME = ''prods_dat'',
> FILENAME = ''c:\temp\prods.mdf'',
> SIZE = 4,
> MAXSIZE = 10,
> FILEGROWTH = 1 )'
>
>EXEC (@lcDB)
>
>Mace
>
>>All
>>
>>I want to create a dynamic database name combining a constant with the date of creation. Is there a way I can do this in SQL?
>>
>>-- Get time stamp
>>DECLARE @dtLogTime DATETIME
>>SET @dtLogTime = GETDATE()
>>DECLARE @sLogTimeString VARCHAR(50)
>>declare @ArchiveName varchar(50)
>>
>>
>>
>>SET @sLogTimeString = CAST(DATEPART(month,@dtLogTime) as varchar(10)) + CAST(DATEPART(day,@dtLogTime) as varchar(10))+ CAST(DATEPART(year,@dtLogTime) as varchar(10))
>>
>>set @ArchiveName ='SRCCTranslog'+@sLogTimeString
>>select @ArchiveName
>>
>>SRCCTranslog8102004
>>
>>-- Create the Archive Database
>>USE master
>>GO
>>
>>CREATE DATABASE @ArchiveName
>>ON
>>( NAME = SRCCTrans_dat,
>> FILENAME = 'c:\program files\microsoft sql server\mssql\data\SRCCTrans_dat.mdf',
>> SIZE = 10,
>> MAXSIZE = 50,
>> FILEGROWTH = 5 )
>>LOG ON
>>( NAME = 'SRCCTrans_log',
>> FILENAME = 'c:\program files\microsoft sql server\mssql\data\SRCCTrans_log.ldf',
>> SIZE = 3MB,
>> MAXSIZE = 3MB,
>> FILEGROWTH = 3MB )
>>GO
>>
>>I get an error of course - Can this be done?
>>
>>Evans

Macer,

I feel like Duh because I use literal string SQL statement build ups quite a few times. But thanks for pointing me in the right direction.


Evans