You have to use 3-part addressing if the database is on the same server. This is an example:

USE Northwind;

UPDATE AdventureWorks.Person.StateProvince
SET IsOnlyStateProvinceFlag = 1
WHERE Name='Virgin Islands;