[dba-SQLServer]Call another db from sproc

Wortz, Charles CWortz at tea.state.tx.us
Thu May 15 12:58:41 CDT 2003


Mark,
 
It T-SQL you reference a table in another db using the IN clause in
which you give the path name to the db containing the table.  You should
be able to find info about this in BOL.
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] 
Sent: Thursday 2003 May 15 12:46
To: SQLServerList
Subject: [dba-SQLServer]Call another db from sproc



Is there a way to reference DatabaseA from within a sproc on DatabaseB?

We have a need to select data from a table in a different database.

 

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030515/d315b57b/attachment.html>


More information about the dba-SQLServer mailing list