1. We are using Cirix server and 34 client all over country. People start getting message like record in use by another user (error 130 etc.)
Duplicate key gets generated. and Saved even though primary key existed. Begin tran End Tran also applied. Used to do tablerevert and rollback incase such a situation arrived (uniqeness of index...)
Browsing tables with such duplicate records (with Browse command) shows 1st record correctly for next record it blanks the PKfield and shows rest of the other fields data. most of the time it shows duplicate data.
2. Some times data not getting saved. (Thesee are User's remarks) We are having just 300 thousand rows in tables.
We recreated tables using Create Table and recreated indexes after removing duplicate records. then it started saving.
With Begin Tran and EndTran (with buffered 5 tables and Views) it should save all data or None data!
3. Record locking issues. We are not using explicit lock command. but we are traping it in our error routine. Some times it takes 15-20 minutes of time to save a data. Most of the times user terminates the application for this reason (remember we are on Citrix server. all the users are working on same data at a time from distance location in the country)
Dear Craig can u suggest me good architacture to migrate to SQL7.
What are the issues I am looking at.
Thanks Craig
Diptesh
Ps: Your KB articles are very useful. I have read and Used it b4.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only