• ericjorg (7/18/2013)


    1) What do you mean by "Sign the module?" I looked for a way to sign the stored procedure, but couldn't find a way to do it.

    ADD SIGNATURE. Did you read the article I referred you to?

    2) How does this connect to the network service user? It seems like maybe I should have the stored procedure run as the user created from the certificate?

    GRANT EXECUTE on the procedure to the user in question.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]