Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Referencing a different database table in a stored procedure 1

Status
Not open for further replies.
Coxy101

Coxy101

Programmer
Jan 27, 2004
4
GB
Hope someone can help me,

i've set up two databases and want to reference a table in DB1 using a stored procedure in DB2. I've tried using 'dbo.DB1.Table1' but it doesn't work. I keep getting 'Invalid object name'.

Anyone know what i'm doing wrong?


 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
477
SashaBuilder3
SashaBuilder3
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
303
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
500
BobSuruncle
BobSuruncle
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
198
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
237
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top