Compare stored procedures in two databases

[jabmod]

How can one compare stored procedures contained in two databases to see the ones that are not the same.

Thanks a lot.

 

[philhege]

Programmatically or manually?

Here's a general outline of the programmatic method:

Create a table with two VARCHAR fields.

insert into the table the results of sp_helptext: the first SP in the first column, and the second in the second column.

SELECT * from TheTable where Field1 <> Field2

Manually, I use SourceSafe's difference tool.

Good luck,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
A priest, a lawyer, and a rabbi walk into a bar. The bartender looks up and says "What is this, a joke?

 

[SQLSister]

I use SQL COmpare myself. It will compare all the sps and tell you which are different and highlight the differences. Will also compare all the other objects in a database.

Questions about posting. See faq183-874