Programing Objects Storage

• Alberto dbLearner

  Ten Centuries

  Points: 1246

  More actions

  September 24, 2008 at 10:24 am

  #191409

  I was doing some storage analysis in ma DBs and then a question (may be a dumb question) pop out of my mind... where are programming objects (p, tr, fn) stored in de database?? Not in data pages right? But where?

  I was trying to find the answer around here but I couldn't.

  Thanks

  Alberto De Rossi
  Microsoft Certified Solutions Associate - SQL Server
  Microsoft MVP - Data Platform
  Power BI User Group Lima - Community Leader

• Alberto dbLearner

  Ten Centuries

  Points: 1246

  More actions

  September 24, 2008 at 10:54 am

  #876533

  Ohhhh! I got it, Thanks!! The body of the object is stored in syscomments. So, in the end they are stored y data pages through system tables.

  Alberto De Rossi
  Microsoft Certified Solutions Associate - SQL Server
  Microsoft MVP - Data Platform
  Power BI User Group Lima - Community Leader