Home arrow SQL Server arrow Extended Stored Procedures: Intro And 10 Cool Examples

Extended Stored Procedures: Intro And 10 Cool Examples

In this article Joe takes us through what an SQL Server 2000 extended stored procedure is. He also shows us how to use 10 of SQL Server 2000's most coolest extended stored procedures to accomplish tasks such as killing a system process, writing to the event log, encrypting data to a database, parsing XML, shelling to the command-line, and more.

Author Info:
By: Joe O'Donnell
Rating: 4 stars4 stars4 stars4 stars4 stars / 134
February 11, 2002
  1. · Extended Stored Procedures: Intro And 10 Cool Examples
  2. · Extended Stored Procedures
  3. · Useful Extended Stored Procedures
  4. · Examples (contd.)
  5. · Examples (contd.)
  6. · Conclusion

print this article

Extended Stored Procedures: Intro And 10 Cool Examples
(Page 1 of 6 )

How many times have you started to create a batch of SQL, gotten half-way through, and then realized that something you've just spent the better part of 3 hours on could've been completed using one of SQL Server 2000's built-in procedures?

In this article I'm going to show you ten extended stored procedures that are available to us through code in Microsoft SQL Server 2000. Extended stored procedures are created and loaded using DLL's (which are created in C/C++), and offer more independent functionality than standard procedures (such as access to the Win32 API, services, direct disk/network access, etc), and because they're compiled externally as dynamic linking libraries (DLL's), they're also quicker.

To test the extended procedures in this article you should have Microsoft SQL Server 2000 installed on your Windows 2000 box. You should login to SQL Server using an administrator's account. If you don't have Microsoft SQL Server 2000, you can download a free 120-day evaluation copy here.
blog comments powered by Disqus

- Executing SQL Server Stored Procedure from P...
- How to Search for Date and Time Values Using...
- Replication: SQL Server 2000 - Part 2
- Replication: SQL Server 2000 - Part 1
- SQL Sever: Storing Code in Binary or Text Fi...
- Execute SQL on Multiple Tables/Columns - New...
- How to Connect to a SQL Server from Visual F...
- SQL Server Hardware Tuning and Performance M...
- Primary Key on Multiple Tables New RDBMS C...
- Migrating from Sybase to SQL Server
- What's Best for DBAs? GUI or T-SQL Comma...
- How to Perform a SQL Server Performance Audit
- An Introduction To The Bulk Copy Utility
- SQL Server Stored Procedures 101
- Building Your First SQL Server 2000 Database

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials