Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 500 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Stored Procedures Administration


 Article Abstract:

A stored procedure is a precompiled collection of Transact-SQL statements stored under a name and processed as a unit that you can call from within another Transact-SQL statement or from the client applications.

This article contains information about how, when, where and why to use Stored Procedures.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Tips for using SQL Server 2005 stored procedures
Optimizing Stored Procedures To Avoid Recompiles
Index Tuning Wizard Optimization Tips
Enhance Your Transaction Flexibility With Embedded Stored Procedures
Troubleshooting Index Tuning Wizard Problems
Undocumented SQL Server 2005 replication stored procedures (Part 3)
Using replication procedures to troubleshoot SQL Server problems
Stored Procedures Execution Plans
Troubleshooting Web Assistant Procedures



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

Reader Comments: Post Your Comments/Feedback

RE: Stored Procedures Administration
(posted: 4/1/2004 8:05:09 AM)
In SQL2K SP's are not precompiled.


Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004