I am having a problem in which the query does not complete execution in one database but the same query runs from another database by using full naming convention for the table. below is the explanation.
use dbone select top 1 * from dbo.tableone
this query execution does not complete.
use dbtwo select top 1 * from dbone.dbo.tableone
this query executes.