Post reply

User stored procedures marked as system object

  • April 4, 2014 at 4:05 am

    #1703231

    It is not advisable to put anything like user proc on master; instead you can create new database and store stored procedures. Also it is not a good idea to mark user stored rpocedures as system proc as it will not improve the performance but creat confusion.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 4, 2014 at 5:13 am

    #1703243

    free_mascot (4/4/2014)

    It is not advisable to put anything like user proc on master; instead you can create new database and store stored procedures. Also it is not a good idea to mark user stored procedures as system proc as it will not improve the performance but create confusion.

    Thanks a lot..

    I have doubt

    after i ran all procedures into master database and then i am executing a procedure from one database context, it will generate a execution plan, where it will get saved and as well

    if i am not wrong all temp tables will create in a temp db with a database context..

    is it right or wrong..

    please give your replies..

    Thanks

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

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