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 |
|
woodylongfellow
Starting Member
1 Post |
 Posted - 2007-10-30 : 18:56:10
|
| So this is weird...I'm trying to run a web page that makes an update query to a table in my database. The problem though is that when I have the table open in Enterprise Manager the page will "hang" indefinitely trying to load. When I close the table in Enterprise Manager, the web page will make the connection to the database and the page will load just fine.This particular problem (as far as I can tell) does not happen with any of the other tables contained in the database.So I'm thinking this to be a connections right? I mean, I had to close my connection with the table in Enterprise Manager in order for the web page to make its connection.Under the SQL Server Properties for this server, I checked and made sure that the maximum concurrent user connections is 0 (0=unlimited)...It's really weird though because, again, this problem only happens with one table. All the other tables in the database don't have this problem when a web page tries to update to them while they're open in Enterprise Manager.Any advice from you guys would be sincerely appreciated.Thanks!-Eric |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-30 : 23:27:03
|
| Most likely blocking issue, you can check that with 'sp_who2 active'. |
 |
|
|
|
|
|
Can't load web page with table open in EnterpriseM