locked
Folders in SQL Server RRS feed

  • Question

  • Hi,

    I have two groups of stored procedures. Is there a way to create folders in Database->Programmability->Stored Procedures so that I can keep them seperate? Is there any other way I can use to distinguish them (other than naming conventions)

     

    Thanks

    Thursday, March 24, 2011 5:31 PM

Answers

  • Hello,

    There are no "folder options" as organizing object in SQL Server, for no object type.

    You could use schema to organize objects, but also they will still apear in SSMS in one "folder"; under "Stored Procedures" or whatever object type you open in SSMS.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing
    • Proposed as answer by Ali Razeghi Thursday, March 24, 2011 9:51 PM
    • Marked as answer by PursuitOfGold Monday, March 28, 2011 5:05 PM
    Thursday, March 24, 2011 5:45 PM