Comments
Sort by recent activity
The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time. [image] / comments
The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time.
The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time. [image] / comments
The only way I've been able to fix it is by following these steps. It is not ideal, but it does work every time.
The issue is back. I'm getting it every minute or so, over and over... 🤦♂️ Luckily my work around steps above still apply. However, once the Drop and Create to... works successfully on the final faulty table, all of my data is wiped. Thus, it's not an ideal solution, but it does work. / comments
The issue is back. I'm getting it every minute or so, over and over... 🤦♂️ Luckily my work around steps above still apply. However, once the Drop and Create to... works successfully on the final f...
ATTN: RedGate Support Any update on this issue? It's still causing us problems from time to time and the work around is problematic as well. Thanks for any updates... / comments
ATTN: RedGate SupportAny update on this issue? It's still causing us problems from time to time and the work around is problematic as well. Thanks for any updates...
The latest way that I've worked around the issue was by following these steps:
Read the error message to find the table name that is having problems.
Find offending table in SSMS Object Explorer
Right click on table to open the popup menu
Click on Script Table As... > Drop and Create to... > New Query Editor Window
Execute generated script
This will throw an error...
Give focus to the SQL Source Control tab (this will cause the RedGate error on another table).
Repeat back at step 1 with the table referenced in the error dialog
Once I follow the above steps all the way down to the deepest table (ie. no child record constraints), the error dialog went away and it showed my changed files.
It wasn't pretty, but it worked. [image] Would still like to hear back from RedGate with a ticket number so that I can track this issue over time.
Thanks!
Luc / comments
The latest way that I've worked around the issue was by following these steps:
Read the error message to find the table name that is having problems.
Find offending table in SSMS Object Explorer
Ri...
Thank you for the response. Could you please provide me with the support ticket number for my records?
Thanks,
Luc / comments
Thank you for the response. Could you please provide me with the support ticket number for my records?
Thanks,
Luc
Any news on this? I have the same error and can't seem to get around it. Any help would be great! / comments
Any news on this? I have the same error and can't seem to get around it. Any help would be great!
I'm experiencing this issue too. [image] / comments
I'm experiencing this issue too.