does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Does DBCC DBREINDEX update stats?

(Assuming SQL Server 2000, auto create statistics on, auto update
statistics on.)

Does

DBCC DBREINDEX(<tablename>)

update statistics? If yes, are the statistics equivalent to those
that would be produced by:

UPDATE STATISTICS <tablename> WITH FULLSCANDBCC DBREINDEX updates the statistics, while DBCC INDEXDEFRAG does not

http://sqlservercode.blogspot.com/

Does auto update stats do anything if auto create stats are turned off

I am using SQL 2000 and wondered if a database is created and auto create
stats would be turned off, but auto update stats are turned on, does auto
update stats have any stats to update ? I am kinda confused ? Assuming we
load some tables with indexes and have stored procedures,etc..and start
modifying data, will update stats have any stats to work with since auto
create stats is off ? Will query plans ever be recompiled ? Will the query
optimiser figure a different execution plan ?
Are statistics ever created ? Do indexes behave like statistics ?
Thank youHi Hassan,
There is a difference between 'Statistics' as an 'object' and 'Statistical
Information' which is the data stored in the row.
When 'Auto Create Stats' Is turned off, no new statistics will be generated
automatically , i.e. no new statistical 'objects' will be created.
A column that already has a 'statistics' created for it, will still have
it's statistics information 'refreshed' or recollected. this option is
controlled by the 'Auto Update Statistics' option.
Statistics are a seperate object from Indexes. Indexes 'have' Statistics
information that is collected by the query optimizer and stored in the index
row in sysindexes.
Statistics are created not only for indexes, but also for unindexed columns
(for example, columns that participate in join conditions) and are also
stored in sysindexes.
This is done automatically by the query optimizer when the 'Auto Create
Statistics' option is on or you could create it yourself by using the CREATE
STATISTICS statement. To update statistics yourself, you can use the UPDATE
STATISTICS statement or the sp_updatestats system SP.
If you disable either DB options and just leave it at that (not creating and
updating stats), the query optimizer will not be able to choose optimal
execution plans.
It will still produce some plan and your queries will be executed but it's
bound to have a negative effect on performance.
I hope it makes some sense :-)
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OQcYPi7YDHA.2032@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 and wondered if a database is created and auto create
> stats would be turned off, but auto update stats are turned on, does auto
> update stats have any stats to update ? I am kinda confused ? Assuming we
> load some tables with indexes and have stored procedures,etc..and start
> modifying data, will update stats have any stats to work with since auto
> create stats is off ? Will query plans ever be recompiled ? Will the query
> optimiser figure a different execution plan ?
> Are statistics ever created ? Do indexes behave like statistics ?
> Thank you
>|||So if I understand correctly, if Auto Create Stats are not turned on ,
'Statistics' will not be created and hence Auto Update Statistics will only
work with the index created 'Statistics' since only indexes are created
assuming we did not Create Statistics manually. Am I correct ?
"Amy" <l.a@.usa.com> wrote in message
news:eQbneiAZDHA.3232@.tk2msftngp13.phx.gbl...
> Hi Hassan,
> There is a difference between 'Statistics' as an 'object' and 'Statistical
> Information' which is the data stored in the row.
> When 'Auto Create Stats' Is turned off, no new statistics will be
generated
> automatically , i.e. no new statistical 'objects' will be created.
> A column that already has a 'statistics' created for it, will still have
> it's statistics information 'refreshed' or recollected. this option is
> controlled by the 'Auto Update Statistics' option.
> Statistics are a seperate object from Indexes. Indexes 'have' Statistics
> information that is collected by the query optimizer and stored in the
index
> row in sysindexes.
> Statistics are created not only for indexes, but also for unindexed
columns
> (for example, columns that participate in join conditions) and are also
> stored in sysindexes.
> This is done automatically by the query optimizer when the 'Auto Create
> Statistics' option is on or you could create it yourself by using the
CREATE
> STATISTICS statement. To update statistics yourself, you can use the
UPDATE
> STATISTICS statement or the sp_updatestats system SP.
> If you disable either DB options and just leave it at that (not creating
and
> updating stats), the query optimizer will not be able to choose optimal
> execution plans.
> It will still produce some plan and your queries will be executed but it's
> bound to have a negative effect on performance.
> I hope it makes some sense :-)
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OQcYPi7YDHA.2032@.TK2MSFTNGP10.phx.gbl...
> > I am using SQL 2000 and wondered if a database is created and auto
create
> > stats would be turned off, but auto update stats are turned on, does
auto
> > update stats have any stats to update ? I am kinda confused ? Assuming
we
> > load some tables with indexes and have stored procedures,etc..and start
> > modifying data, will update stats have any stats to work with since auto
> > create stats is off ? Will query plans ever be recompiled ? Will the
query
> > optimiser figure a different execution plan ?
> >
> > Are statistics ever created ? Do indexes behave like statistics ?
> >
> > Thank you
> >
> >
>|||AFAIK, Auto update will continue to update all statistics that were created
before turning the option off, including indexes and column statistics.
If you did not execute any queries on the DB prior to turning the auto
create option off, probably no auto statistics were created for columns.
It is recommended that you leave both options 'on'.
The creation process will probaly have a quick 'run in' time. Initially,
there will be no column statistics. once you start issuing queries against
the DB, the query optimizer will create the proper statistics and once it
has 'seen' all your queries, there will be no need to create new ones unless
you change the schema or introduce new queries that use previously unused
columns for joining, searching etc.
The updating process is controlled by SQL server. It uses an algorithm that
takes into account the size of the table and the number of changed rows
since the last statistics collection. It will automatically initiate the
recollection of statistical data when it thinks the old data might be
invalid.
'The cost of this automatic statistical update is minimized by sampling the
data, rather than analyzing all of it.'
Unless your DB experinces very heavy modifications on very large tables and
you have verified for a fact that the statistical update process is causing
performance issues during peak usage and you make sure that the density and
distribution of data does not change in such a way that not updating the
statistics will not cause the optimizer to choose inappropriate plans and
have tested this thoroughly and have prepared some alternatives to creation
and update of statistics during off peak hours etc. etc. then there is
really no need to turn these option off.
Look in BOL under 'statistical information'.
Kalen's 'Inside SQL Server 2000' has an excellent chapter about the query
processor and the way SQL Server handles statistics.
HTH
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eoTHooBZDHA.2020@.TK2MSFTNGP10.phx.gbl...
> So if I understand correctly, if Auto Create Stats are not turned on ,
> 'Statistics' will not be created and hence Auto Update Statistics will
only
> work with the index created 'Statistics' since only indexes are created
> assuming we did not Create Statistics manually. Am I correct ?
> "Amy" <l.a@.usa.com> wrote in message
> news:eQbneiAZDHA.3232@.tk2msftngp13.phx.gbl...
> > Hi Hassan,
> >
> > There is a difference between 'Statistics' as an 'object' and
'Statistical
> > Information' which is the data stored in the row.
> > When 'Auto Create Stats' Is turned off, no new statistics will be
> generated
> > automatically , i.e. no new statistical 'objects' will be created.
> > A column that already has a 'statistics' created for it, will still have
> > it's statistics information 'refreshed' or recollected. this option is
> > controlled by the 'Auto Update Statistics' option.
> >
> > Statistics are a seperate object from Indexes. Indexes 'have' Statistics
> > information that is collected by the query optimizer and stored in the
> index
> > row in sysindexes.
> > Statistics are created not only for indexes, but also for unindexed
> columns
> > (for example, columns that participate in join conditions) and are also
> > stored in sysindexes.
> > This is done automatically by the query optimizer when the 'Auto Create
> > Statistics' option is on or you could create it yourself by using the
> CREATE
> > STATISTICS statement. To update statistics yourself, you can use the
> UPDATE
> > STATISTICS statement or the sp_updatestats system SP.
> >
> > If you disable either DB options and just leave it at that (not creating
> and
> > updating stats), the query optimizer will not be able to choose optimal
> > execution plans.
> > It will still produce some plan and your queries will be executed but
it's
> > bound to have a negative effect on performance.
> >
> > I hope it makes some sense :-)
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:OQcYPi7YDHA.2032@.TK2MSFTNGP10.phx.gbl...
> > > I am using SQL 2000 and wondered if a database is created and auto
> create
> > > stats would be turned off, but auto update stats are turned on, does
> auto
> > > update stats have any stats to update ? I am kinda confused ? Assuming
> we
> > > load some tables with indexes and have stored procedures,etc..and
start
> > > modifying data, will update stats have any stats to work with since
auto
> > > create stats is off ? Will query plans ever be recompiled ? Will the
> query
> > > optimiser figure a different execution plan ?
> > >
> > > Are statistics ever created ? Do indexes behave like statistics ?
> > >
> > > Thank you
> > >
> > >
> >
> >
>

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
FrankFrank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
--
David Gugick
Imceda Software
www.imceda.com|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersion\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Frank wrote:
>> David,
>> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
>> restart, the file was changed again to SSNETLIB.OLD.
>> B/R
>> Frank
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> > David,
> > Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> > restart, the file was changed again to SSNETLIB.OLD.
> > B/R
> > Frank
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:
>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, but
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>> Hi gurus,
>> Recently, my SQL Server Machine is suffering auto shutdown.
>> After the auto shutdown, and restart of the machine, I found that the file
>> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
>> could not be started if I didn't change it back to SSNETLIB.DLL. But after
>a
>> while (usually minutes to tens of minutes), it will auto shutdown again.
>If
>> I didn't not rename it, there will be no auto shutdown.
>> My SQL Server was MSDN developer edition, with SP3 applied.
>> My machine is Windows 2000 professional edition with the latest patches
>> installed.
>> Please help me out
>> Thanks in advance
>> Frank
>>
>

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
Frank
Frank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
David Gugick
Imceda Software
www.imceda.com
|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersion\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Frank wrote:
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/d...displaylang=en
|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>
|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/d...displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:

>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, but
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>a
>If
>

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
FrankFrank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
David Gugick
Imceda Software
www.imceda.com|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/...&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersio
n\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Frank wrote:
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/...&displaylang=en|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/... />
laylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:

>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, bu
t
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>a
>If
>