RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Intermediate
May 24, 2006

Identify "Drop Out" Columns Used in Stored Procedure Definitions

Assume that there are 1000 stored procedures available in your SQL Server database. At some point, you'll need to drop some columns from the table definitions due to enhancement needs.

If any of your stored procedure definitions used the columns you dropped out, you're going to have a rough time figuring out which ones.

Here's an easy way to do this:

  1. Run "Generate SQL Script" for all stored procedures.
  2. In SQL Query Analyzer, run the generated SQL script file.
This returns a list of the names of the stored procedures that errored out while compiling. These errors are due to usage of dropout columns in their definitions.

Jaya Nehru Kumar
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date