re; however, 260 was for ASE version 10, and has been replaced with trace flag 292). 299 - don't recompile stored procs inheriting a temp table from a parent proc 302 - print info about the optimizer's index selection 310 - print info about the optimizer's join selection (for better join orders) 317 - print info about the optimizer's join selection (for rejected join orders) 319 - print info on reformatting decisions during query processing 1204 - replaced by config option "print deadlock information" 1213 - used with dbcc object_stats; see there (12.0) 1608 - starts only engine 0 ; for use with dbcc engine ( "online" 1610 - replaced by config option "tcp no delay" 2512 - dbcc checkalloc will skip syslogs to suppress spurious alloc. errors 3300 - prints detailed info when performing recovery (can be voluminous) 3502 - log checkpointing of databases in the server errorlog 3604 - redirect dbcc output to client session 3605 - redirect dbcc output to the server errorlog 3607 - opens only master device; "master" db is accessible but not recovered 3608 - recovering only "master" db; other databases are accessible but not recovered; to avoid "log suicide", use "shutdown with nowait" and do not checkpoint. 3609 - all databases are recovered, but tempdb is not re-initialised 3610 - divide-by-zero results in NULL (as in version 4.x), instead of an error 4001 - write every login record to the server errorlog 4012 - don't start checkpoint process 4013 - write loginname, spid and kpid to the server errorlog for every login 4044 - allows to log into server as "sa" when this login is locked 8003 - prints info on RPC calls 8203 - display locking info when deadlock occurs 8399 - used by dbcc monitor to fill sysmonitors table 11201 - Logs CIS client connect- / disconnect- and attention events 11202 - Logs CIS client language, cursor declare, dynamic prepare, and dynamic execute-immediate text 11203 - Logs CIS client rpc events 11204 - Logs all CIS messages routed to client 11205 - Logs all CIS interaction with remote servers 11209 - For "update statistics" on proxy tables, only get row counts, not complete distribution statistics 11218 - Cursors involving proxy tables will be "read only" by default
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
