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>