Compare Stored Procs without comparing permissions

BellisioBellisio Posts: 26
edited October 30, 2008 11:47AM in SQL Compare Previous Versions
I am trying to compare a database between a production and a training server; I keep coming up with all stored procs as being different, but as I look thru them, it seems the only difference is that there are different accounts that execute them on prod vs. training.

EX: production has account named xyz that uses the stored procs, but training has account named abc.

Trouble is, I won't see any procs that actually have differences in the code portion this way.

I would like to exclude the permission checking when comparing the stored procs, and compare the code only - is this possible?


Sign In or Register to comment.