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 |
|
PRIYA.CYNTHIA
Starting Member
3 Posts |
 Posted - 2008-08-22 : 15:25:18
|
| Hi all,Stored Procedures are precompiled objects. But in which form are the stored procedures compiled and stored (either like a dll in .net)? and where are they stored? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-22 : 15:38:29
|
| They are stored in the database and not as a file, although you could also save them as a file for source control. When you do save them to a file, they are simply text files with typically sql extension.Extended stored procedures and CLR objects are DLLs though although the CLR object gets sucked into the database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
How is stored procedure compiled and stored