What are the challenges you face when working across database platforms? Take the survey

syntax problems with grant statement

dwsS3mdwsS3m Posts: 2
edited April 20, 2009 12:57PM in SQL Compare Previous Versions
This is an ongoing problem I've seen since sql compare 7, but when a GRANT VIEW DEFINITION ON [ class :: ] gets scripted by redgate, it leaves the delimited identifiers ([]'s) off of the securable.

This does not crop up during a comparison. In a comparison it will show the statement correctly as

GRANT VIEW DEFINITION ON USER:: [user with spaces] TO [myRole]

however, when it becomes a problem is when you try and make a syncrhoniztion file with SQL compare, the syntax then gets scripted incorrectly as

GRANT VIEW DEFINITION ON USER:: user with spaces TO [myRole]

which will obviously cause syntax errors when trying to build the database from the synchronization file.

any thoughts?


  • Options
    Thanks for your post.

    This does appear to be a problem with SQL Compare 8.0, I could reproduce the issue with the steps you outlined - and I'm very suprised nobody has noticed this before.

    I've now logged a bug report, so hopefully it will be fixed in the next version. For your reference, the bug tracking code for the issue is SC-4461.
Sign In or Register to comment.