InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:09:14 GMT20http://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspxHi,I run the similar query and I didnt get the any error.create procedure abc asselect x.id,y.name1 from name1 xinner join Practice.dbo.name1 y ON x.id=y.IDCommand executed successfullyEXEC abcResult- it returns the matching rows.Please try to run the query as select * from db_name.dbo.tablename ans check if it is returnug desired result or any error.Fri, 05 Oct 2012 01:48:07 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspxHI,I have created a similar query to yours and it works fine for me. So the problem must be with the syntax. Kindly check it once.Create Procedure Test(@SCAC Varchar(50))ASBeginSelect SCAC, emailAddressFrom OC_CARR_BALANCEDUE Balance join OC_User.dbo.portaValues codeon code.codeValue = balance.SCAC and Balance.SCAC = @SCACENDWed, 03 Oct 2012 04:57:12 GMTard5karthickhttp://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspx[quote][b]deepeshdhake (10/1/2012)[/b][hr]Hello,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)ASBEGINselect x.id,y.nameFROM dbo.X_name x inner join dbname.dbo.Y_name y ON x.is=y.idEND ERROR: Invalid Object Name 'dbname.dbo.Y_name'NOTE: I got this error when I altered the procedure. Before it was running properly.[/quote]Run these two queries and post back the results.Query 1[code="sql"]select TOP 10 x.id,y.nameFROM dbo.X_name x inner join dbname.dbo.Y_name y ON x.is=y.id[/code]Query 2[code="sql"]select TOP 10 * FROM dbname.dbo.Y_name[/code]Tue, 02 Oct 2012 08:45:06 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspxThe error is almost certainly what it is.I would just check and confirm the spelling, database and objects you are trying to access.Tue, 02 Oct 2012 07:57:43 GMTOTFhttp://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspxSo looks like that dbname.dbo.Y_name is not accessible from connection you are trying to execute your procedures. Check the name spelling as well. Tue, 02 Oct 2012 03:17:31 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspxIs 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?Tue, 02 Oct 2012 02:51:55 GMTlaurie-789651http://www.sqlservercentral.com/Forums/Topic1366840-1292-1.aspxHello,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)ASBEGINselect x.id,y.nameFROM dbo.X_name x inner join dbname.dbo.Y_name y ON x.is=y.idEND ERROR: Invalid Object Name 'dbname.dbo.Y_name'NOTE: I got this error when I altered the procedure. Before it was running properly.Mon, 01 Oct 2012 18:04:38 GMTdeepeshdhake