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.
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.