Connect to remote server

Thread Solved

Join Date: Nov 2008
Posts: 8
Reputation: ukbasak is an unknown quantity at this point 
Solved Threads: 0
ukbasak ukbasak is offline Offline
Newbie Poster

Connect to remote server

 
0
  #1
Feb 8th, 2009
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
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Connect to remote server

 
0
  #2
Feb 8th, 2009
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 8
Reputation: ukbasak is an unknown quantity at this point 
Solved Threads: 0
ukbasak ukbasak is offline Offline
Newbie Poster

Re: Connect to remote server

 
0
  #3
Feb 8th, 2009
Thankx RamyMahrous.

I go through the link and find some helpful information.
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Connect to remote server

 
0
  #4
Feb 8th, 2009
Very great please mark this thread as solved.
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 8
Reputation: ukbasak is an unknown quantity at this point 
Solved Threads: 0
ukbasak ukbasak is offline Offline
Newbie Poster

Re: Connect to remote server

 
0
  #5
Feb 8th, 2009
sure, But i will do definitely once i will have a connection to SQL 2005 instance technically.
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Connect to remote server

 
0
  #6
Feb 8th, 2009
oooh. I thought you did, take your time, best of luck!
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:




Views: 1141 | Replies: 5
Thread Tools Search this Thread



Tag cloud for MS SQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC