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

Specified cast is not valid

I am attempting to run SQL Data Compare, but encounter the following message: "Specified cast is not valid." This occurs while the database is being registered, specifically when SQL Data Compare is reading the constraints. Any ideas/recommendations would be helpful.
whitereg
0

Comments

2 comments

Sort by
  • Chris Auckland
    Did you see the other forum post for the Specified cast is not valid error?

    http://www.red-gate.com/messageboard/vi ... php?t=3999

    I think this should answer your question.

    If you still have a problem, please let me know.
    Chris Auckland
    0
  • ashaw
    We also resolved this issue, if you do not wish to give DBO privilages... by executing
    GRANT VIEW DEFINITION to [user]

    for each of the databases, if you look up the syntax, you can have this applied to individual tables, but in this case you won't want that. The above will give those permissions to all objects in the database.
    ashaw
    0

Add comment

Please sign in to leave a comment.