Is the other database on the same server?

What change did you make that stopped it working? Was it adding the reference to dbo.Y_name?