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