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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-15 : 10:26:35
|
| Reji writes "Where on the server are stored procedures stored? in which file / where exactly on the database server?ThanksReji" |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-15 : 10:56:47
|
| Table = syscomments |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-07-16 : 10:27:04
|
| syscomments contains the actual SQL defenitions for the procs ( and other things as well ).then you have sysobkects and syscolumns that store names and parameters for the procs ( and other things as well ).These tables exist in each database on the server and are not "server wide".If you want metadata for the procs, some of the INFORMATION_SCHEMA views will help as well. ( they get the info from sysobjects,syscolumns,syscomments,,, system tables )/rockmoose |
|
|
|
|
|
|
Stored procedure