Hi all,

How I can update linkedserver?

Example :

Begin Set @provstr = 'Server = Server1;database =DB;uid =sa;pwd=sa'

Now update : linkedserver

Set @provstr = 'Server = Server2;database =DBNEW;uid =sa;pwd=sa'

Thanks!

Hi,

Thank you very much!

Regards!

Hi Jack Corbett,Thank very much for your reply!

-TCP/IP and Named Piped is enable .

-both Server and Client same domain.

- This is store procedure :

EXEC EZV2.dbo.sp_addlinkedserver @server = N'REMOTE_DB',...

Hi,

both server same domain . I Configure Surface Area for ... is Remote Compute. Then Configure Surface Area for Service and Connection ->

Service Connection -> Local and Remote Connection...

I enable Names pipes in SqlServer Configuration Manager.But then execute this query -> error.

If connect by Login Form of Sqlserver 2005 -> BDEnger on server ok

But can not excute query...