Can someone please remind what the fix is to prevent this error message when running the ClearCompany script?
Conversion failed when converting the varchar value 'MyCpy' to data type int.
Can someone please remind what the fix is to prevent this error message when running the ClearCompany script?
Conversion failed when converting the varchar value 'MyCpy' to data type int.
I believe this blog should help:
Usually it is a CMPANYID or companyID value in some table, that is a string, such as 'MyCpy', but the script is expecting an integer, thus the error.
The script in the blog will help find any mention of 'MyCpy', letting you know the table/column combinations, then we would want to look through those to find any related to a company ID value.
Thanks
André Arnaud de Cal... 291,820 Super User 2024 Season 2
Martin Dráb 230,514 Most Valuable Professional
nmaenpaa 101,156