Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Under which Filegroup are Stored Proc. stored?

Author  Topic 

Carat
Yak Posting Veteran

92 Posts

Posted - 2007-08-23 : 05:33:43
When you create a Stored procedure, is it automatically stored under the default Filegoup?

How can I see under which Filegroup my Stored Procedures and Triggers are stored?

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2007-08-23 : 06:07:18
Hope all are under Primary file group if not specifically changed.

RKNAIR
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-23 : 22:52:59
They are in primary file group that hosts all system tables.
Go to Top of Page
   

- Advertisement -