SELECT * FROM full_server.db.table

SELECT 
    * 
FROM SQL-PC.AdventureWorks2008R2.Sales.Currency

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '-'.

SELECT @@SERVERNAME

------------------------------------------------
SQL-PC

(1 row(s) affected)


SOLUTION

SELECT 
    * 
FROM [SQL-PC].AdventureWorks2008R2.Sales.Currency