Post reply

Creating Procedures & Functions on a filegroup other then Primary

  • August 17, 2010 at 5:11 am

    #227952

    All

    I was wondering if it is possible to create procedures on a filegroup other than the primary filegroup.

    Instead of changing the default filegroup to be a specific one I would like to say ON FILEGROUP1 like you do with a table.

    Any response would be appreciated

    Thanks

    Anthony

  • August 17, 2010 at 5:14 am

    #1207744

    Procedures are stored within one of the system tables, and the system tables are always on the Primary filegroup.

    Why are you asking?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 17, 2010 at 5:20 am

    #1207745

    That was my understanding too.

    We have a number of filegroups which have an assigned schema against that file group, and we just wanted to have the schemas together on the filegroup it is tied to.

    I didnt think you could but I was just asking for restore purposes as some of the filegroups are more important than others

    Thanks

    Ant

  • August 17, 2010 at 5:24 am

    #1207746

    Well for restore purposes you have to restore PRIMARY, so by doing that you'll have all of your procedures.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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