Application Role missing in Grant Execution statement

hardingja

I'm comparing stored procedures in two SQL 2005 databases and all of the stored procedures are listed as different. The only difference is the Grant Execute on [store procedure name] to [Property]. Property is an application role in both databases and has been granted execution rights on all stored procedures in both databases. For Database A it shows: Grant Execute on [dbo].[spPrpCreate] to [Property] and for Database B it shows: Grant Execute on [dbo].[spPrpCreate] to []. For some reason the application role [Property] isn't being scripted out and/or recognized in Database B.

Thanks.

Brian Donahue

Hello,

Just to confirm: are you using SQL Compare v3? Because the support for SQL Server 2005 is by no means complete and the only version that really supports 2005 is v4.

hardingja

We are using v3.2.1.14

Sorry didn't realize sql 2005 wasn't fully supported. I'll download the new trial version and see if it works.

Thanks.

Brian Donahue

Thanks a lot!