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.


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!