0

How to connect access the data from SQL Server 2008 R2 database using SQL Server 2008 Express through stored procedure?

BenMorel
  • 34,448
  • 50
  • 182
  • 322
Saranya Jothiprakasam
  • 294
  • 2
  • 6
  • 17

1 Answers1

1

Firstly, you will need to create a linked server. See this link for more details: http://msdn.microsoft.com/en-us/library/ms188279.aspx

Next, you will need to use a 4 part name. For example:

SELECT * FROM Server.Database.Schema.Table
Pete Carter
  • 2,691
  • 3
  • 23
  • 34