Unused Stored Procedures

$ 99.95

Find stored procedures that are not used by your application.

It's time to clean up your database. Maybe your application is years old and has been modified like crazy. Maybe your new application uses NHibernate and your old application used stored procedures. Maybe your new CIO likes Oracle and you need to convert all the SQL Server stored procedures over. In any case, the unused stored procedures have got to go. Find out which stored procedures can be removed with the Unused Stored Procedures application.

While it can be purchased separately, this product is also included in the Gold Suite. Gold Suite subscribers receive all product updates and all new products as part of a yearly subscription. It is the best value in the industry.

Features

FeatureDescription
Saves Time Why do the tedious, time consuming work of searching your source code for stored procedures one by one? Use the Unused Stored Procedures application to do the work in record time.
Multiple Directories Search multiple source code directories at once.
Intelligent Searching Our application can tell the difference between a method name and a stored procedure reference.
Compatible Compatible with SQL Server 2000, 2005, and 2008.
Stored Procedure Dependencies Detects stored procedure dependencies for both normal and dynamic TSQL.
Comment Handling If something is commented out, it is considered unused. Supports single and multi-line comments for VB.NET, C#, XML, and TSQL.
Drop Scripting Creates a drop script based on a template.
Other Features Detects NHibernate stored procedure usage. Detects Enterprise Library Logging Application Block usage. Detects Dataset stored procedure usage.
1 Year Free Upgrades Purchase today and all upgrades are free for the next year.
60 Day Money Back Guarantee At Kellerman Software, we want you to be totally satisfied with your purchase. Receive a refund within 60 days when ordering from KellermanSoftware.com. Source code versions are non-refundable due to their nature.
Lifetime Support Lifetime E-mail technical support is included.

There are currently no commercial or shareware competitors to find unused sql server stored procedures in source code. If you find one, please contact us and we will be happy to create a standard comparison chart like we have done with the rest of our products.

Download a free 30 day trial today.

  • Full working version
  • Includes technical support
  • Works with .NET 2.0 and higher

Download Options

When using this software you meet the following system requirements.

  • Windows 98, Windows 98 SE, Windows 2000 with SP4, Windows ME, Windows XP with SP2, Windows 7, Windows 8, Windows 10, Windows 2000 Server with SP4, Windows Server 2003, Windows Server 2008, Windows Server 2012, or Windows Server 2016
  • .NET Framework 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, or 4.6
  • SQL Server 2000, 2005, 2008, 2012
  • 2 MB Hard Disk Space for Installation

Using the Unused Stored Procedures application is super easy:

  • Enter the connection string for your SQL Server database. This is the standard SQL Server Client Connection String.
  • Chose the source code directories and add any file wildcards.
  • Alter the drop script template.
  • Click the Search button.

The unused stored procedures will be displayed in the following screen. The screen after will have a TSQL drop script that you can run in Query Analyzer or SQL Server Management Studio.

Q: How do I use my license key?
A: Click "Enter Registration" in the help menu then restart the application.

Q: I lost my license key how do I retrieve it?
A: Go to your account

Q: I lost my software how do I retrieve it?
A: Go to downloads

Q: Where can I download the latest version of my software?
A: Click the download tab.

DateVersionDescription
9/9/2008 1.0 Initial Release. This application searches project source code directories and analyzes which stored procedures can be removed from the SQL Server database. Features include, Stored Procedure dependency recognition, single & multi-line comment support, and handling of both dynamic and non-dynamic TSQL.
9/18/2008 1.1 New feature: compatibility with SQL Server 2000.
5/30/2009 1.07 New feature: option to compare classes without references to system.data.
1/9/2012 1.14 New feature: the ability to detect unused stored procedures in rdl files.
3/30/2012 1.15 This update fixes an incompatibility issue with other Kellerman Software installations.
8/18/2012 1.16 This update fixes a problem with changes to the the wildcard specification not taking effect.
9/21/2012 1.18 This update improves the performance for handling tens of thousands of source code files.
10/19/2014 1.20 This update fixes a compatibility issue when .NET framework 4.5 is not installed.