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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2006-04-08 : 03:26:40
|
| Hi,I am trying to build a pivot table in excell from a very large table in sql server, there are about 500 fields and 50,000 rows.the error message is 'Protocol Error in TDS Stream' I googled and found the following: http://www.mcse.ms/archive85-2005-5-1491325.htmlIf what they claim is true, then, if I build my excel tool in the server, I wont have any problems? My question is because if I remote login into the server, the IT dpt will of course complain, yet I need to make this pivot table. Also, in the mentioned link they say that if we change the allowed packet size in sql server this could be solved, does anybody know what is the procedure to perform such a change safely? Is there any comment? I need some help.Thank you By the way, I dont think asking in the forum of the link will be of much use as the last login was last year. |
|
|
|
|
|
Packet size too large for pivot tool?