Big Problems after updating DB to SQL Server

[rafal444]

I have moved all the tables to SQL Server using upsizing wizard.

However now users experience big problems, the database hangs.

I did some research and I have noticed that:

1) There is a blocking process
2) The blocking process SQL is:

"SELECT "dbo"."Contacts"."ContactID" FROM "dbo"."Contacts"

3) The SQL above is executed when the user opens "Contacts" form. The Contacts form returns all records...

4) The locking is set to "Edited Record Only"

Please help. My client is extemely unhappy...

 

[rafal444]

I wonder, maybe I need to populate the whole recordset. I have noticed taht when I move to the last record, the SQL causing the problem dissapers from Processes window in Enterprise Manager