Thank you!

Please make sure you're enclosing the entire table name in delimited identifiers (quotation marks or brackets - the same measures required as I commented in http://www.sqlservercentral.com/Forums/Topic1179153-3010-3.aspx).

And yes, you need to connect to the 'source' database this table belongs to (AdventureWorks2008R2 in this case).