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 |
|
sqldbhl
Starting Member
3 Posts |
 Posted - 2009-10-15 : 09:52:20
|
| Hello,I opened a sql connection to retrieve column headings of a table from a remote sql server on the same network.The connection was opened quickly, and column headings were also retrieved fine.But, when I came to close the connection, it took very long (about 30 seconds).Does any one know what might cause this connection so slow to close?Thanks in advance. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-10-15 : 11:28:13
|
| possibly because it was (implicitly) downloading all the data in the table to the client.what query did you use to "retrieve the column headings"? |
 |
|
|
|
|
|
Sql connection too slow to close