August 16, 2009 at 3:54 pm
Need to access a MS SQL server located on another server using a store procedure.
The calling store procedure is on a MS SQL server 2000 version and the database I need to access is on a MS SQL 2005 server loaded as an instance. Both servers are on the same domain. Need to be able to update a table on the MS SQL 2005 database.
August 16, 2009 at 5:45 pm
Look up "Linked Servers" in BOL ("Books On-Line").
Linked Server are something that you define on your SQL Server that allows you to access another Database server, including another SQL Server Instance. Once you have it set up correctly, it is very easy to access another SQL Server through it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 17, 2009 at 8:12 am
Thank you. Will read the BOL.
August 17, 2009 at 9:14 am
Feel free to come back with any questions that you have on what BOL is saying.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy