How to fix the collation of a Microsoft SQL Server database

Question

I have followed instruction on this article however in the last i have encountered an error Re-enabling Constraint Checks after importing Once the import has been completed, you must re-enable constraint checks on the database. Execute the following query against your new database: EXEC sp_MSforeachtable"ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

this is the error

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "Syspro_FK_ArInvoiceReference_ArPermReprint". The conflict occurred in database "companyW2", table "dbo.ArPermReprint", column 'Invoice'.

please let me know how this could be fixed.

Thanks

Daniel Eads · Answer

Hey there!

Looks like you're following along with this article, right?

From the error you've posted, it appears that the query might be trying to run against a non-Jira database (companyW2).

Try selecting the Jira database specifically in the Explorer on the left sidebar, then either right-click directly on the Jira database or use the button up top to select New Query. This will get you a query window for Jira's database where you'll want to run that SQL again.

(screenshot from the internet showing the New Query button)

Cheers,
Daniel