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 - 2006-09-19 : 07:41:36
|
| Gopi writes "I have one small doubt regarding stored procedures.I have created a stored procedure with a name "storedprocedure1".Actually where it stores( means the physical location of the stored procedure)thanks in advanceregardsGopi Srinadhgopisrinath@nannacomputers.com" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-19 : 07:55:10
|
| Stored procedures are created in your current working database. You can view them in the enterprise manager, under <Your database name> \ Stored Procedures node.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-09-19 : 13:48:16
|
| The definition is stored in a system table which you can querysyscommentsThere is also metadata about the procs in the sysobjects + syscolumns tables.The execution plan of procedures are stored in the procedure cache.the system table syscacheobjects gives you information on wich objects/procs are cachedIf you are on sql2005 the "tables" / views would be:sys.sql_modulessys.dm_exec_cached_plansrockmoose |
|
|
|
|
|
|
Stored Procedures