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

Thankx RamyMahrous.

I go through the link and find some helpful information.

Very great :) please mark this thread as solved.

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

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.