SQL SERVER: Calling Code from another Database

To call object from another database on the same server we should use 3 part syntax


Database.Schema.Object

e.g.


Use tempdb
GO

SELECT Name,ModifiedDate 
FROM [AdventureWorks2008].[Production].[ProductCategory]

Reference: DP (http://dptechnicalblog.blogspot.com)