SQL Server Performance

Permissions Issue

Discussion in 'General Developer Questions' started by amitm79, Feb 17, 2005.

  1. amitm79 New Member

    Hi All,
    I am facing an interesting situation. I have a stored procedure and an associated owner to it. When i am trying to execute the stored procedure through the owner connection it gives me an error message saying "Could not find stored procedure". If i use two part naming convetion and prepend user name to the SP name, it works fine. The same SP used to work earlier but is not working today. Any clues to what could be the issue? I believe the owner doesn't need to qualify the object name with the owner name.

    Regards,
    amitm79

Share This Page