• Great article, but I'm having problems with who the owner should be in the CREATE PROCEDURE line.

    When I try to enter my own username as the owner, it shows an error message, and won't let me save the procedure. I have also tried 'dbo_user' with the same result.

    I've read elsewhere that the owner of the stored procedure should be the same as the owner of the objects it uses in order to avoid 'broken ownership chains'- whatever that is!

    Who should the user be?