Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Big Problems after updating DB to SQL Server

Status
Not open for further replies.

rafal444

Programmer
Aug 11, 2006
74
US
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... :(
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top