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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 can any one help?

Author  Topic 

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2008-01-02 : 00:17:01
We were saying procedure is a pre-compiled object and its execution alone takes place..if so, then
all DDL is a pre-compiled object..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-02 : 01:05:09
not always. procedures will undergo recompilation in some cases:-

[url]http://msdn2.microsoft.com/en-us/library/ms190439.aspx[/url]
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-02 : 01:26:11
http://en.wikipedia.org/wiki/Stored_procedure



-ec
Go to Top of Page
   

- Advertisement -