Activity overview
Latest activity by janzich
OK, so it *did* happen again. This time it happened when I dragged over another window. It may have been a coincidence, but (and this can be a long shot) … could not it be some multithreading issue where the UI thread is accessing some kind of buffer with the SQL because it needs to be repainted and some other thread is using it at the same time to feed the SQL server? As I say, it’s a long shot, but it could explain why it’s seemingly related to UI actions. / comments
OK, so it *did* happen again. This time it happened when I dragged over another window. It may have been a coincidence, but (and this can be a long shot) … could not it be some multithreading iss...
Hello,
It seems that I have a similar issue, but I’m not sure it’s related to UI. It has happened to me twice today on a 700k (400MB) table which takes quite some time to sync. First, I got the error when was about 80% done and the error message was something that looked like an invalid piece of SQL. Since the generated SQL script was huge, and I did not have enough time, I concluded that some odd piece of data was not properly escaped, and gave up. I tried few hours later again and got a similar error, but now right at the beginning of the process. I copy-pasted it to Management Studio and it was fine. The only "odd thing" about the snippet was that that was an nvarchar with a newline in it. I clicked on OK, and started the sync again and so far it has been running. It’s 20% done now (which seems very slow), but I’m afraid it may fail again with a similar error message.
Jan Zich
Windows Server 2008 R2, SQL Server 2005 / comments
Hello,
It seems that I have a similar issue, but I’m not sure it’s related to UI. It has happened to me twice today on a 700k (400MB) table which takes quite some time to sync. First, I got the...