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
How could you by pass MSDN!! http://msdn.microsoft.com/en-us/library/ms190479.aspx
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

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MS SQL Forum


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



Tag cloud for MS SQL
"last age autogrowth business connectingtodatabaseinuse count cursor data database dateadd datediff datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit live loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC