How can we help you today? How can we help you today?

Application Role missing in Grant Execution statement

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.
hardingja
0

Comments

3 comments

  • 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.
    Brian Donahue
    0
  • 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.
    hardingja
    0
  • Brian Donahue
    Thanks a lot!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.