• did you create the matching USER devtest in the database where the procedure was created?

    did you grant execute to the user devtest ont eh procedure?

    CREATE USER devtest FOR LOGIN=devtest

    GRANT EXECUTE ON myProcedure TO devtest

    if you login and don't have a user mapped, the logincannot execute a stored proceudre...only users can.

    a login does not have any rights to objects within a database. (unless it's int he sysadmin role...that shortcuts/trumps user permissions)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!