I have wrote one store proc. So, in the stored procedure, it is using one table which is in the different database. When I am trying to execute the stored proc it is giving me this error "INVALID OBJECT NAME". I have also given the permission to the stored proc.
Following is the sample stored proc:
create proc proc_name(inputs)
FROM dbo.X_name x inner join dbname.dbo.Y_name y ON x.is=y.id
ERROR: Invalid Object Name 'dbname.dbo.Y_name'
NOTE: I got this error when I altered the procedure. Before it was running properly.