June 4, 2013 at 7:57 am
Here we have an application which uses a Stored procedure.
The user have created a SP but the application fails to pick the SP..
ALTER PROCEDURE [INDIADNS\Name.sirname].[EMPLOYEE_SP]
Note - INDIADNS - Its the Domain name...
Now problem here is... this issue never came.. coz when the same user use to create a SP the application picks the SP well & do execute it well..
Today when debugging i came to know that due to the Domain name & username before SP the problem occurs...
Please suggest
************************************
Every Dog has a Tail !!!!! :-D
June 4, 2013 at 8:03 am
And what is the error message you are getting?
Looks like the procedure was created in the users default schema and permissions to other users has not been granted to this procedure. Just a guess since we don't see what you see from here.
June 4, 2013 at 8:10 am
Lynn, yes.... some junior have made the DB offline....& then he made it online..
i dont know what must have haapened.. but the problem was with acesss.. i have granted the access again to the users.. problem is solved thanks 🙂
************************************
Every Dog has a Tail !!!!! :-D
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply