I want them in seperate record sets.

Thanks.

Thanks foor the info,But how can i make that remote server as linked server.

Thnaks once agian for ur help.

I have the diff backup for the databse on server xxxx.Can i copy the same onto the new server zzzz and restore it on server zzzz.

How can i do this.

Thanks

...

I have the database aa on server xxxx. and it has replication with the database aa on server yyyy.Database aa on server xxxx is a subscriber to database on yyyy.Now...

Can anyone help me in this isuue.

Thanks.

should the source database be offline?or can we do this when it's online?

SELECT date=

CASE

WHEN datepart(weekday,<date_column>)='1' THEN 'SUNDAY'

WHEN datepart(weekday,<date_column>)='2' THEN 'MONDAY'

WHEN datepart(weekday,<date_column>)='3' THEN 'TUESDAY'

WHEN datepart(weekday,<date_column>)='4' THEN 'WEDNESDAY'

...

any query get the result?

any query to get the result?

I got it myself through convert function,thanks

I got it myself through convert function,thanks

I have done it by disconnecting the active connections that are existing on the source database.

Thanks for all the help in this process.

I am getting this error while doing the DTS.

I think there are 2 active connections to the database and they have to be inactive...

I got the following errors while doing the task.

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Unspecified error

Step Error code: 80004005

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:1100

How...

should they be linked servers?