hi

try the following script

regards,

Kabelo

CREATE TABLE #Fruits(FruitID INT,FruitName VARCHAR(10))

INSERT INTO #Fruits

VALUES('1001','Apple')

INSERT INTO #Fruits

VALUES('1002','Orange')

INSERT INTO #Fruits

VALUES('1003','Mango')

INSERT INTO #Fruits

VALUES('1004','Banana')

INSERT INTO #Fruits

VALUES('1005','Grape')

--SELECT *FROM #Fruits

DECLARE @FruitNames VARCHAR(8000)

SELECT @FruitNames = COALESCE(@FruitNames + ', ', '')...

Hi

since you're only expecting one record with two fields from the first file, you can create two variables and assign those fields to the variables and then pull data from...

yes,

I want to create a job that creates the scripts on a daily basis and no the jobs do not change frequently

I wanted a way to do that automatically

thanks guys

your assumption is correct, instead executing

alter database model

modify file (name = 'modeldev', filename = 'E:\MSSQL\DATA\mode.mdf')

I executed

alter database model

modify file (name = 'modeldev', filename = 'E:\MSSQL\DATA\')