Specified cast is not valid

whitereg

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.

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.

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.