Stored Procedures where are they saved?

[berkshirea]

Hi guys,

Im new to SQL Server. I just want to know if the stored procedures are saved somewhere in some folder?

Where can I see them in C drive? Or is it only visible/accessible if I use sql manager?

Thanks for any help.

 

[hmckillop]

Only visible if you use SQL Manager or have a query window.

Stored procedures are not stored in seperate files, they are part of the physical file structure of the database they are created in.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[berkshirea]

tnx hmckillop for that info.

 

[MDXer]

Stored procedures are stored as datarows within your database.

Select
*
From sys.procedures

the above query will display your db procedures. This doesn't mean you can start messing around with this data to modify your procedures.