Member Avatar for ukbasak

Hi,

How to connect to remote server with storedProcesdure sp_addlinkedserver where the server has an instance SQL2005.

suppose the servername as 'SrvName\SQL2005'.

Also please provide the procedure how to delete a remote server from sysservers table.

Thanks,
Ukbasak

  • 2 Contributors
  • 5 Replies
  • 167 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for ukbasak

Thankx RamyMahrous.

I go through the link and find some helpful information.

Member Avatar for Ramy Mahrous

Very great :) please mark this thread as solved.

Member Avatar for ukbasak

sure, But i will do definitely once i will have a connection to SQL 2005 instance technically.

Member Avatar for Ramy Mahrous

oooh. I thought you did, take your time, best of luck!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.