I have a VB6 ADO app that is inserting a large number of small records into
SQL server 2000. Around 3900 inserts an insert fails saying that the
connection to the server failed. It does no matter if I do this within a
transaction or not. I get the same result.
Sql Conneciton Lifetime ... I am asking a generic question about SQL server (or any type server ... communication for that matter) and how one would keep the connection open... each request? ... packets for that matter) then recovery is much 'cleaner' (e.g. in SQL server ... (microsoft.public.sqlserver.connect)
SQL Connection Lifetime ... I am asking a generic question about SQL server (or any type server ... communication for that matter) and how one would keep the connection open... each request? ... packets for that matter) then recovery is much 'cleaner' (e.g. in SQL server ... (microsoft.public.dotnet.framework.adonet)
SQL Connection Lifetime ... I am asking a generic question about SQL server (or any type server ... communication for that matter) and how one would keep the connection open... each request? ... packets for that matter) then recovery is much 'cleaner' (e.g. in SQL server ... (microsoft.public.sqlserver.clients)
Performance Issue (Winforms) ... attached to a sql server on another machine that's a server using Gigabit ... I tried disabling hyperthreading on the P4 and it didn't matter.... Athlons) to run as fast as the Pentium M? ... Hell the 1.7 smokes the P4 when it's running debug code from ... (microsoft.public.dotnet.framework)
Re: Computer name question ... I did not do a swing today and I ...>SQL server I ... Will that matter to SQL server? ... can I change it to uppercase?... (microsoft.public.backoffice.smallbiz2000)
