Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Packages in SQL server 2005

Packages in SQL server 2005

Scheduled Pinned Locked Moved Database
databasesql-serveroraclesysadminquestion
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • G Offline
    G Offline
    geekfromindia
    wrote on last edited by
    #1

    hi Guys, I have been working with Oracle till now and recently moved to SQL Server. In oracle we have packages, which is an effective way of organizing our stored procs. In sql server I am seeing all procedures under one folder at same level. Is there any way to organize or group together procedures in SQL server? Thanks

    Keep DotNetting!! GeekFromIndia

    D 1 Reply Last reply
    0
    • G geekfromindia

      hi Guys, I have been working with Oracle till now and recently moved to SQL Server. In oracle we have packages, which is an effective way of organizing our stored procs. In sql server I am seeing all procedures under one folder at same level. Is there any way to organize or group together procedures in SQL server? Thanks

      Keep DotNetting!! GeekFromIndia

      D Offline
      D Offline
      DerekFL
      wrote on last edited by
      #2

      Schemas can be used to organize any type of objects. You just make the schema owner dbo. Here is an article discussing the topic. http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server[^]

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups