executing a stored procedure

[shabbs]

I am trying to execute a stored procedure 'get_lotno' in database 'bb4inlinesamples' from an existing stored procedure 'procbbvsamples' in database 'brightbeer'. Both databases reside on the same server.

I have added the following statement

EXECUTE BB4INLINESAMPLES.dbo get_lotno

within 'procbbvsamples' but it returns the error:-

error 509: UserName 'BB4InlineSamples' not found



can anybody tell me what line of code I need to do this?

 

[Bernadette]

Hi There

Has the user who is running the stored procedure got access to the "BB4INLINESAMPLES" database and the "dbo get_lotno" stored procedure ?

Bernadette

 

[SQLBill]

You are missing a period between dbo and get_lotno

EXECUTE BB4INLINESAMPLES.dbo.get_lotno

-SQLBill