SQL Compare Stored Procedures and permissions

I am trying this product out and really impressed from the get go.

I have a QA and dev environment. I ran the sql compare and it found a lot of difference I did not know existed, however it also shows that I have a bunch of objects that only exist in one environment or the other. Some of these are legitimate. However, the bulk of them are stored procedures, I was wondering if this might have something to do with permissions as only have read permissions on the QA environment.

johnhancocktx September 28, 2015 13:07

Comments

1 comment

You'll need VIEW DEFINITION permission for Compare to work properly. The required permissions are documented at http://documentation.red-gate.com/display/SC11/Permissions+required+to+use+SQL+Compare.

Mike U September 29, 2015 07:34

0

Add comment

Please sign in to leave a comment.

How can we help you today?

SQL Compare Stored Procedures and permissions

Comments

Add comment