I hope this is what u are looking for:

Declare @fname varchar(2000)

set @fname=''

Select @fname = @fname +  fname + ',' from pubs.dbo.employee

where Job_id = 13

Select @fname

Has some one messed with sysservers table?

Try the code below that might help u.

select * from master.dbo.sysservers

I get the first part..But what are u trying to in the second part (using Cursor)? Can you explain what u need?

Thanks

Sreejith

Can you keep them in different columns? You are breaking the basic rule of Relational database Normalization(Normal Form&nbsp by have multi value column.

Thanks

Sreejith

Have u tried:

sp_dropserver 'ServerName'

sp_addserver 'ServerName', 'local'

Thanks

Sreejith

Can yiu explain why would u be Creating and adding linked server on the fly?

Thanks

Sreejith

Can u show me the restore statement that you are trying to run?

Here is how its done:

RESTORE DATABASE DBName

 FROM DISK = '\\Path\Backupfile.dat'

when u click on transformation and go to destination tab it will pop up a "Create table script" copy that and add a step following your delete Excel script.

Step1: Delete...

Using DBCC SHRINKDATABASE the DB cannot be shrunk lesser than the size it was created so when the databases were created were they created with larger file size?

The database cannot...

Ideally developers should do development on the Dev Server and send documentation on migrating DTS from Dev to Prod(which is done by some one else).

Thanks

Sreejith

Is this what you are looking for?

Select Cast(Hours/8.0 as decimal(10,2)) as Days

Are u doing Transaction log backup. If not Xaction log backup can keep growing?

Are they any long running xaction cos if u have long running xation then Xaction log keeps...

I think there can be employee with different salary but they would have different effectivity dates. Going along the lines here is the query that gets looks at the employee's...

Yes it can be done. Are u planning to update the columns for all the rows in the table or few rows(based on selection criteria). The statement u have will...

Are these jobs failing on MSDE Servers?