You’re offline. This is a read only version of the page.
Trying to log in into our test company and receive the following errors:
An open operation on table "coProcess" (45)
An opent operation on table 'Sy_Period_Setup' (45)
Scrolling window link table not on form
An open operation on table "syListActionStatusHdr' (45)
SQI Error: 952 [Microsoft]SQL Server Native Client 10.0
How do we clear these so I can log into the test company?
Thanks
Dale
*This post is locked for comments
Hi all,
AS usual, you would need to test this first, but I think this is the most recent iteration of the script I run to restore a 'test' database from production. I downloaded this from one of our colleagues in the community, but unfortunately I don't remember to whom I should give the credit. I've not had those specific error messages, but please let us know if this script helps (if you choose to use it).
Kind regards,
Leslie
You may have restored Live to Test, without first giving the "User" Company Access to Test, or restored test to another environment where the SQL Login was not created before the Company database was restored.
The login will be in the DYNAMICS.dbo.ACTIVITY table to be cleared for the selected Company.
Mick
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
