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.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2007-10-27 : 01:47:01
|
| Hi, i am using sql server 2000. i would like to know at which place of my hard drive my stored procedure are saved (like C:\Program Files\Microsoft SQL Server\\MSSQL\Data , we find mdf and ldf file of database) THANK YOU. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-27 : 01:49:08
|
| It doesn't work that way. Data is not stored in files. They are stored in tables inside a database. A database has data files, with the MDF being the primary one.To answer your question though, the stored procedure code is stored in syscomments which is a system table.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
Posted - 2007-10-27 : 02:03:26
|
| THANKS for removing my misconception. i would like to know how do i fetch stored procedure say test from syscomments as i did not found sp name column in the table.thank once again. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-27 : 03:59:32
|
| EXEC sp_helptext 'MySprocName'Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 13:10:21
|
| Or you can open it in enterprise manager. |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-11-02 : 00:34:25
|
| ...or generate it in Query Analyzer...--Jeff Moden |
|
|
|
|
|
|
WHERE STORED PROCEDURE ARE SAVED