Stored Procedure

How we will access a table of one server from a stored procdure in other server?

Questions by Raman4u

Showing Answers 1 - 3 of 3 Answers

shaurya

  • Oct 9th, 2008
 

You can access this through the following syntax

[Another Server IP].[Database Name].[Owner].[Table Name]

e.g.

[XXX.XXX.XX.XX].[myDB].[DBO].[EmployeeMaster]

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions