|
|
Posted by Ben on 11/02/07 07:26
I understand.
I just had to ask cause I wanted to know your input on that. I am still in
the observation state. Personally, I have always set the settings to
default unless it is really, badly necessary to change it. As I did with
SQL Server 2000. That is why I did not think of the packet size that it
needs tweaking. In SQL Server 2000 the packet size was set to zero. I am
assuming that this was the default value, which meant that the packet size
will grow or shrink as needed by SQL Server 2000. I checked the setting in
SQL Server 2005 and the default was 4 KB. Looks like they changed it
indeed.
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99DBEC96A5A74Yazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> What do you mean?
>
> What I meant? I expressed my thanks that you took the time to report
> that your issue was resolved and how it was resolved.
>
> I also expressed my surprise at the resolution. It was not one that I
> would think of myself. Which does not mean that resolution was incorrect
> or anything. I am only happy to learn from other people's experiences.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|