I meant to say that, directly connect to the server box and add the required credentials there itself, but not in the linked server created.

Hope you have done this.

If the...

Hi,

Thanks for your reply.

As of now i only know that we can change the collation at the server level.

Is it possible to change the collation only to a perticular DB?

As...

First we have to run some scripts to minimize manual actions. The next step is rebuilding the master database to change the server to the correct collation. After that...

Hi Lars

The below links could be of some help to you

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/69644/

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/69022/

Hi Sushant,

Did you add the login credentials you have in the server which you want to use it as linked server?

Only issues that we generally face with the linked servers...

I too am searching how to test a SSIS package and what parameters need to be considered while testing SSIS package.

I got few answers which i mentioned below,but that really...