Not Comparing Object Permissions
I'd just like to point out that the Show SQL window works independently
of the comparison settings. Regardless of your comparison settings, the
'Show SQL' window simply displays a script of the object that you've
registered in the database.
"Steve - DND" <[email protected]> wrote in message
> So far SQL Compare has worked like a charm for me, but for some reason it
> will not get object permissions when two databases are compared. As such,
> these permissions cannot be compared, nor can they be scripted for update
> the destination server.
> In Options "Ignore Object Permissions" is *not* checked, and when I open
> the difference comparison, "Show Permissions" *is* checked. Is there
> something I'm doing wrong here?