Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap