• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • Last Modified:

SQL Server Stored Procedure code compiled

I am using SQL Server 2005 on a system using many stored procedures.
A standby server has the same stored procedures by due to on-going maintenance it may be possible that changes in the main server may not have been updated in every case.
Is it possible to compare the compiled stored procedure compiled code in the main server with the same stored procedure compiled code in the standby server ?
There may be differences in the source code due to varying comments so a textual comparison may yield false differences in functionality.
0
alcindor
Asked:
alcindor
  • 2
1 Solution
 
Brendt HessSenior DBACommented:
There are a few tools that may do what you need.

The most commonly used tool for this is a paid one - Red Gate's SQL Compare.  It is pricey, but good.  You may be able to kludge up a free version using two tools from Red Gate's free tools - Red Gate Scream (small tool to compare two Compare snapshots), and Red Gate Snapper (small tool to take a snapshot of a DB).

OpenDBDiff (at http://opendbiff.codeplex.com/) looks interesting and seems to do what you are asking for as well.  It is open source and free.

Also the Toad for SQL Server Freeware edition should be able to do this.  You can find it at http://www.toadworld.com/m/freeware/default.aspx

Hopefully, one or more of these will do what you need.
0
 
Brendt HessSenior DBACommented:
As far as I know, a comparison of compiled code (1) is not currently possible, and (2) could also result in inaccurate comparisons, because of different execution plans when compiled (which does happen, more often than you would think).  If one of the tools above allows you to exclude comments in the comparison, that should do the trick.
0
 
alcindorAuthor Commented:
Thanks for your comments, I will check out the links supplied.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now