There's no difference in basic querying in Express edition. Providing both databases are on the same instance, that code will work. Check permissions, check that the database name is correct, the schema is correct and the object really is there.

Connect to the instance from management studio, it's just like any other SQL 2008 instance, with a few feature and scale restrictions.