Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-05-08 : 05:18:58
|
| Hi guys and gals,Since monitoring blocks on the server, I have noticed that when I have a whole lot of users thrown out of their apps, it's all because of one PC.The program name is "Microsoft Office 2003". The user reckons that they haven't opened any Excel files that have any kind of link to the live database.Is there any known problem that you are aware of where Excel can "remember" connection strings maybe from other files you have opened in the past and would that spuriously throw INSERT, UPDATE & SELECT statements to the database server and that then cause locks?The idea seem ludicrous to me. I'm stumped. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-08 : 05:23:36
|
| No, but they could have a saved spreadsheet with a pivot table or macros set up that updates the SQL table, not entirely sure what kind of locking this would use, but would guess it could cause problems. |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-05-09 : 10:00:32
|
| Got a little closer to the answer. Turns out, the approach I initially took here does not reliably return he Hostname. So that's what's been causing the confusion.So, when I can next put the production server into single user mode, I'll try out the approach Ola referred to and see if that's any more stable. |
|
|
|
|
|
|
Excel 2003 causes Deadlocks?