Jeff when i did a project using rssbus for quickbooks i ended up writing an applicati:-Don that read qb info into tables on my server, so i had snaphots of the data that was only as stale as the last time the app executed. I found that method to be much more reliable for me, but.my processes didnt need up to thensecond differences in the data.
Qb32.exe is obviously the main process, but the locking of the linked server im not sure of.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!