Post reply

How to registered a stored procedure so that from all database it can be accessed

  • January 20, 2005 at 1:16 am

    #87366

    Hello,

           I have created a common stored procedure.I want to execute that stored procedure from all database without executing that script in all database.How can I do that?Please give me reply asap.

    Regards

    Niladri

    Thanks & Regards,

    Niladri Kumar Saha

  • January 20, 2005 at 1:48 am

    #538244

    havent u see the previous post.......

    we can use databasename.owner.SP to execute the same SP for different database.... I could find u replying for some sort of same issue in previous post..... thats why i asked

     

  • January 21, 2005 at 2:33 am

    #538454

    Hi grant the stored procedure to public so that it can be accessed from any database.

    GRANT EXEC ON 'spname' TO public

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply