Home Forums SQL Server 2005 SQL Server 2005 General Discussion User stored procedures marked as system object RE: User stored procedures marked as system object

  • 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