March 31, 2011 at 9:32 am
When a stored procedure in database a has a reference to databaseb.schema.tablename, how does sql server make this connection?
How does the stored procedure know how to get to this table to read it?
March 31, 2011 at 10:25 am
Not sure I understand the question completely.
In the query optimizer there's a process called the Algebrizer that goes through the TSQL code and identifies all the pertinent objects. They actually become a part of definition of the binary that eventually becomes the execution plan.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 31, 2011 at 12:52 pm
Ah, I see. I just wrapping my mind around a stored procedure using objects from another database.
thx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply