急！高分，菜鸟问题100分，

Question

忘记说了，会不会跟操作系统有关，我用的是2000 ADERVANCE SERVER，如果是NT会不会有影响

Answer 1

设置了计划任务
在某个时间执行 net stop mssqlserver

Answer 2

你是说每次启动不自动运行吗？  SQL Manager 里的勾去掉。或者5秒后关闭。
WAITFOR DELAY '0:0:05'SHUTDOWN WITH NOWAIT

Answer 3

to qiaojiannan(JNQ) :
我是每隔一段时间SQLSERVER2000就自动停止服务，我没设置计划任务。

Answer 4

计划任务有自动关闭SQL Server项----取消该计划任务；
否则建议重装一下SQL Server----取默认安装项目。
如果想知道它自动关闭的原因，请去系统日志里查找一下。

Answer 5

配置job可以自动定时停止服务。

Answer 6

to eastpond(东塘) ,补丁sp3在哪下啊

Answer 7

是不是你选择了当SQL不稳定时自动重启，然后它断开了，再想启动就启动不起来了，
你最好跟踪一下SQL的日志

Answer 8

下面是SQL Server 日志，到底是怎么回事
1.SQL Server 将终止。发生了严重的异常 c0000005。2.SqlDumpExceptionHandler: 进程 1480 发生了严重的异常 c0000005 EXCEPTION_ACCESS_VIOLATION。SQL Server 将终止该进程。
*******************************************************************************
*
* BEGIN STACK DUMP:
*   07/18/03 04:46:45 spid 0
*
*   Exception Address = 00000000
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred reading address 00000000
*
*  MODULE                          BASE      END       SIZE
* sqlservr                       00400000  00B19FFF  0071a000
* ntdll                          77F80000  77FFAFFF  0007b000
* KERNEL32                       77E60000  77F37FFF  000d8000
* ADVAPI32                       796D0000  79731FFF  00062000
* RPCRT4                         786F0000  7875DFFF  0006e000
* USER32                         77DF0000  77E54FFF  00065000
* GDI32                          77F40000  77F7BFFF  0003c000
* OPENDS60                       41060000  41065FFF  00006000
* MSVCRT                         78000000  78044FFF  00045000
* UMS                            41070000  4107CFFF  0000d000
* SQLSORT                        42AE0000  42B6FFFF  00090000
* MSVCIRT                        780A0000  780B1FFF  00012000
* IMM32                          75E00000  75E19FFF  0001a000
* LPK                            6C330000  6C337FFF  00008000
* USP10                          65D20000  65D73FFF  00054000
* sqlevn70                       41080000  41086FFF  00007000
* NETAPI32                       75100000  7514EFFF  0004f000
* SECUR32                        797B0000  797BEFFF  0000f000
* NETRAP                         75150000  75155FFF  00006000
* SAMLIB                         750E0000  750EEFFF  0000f000
* WS2_32                         74FB0000  74FC3FFF  00014000
* WS2HELP                        74FA0000  74FA7FFF  00008000
* WLDAP32                        77930000  77959FFF  0002a000
* DNSAPI                         77960000  77983FFF  00024000
* WSOCK32                        74FD0000  74FD9FFF  0000a000
* wmi                            760B0000  760B3FFF  00004000
* ole32                          77A30000  77B1BFFF  000ec000
* XOLEHLP                        64AF0000  64AF7FFF  00008000
* MSDTCPRX                       683A0000  68453FFF  000b4000
* MTXCLU                         6A050000  6A05FFFF  00010000
* VERSION                        777E0000  777E6FFF  00007000
* LZ32                           75950000  75955FFF  00006000
* CLUSAPI                        738A0000  738AFFFF  00010000
* RESUTILS                       68100000  6810CFFF  0000d000
* USERENV                        794D0000  79531FFF  00062000
* rnr20                          77800000  7780BFFF  0000c000
* iphlpapi                       77300000  77312FFF  00013000
* ICMP                           774E0000  774E4FFF  00005000
* MPRAPI                         772E0000  772F6FFF  00017000
* OLEAUT32                       77990000  77A2AFFF  0009b000
* ACTIVEDS                       77370000  7739EFFF  0002f000
* ADSLDPC                        77340000  77362FFF  00023000
* RTUTILS                        777F0000  777FDFFF  0000e000
* SETUPAPI                       6D990000  6DA3BFFF  000ac000
* RASAPI32                       774A0000  774D2FFF  00033000
* RASMAN                         77480000  77490FFF  00011000
* TAPI32                         774F0000  77511FFF  00022000
* COMCTL32                       71710000  71793FFF  00084000
* SHLWAPI                        70BD0000  70C34FFF  00065000
* DHCPCSVC                       77320000  77338FFF  00019000
* winrnr                         777A0000  777A7FFF  00008000
* rasadhlp                       777B0000  777B4FFF  00005000
* SSNETLIB                       5BE20000  5BE35FFF  00016000
* SSNMPN70                       410D0000  410D5FFF  00006000
* security                       75490000  75493FFF  00004000
* crypt32                        77400000  77477FFF  00078000
* MSASN1                         773F0000  773FFFFF  00010000
* shell32                        78F90000  791D7FFF  00248000
* msafd                          74F50000  74F6DFFF  0001e000
* wshtcpip                       74F90000  74F96FFF  00007000
* SSmsLPCn                       41600000  41606FFF  00007000
* ntdsapi                        77BD0000  77BE0FFF  00011000
* SQLFTQRY                       418B0000  418CCFFF  0001d000
* CLBCATQ                        72C50000  72CD5FFF  00086000
* sqloledb                       75370000  753E7FFF  00078000
* MSDART                         41BE0000  41C02FFF  00023000
* comdlg32                       76AF0000  76B2DFFF  0003e000
* MSDATL3                        41C10000  41C25FFF  00016000
* oledb32                        41FB0000  4201EFFF  0006f000
* OLEDB32R                       42020000  42030FFF  00011000
* ApiHook                        06000000  06039FFF  0003a000
* MemMon                         05000000  0502EFFF  0002f000
* sqlimage                       05140000  0514CFFF  0000d000
* DBGHELP                        05250000  05262FFF  00013000
*
*        Edi: 00000000: 
*        Esi: 42AE101C: 77E7D38D  77E732AF  77F87BF9  77E79A86  77F89134  77E6A63A  
*        Eax: 00000000: 
*        Ebx: 77E6E6A9: FF28F6E9  8B5753FF  FFBB0C7D  3B0000FF  D3860FFB  8D0000EB  
*        Ecx: 415FFFDC: FFFFFFFF  77E7F0B4  77E6D360  00000000  00000000  00000000  
*        Edx: 00000002: 
*        Eip: 00000000: 
*        Ebp: 415FDB70: 04000000  01010101  01010101  01010101  01010101  01010101  
*      SegCs: 0000001B: 
*     EFlags: 00010246: 00720067  006D0061  00460020  006C0069  00730065  004D005C  
*        Esp: 415FDB30: 415FDC7C  646E6573  00006F74  6B636F73  00007465  5F327377  
*      SegSs: 00000023: 

Answer 9

我下载了补丁sp3，安装时报错，说无法定位Sqlsort.dll,然后就启动不了SQLSERVER了，怎么回事，莫非要把前面的补丁（SP1，SP2）都装才能装sp3吗
谢谢

Answer 10

好像是系统的问题，win2000总会出现这种问题