September 24, 2008 at 10:24 am
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
September 24, 2008 at 10:29 am
In sys.objects?
September 24, 2008 at 10:54 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply