È4 pZ?.:¸<(¡ãÇæå äÇ$üÊëðÇæå äÇ ex070821.log .156.23 HEAD /images/s13.jpg - 80 - 203.209.240.147 iearthworm/1.0,+mailto:iearthworm@yahoo.com.cn 200 0 0 2007-08-21 03:01:09 W3SVC1063621716 58.61.156.23 GET /images/1-I.ht3.jpg - 80 - 203.209.240.176 iearthworm/1.0,+iearthworm@yahoo.com.cn 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 03:58:12 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 03:58:12 W3SVC1063621716 58.61.156.23 GET /1-D.files/image008.jpg - 80 - 203.209.240.173 iearthworm/1.0,+iearthworm@yahoo.com.cn 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 05:03:20 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 05:03:20 W3SVC1063621716 58.61.156.23 GET /tradeinfo/smalllist.asp sortid=13&datetime=1&show= 80 - 124.64.153.164 Mozilla/4.0(compatible;+MSIE+5.0;+Windows+98;+DigExt) 404 0 3 2007-08-21 05:17:58 W3SVC1063621716 58.61.156.23 GET /images/small_294.jpg - 80 - 203.209.240.175 iearthworm/1.0,+iearthworm@yahoo.com.cn 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 05:59:48 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 05:59:47 W3SVC1063621716 58.61.156.23 GET /images/weddingrosesback.jpg - 80 - 203.209.240.179 iearthworm/1.0,+iearthworm@yahoo.com.cn 200 0 0 2007-08-21 06:06:14 W3SVC1063621716 58.61.156.23 GET /robots.txt - 80 - 68.142.212.207 Yahoo-MMCrawler/3.x+(mms+dash+mmcrawler+dash+support+at+yahoo+dash+inc+dot+com) 404 0 2 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 06:22:36 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 06:22:35 W3SVC1063621716 58.61.156.23 GET /1-.files/image026.jpg - 80 - 219.133.125.176 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 06:26:55 W3SVC1063621716 58.61.156.23 HEAD /images/s3.jpg - 80 - 203.209.240.152 iearthworm/1.0,+mailto:iearthworm@yahoo.com.cn 200 0 0 2007-08-21 06:41:21 W3SVC1063621716 58.61.156.23 GET /images/small_292.jpg - 80 - 203.209.240.174 iearthworm/1.0,+iearthworm@yahoo.com.cn 200 0 0 2007-08-21 06:54:53 W3SVC1063621716 58.61.156.23 GET /images/cd401008833.jpg - 80 - 203.209.240.175 iearthworm/1.0,+iearthworm@yahoo.com.cn 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 07:13:12 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 07:13:12 W3SVC1063621716 58.61.156.23 GET /sound/ÃÎÖеĻéÀñ.mid - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:12 W3SVC1063621716 58.61.156.23 GET /flash/78.swf - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:12 W3SVC1063621716 58.61.156.23 GET /index.htm - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:13 W3SVC1063621716 58.61.156.23 GET /flash/25.swf - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:13 W3SVC1063621716 58.61.156.23 GET /flash/123.swf - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:13 W3SVC1063621716 58.61.156.23 GET /flash/09.swf - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:13 W3SVC1063621716 58.61.156.23 GET /images/18.jpg - 80 - 61.141.188.224 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 07:13:14 W3SVC1063621716 58.61.156.23 GET /image0/image.gif - 80 - 61.141.188.22tp://www.google.com/bot.html) 404 0 2 2007-08-21 02:55:17 W3SVC289209039 58.61.156.23 GET /en/contact.htm - 80 - 66.249.73.100 Mozilla/5.0+(compatible;+Googlebot/2.1;++http://www.google.com/bot.html) 200 0 0 2007-08-21 02:57:51 W3SVC289209039 58.61.156.23 GET /cn/sale.htm - 80 - 74.6.20.200 Mozilla/5.0+(compatible;+Yahoo!+Slurp;+http://help.yahoo.com/help/us/ysearch/slurp) 304 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 03:23:44 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 03:23:44 W3SVC289209039 58.61.156.23 GET /index.htm - 80 - 202.108.211.103 Mozilla/4.2 200 0 0 2007-08-21 03:34:02 W3SVC289209039 58.61.156.23 GET /robots.txt - 80 - 207.46.98.134 msnbot/1.0+(+http://search.msn.com/msnbot.htm) 404 0 2 2007-08-21 03:34:03 W3SVC289209039 58.61.156.23 GET /en/news.asp - 80 - 207.46.98.134 msnbot/1.0+(+http://search.msn.com/msnbot.htm) 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 07:48:04 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 07:48:04 W3SVC289209039 58.61.156.23 GET /robots.txt - 80 - 124.115.0.27 Mozilla/4.0+(compatible;+MSIE+6.0) 404 0 2 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 08:30:27 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 08:30:27 W3SVC289209039 58.61.156.23 GET /cn/about.htm - 80 - 74.6.25.143 Mozilla/5.0+(compatible;+Yahoo!+Slurp;+http://help.yahoo.com/help/us/ysearch/slurp) 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 09:23:27 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 09:23:26 W3SVC289209039 58.61.156.23 GET /index.htm - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:27 W3SVC289209039 58.61.156.23 GET /gsming.gif - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:27 W3SVC289209039 58.61.156.23 GET /2400_bg3.gif - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:27 W3SVC289209039 58.61.156.23 GET /copy.gif - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:27 W3SVC289209039 58.61.156.23 GET /css/mystyle_c.css - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:27 W3SVC289209039 58.61.156.23 GET /2400_bg1.gif - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:28 W3SVC289209039 58.61.156.23 GET /index.swf - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:28 W3SVC289209039 58.61.156.23 GET /2400_bg2.gif - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:29 W3SVC289209039 58.61.156.23 GET /t.swf - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:31 W3SVC289209039 58.61.156.23 GET /ei2.swf - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:34 W3SVC289209039 58.61.156.23 GET /cn/about.asp - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:36 W3SVC289209039 58.61.156.23 GET /ei1.swf - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:36 W3SVC289209039 58.61.156.23 GET /cn/about.asp - 80 - 124.64.92.164 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 09:23:39 W3SVC289209039 58.61.156.23 GET /cn/mm_menu.j#Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 02:57:14 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 02:57:14 W3SVC594257010 58.61.156.23 GET /images/t1.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:14 W3SVC594257010 58.61.156.23 GET /cn/qyjj.htm - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:14 W3SVC594257010 58.61.156.23 GET /images/t4.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:14 W3SVC594257010 58.61.156.23 GET /font.css - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:14 W3SVC594257010 58.61.156.23 GET /images/t2.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:14 W3SVC594257010 58.61.156.23 GET /images/00.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /images/l2.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /1.swf - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /images/c1.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /images/input.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 404 0 2 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /images/b.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /images/l1.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:15 W3SVC594257010 58.61.156.23 GET /images/c3.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:17 W3SVC594257010 58.61.156.23 GET /top.swf - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:18 W3SVC594257010 58.61.156.23 GET /images/c2.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:18 W3SVC594257010 58.61.156.23 GET /di.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 02:57:19 W3SVC594257010 58.61.156.23 GET /favicon.ico - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 404 0 2 2007-08-21 03:06:00 W3SVC594257010 58.61.156.23 GET /cn/lxwm.htm - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 2007-08-21 03:06:01 W3SVC594257010 58.61.156.23 GET /images/input.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 404 0 2 2007-08-21 03:06:01 W3SVC594257010 58.61.156.23 GET /images/c03.jpg - 80 - 202.104.204.14 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322) 200 0 0 ogram Files\Network Associates\VirusScan\MID\ Property(S): SourceDir = C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\McAfee VirusScan Enterprise 80\ Property(S): DATVERSION = 4.0.4382 Property(S): Dir23 = C:\Program Files\Network Associates\VirusScan\Res04\ Pro/***************************************************************************** // Copyright (c) 1988-2000 Microsoft Corporation. // All rights reserved. ******************************************************************************/ USE master go -- Make sure catalog updates are enabled (server started in single-user-mode usually) update sysobjects set status = status where id = 0 go if @@error <> 0 raiserror('Upgrade.sql failed catalog updates: restart the server with the ''-f'' option.',22,127) with log go DBCC TRACEON(1717) -- Mark objects as system objects (sp_MS_upd_sysobj_category not yet created!) go -- CREATE A HELPER PROC USED BELOW -- if object_id(N'sp_msupg_removesystemcomputedcolumns') is not null drop proc sp_msupg_removesystemcomputedcolumns go -- INTERNAL PROC: DO NOT DOCUMENT create proc sp_msupg_removesystemcomputedcolumns @tab sysname as begin tran dbcc lockobjectschema (@tab) declare @objid int select @objid = object_id(@tab) -- Delete dependencies of computed columns on other objects DELETE sysdepends FROM sysdepends d WHERE d.id = @objid and d.number in (select colid from syscolumns where id = @objid and (colstat&4)=4) delete syscolumns where id = @objid and (colstat&4)=4 delete syscomments where id = @objid update sysobjects set info = (select max(colid) from syscolumns where id = @objid) where id = @objid commit tran go deny execute on sp_msupg_removesystemcomputedcolumns to public go ------------------------------------------------------------------------------- ----------------- Remove computed columns for master upgrade ------------------ ------------------------------------------------------------------------------- EXEC sp_msupg_removesystemcomputedcolumns sysdatabases EXEC sp_msupg_removesystemcomputedcolumns sysservers EXEC sp_msupg_removesystemcomputedcolumns sysxlogins EXEC sp_msupg_removesystemcomputedcolumns syscharsets go ------------------------------------------------------------------------------- --------------- Upgrade system tables in master (NON-COMPUTED!) --------------- ------------------------------------------------------------------------------- -- sysservers.srvcollation IF NOT EXISTS (SELECT * FROM syscolumns WHERE id = 40 AND colid = 13) BEGIN BEGIN TRAN ALTER TABLE dbo.sysservers ADD srvcollation int null -- update sysserver.srvcollation to be the collation of local server if "collation -- compatible" is set; otherwise set to NULL EXEC ('UPDATE dbo.sysservers SET srvcollation = convert(int, serverproperty(''collationid'')) WHERE srvstatus & 256 = 256') EXEC ('UPDATE dbo.sysservers SET srvcollation = NULL WHERE srvstatus & 256 = 0') COMMIT TRAN END go -- sysservers.srvcollation.connecttimeout/querytimeout IF NOT EXISTS (SELECT * FROM syscolumns WHERE id = 40 AND colid = 14) BEGIN BEGIN TRAN EXEC ('ALTER TABLE dbo.sysservers ADD connecttimeout int NOT NULL, querytimeout int NOT NULL') EXEC ('UPDATE dbo.sysservers SET connecttimeout = 0, querytimeout = 0') COMMIT TRAN END go -- sysaltfiles.createlsn & droplsn IF NOT EXISTS ( select * from syscolumns where name='createlsn' and id = (select id from sysobjects where name='sysaltfiles')) BEGIN BEGIN TRAN ALTER TABLE dbo.sysaltfiles ADD createlsn binary(10) null ALTER TABLE dbo.sysaltfiles ADD droplsn binary(10) null COMMIT TRAN END go -- Add system_function_schema to master IF NOT EXISTS ( SELECT * FROM sysusers WHERE uid = 4 ) INSERT sysusers VALUES (4, 0, 'system_function_schema', NULL, 0x00, getdate(), getdate(), 0, NULL) go -- MAKE 'sysdatabases,sid' ANSI-PADDED. UPDATE syscolumns SET typestat = typestat | 2 WHERE id = object_id('sysdatabases') AND number = 0 AND name = 'sid' go checkpoint go ------------------------------------------------------------------------------- ----------------- Add/Upgrade data in system tables in master ----------------- ------------------------------------------------------------------------------- ----------------------- ---- CONFIG VALUES ---- ----------------------- -- EXISTING CONFIG OPTIONS GET NEW comment AND/OR status -- By existing, we mean options that were there in RTM version of Sphinx. -- NOTE: If you are changing the comment, value and status, then this should -- be considered a *new* option, and you should DELETE then ADD it. -- -- 6/30/99 'Maximum worker threads' is not really dynamic UPDATE sysconfigures SET status = 2 where config = 503 go UPDATE sysconfigures -- bug 233058 SET value = 600 where config = 1520 go -- collation related option 1123/12124/1125 are replaced by serverproperty('sqlsortorder'/'lcid'/'compflags') delete sysconfigures where config in (1123, 1124, 1125) -- 15Jul99 Remove 'language neutral full-text' if not exists (SELECT * FROM dbo.sysconfigures WHERE config = 1126 AND comment = N'default full-text language' ) begin BEGIN TRAN -- if 'language neutral full-text indexing' was set to 1, use language_neutral (0). -- otherwise, use the lcid from the server 'collation' property if there it has -- a corresponding word breaker. -- if there isn't a word breaker associated with this lcid, use neutral. DECLARE @neutral int SELECT @neutral = value FROM sysconfigures WHERE config = 1126 AND comment = N'language neutral full-text indexing' DECLARE @srvlang int SELECT @srvlang = convert(int, CollationPropertyFromID(convert(int, ServerProperty('collationid')), 'lcid')) if @neutral <> 0 begin SELECT @srvlang = 0 end else begin -- langauges that have word breakers today if @srvlang not in ( 0x0409, -- English-US 0x0407, -- German 0x040c, -- French 0x0411, -- Japanese 0x0c0a, -- Spanish 0x0410, -- Italian 0x0413 -- Dutch ) begin SELECT @srvlang = 0 end end UPDATE sysconfigures SET value = @srvlang, comment = 'default full-text language' WHERE config = 1126 AND comment = N'language neutral full-text indexing' COMMIT TRAN end go -- ADD ANY CONFIG NOT YET THERE -- NOTE: If you are adding an option, also add it to the delete guard below the inserts -- IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 101) INSERT sysconfigures (config, status, value, comment) VALUES ( 101, 3 , 0, N'Maximum recovery interval in minutes' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 102) INSERT sysconfigures (config, status, value, comment) VALUES ( 102, 1 , 1, N'Allow updates to system tables' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 103) INSERT sysconfigures (config, status, value, comment) VALUES ( 103, 2 , 0, N'Number of user connections allowed' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 106) INSERT sysconfigures (config, status, value, comment) VALUES ( 106, 2 , 0, N'Number of locks for all users' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 107) INSERT sysconfigures (config, status, value, comment) VALUES ( 107, 2 , 0, N'Number of open database objects' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 109) INSERT sysconfigures (config, status, value, comment) VALUES ( 109, 2 , 0, N'Default fill factor percentage' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 115) INSERT sysconfigures (config, status, value, comment) VALUES ( 115, 1 , 1, N'Allow triggers to be invoked within triggers' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 117) INSERT sysconfigures (config, status, value, comment) VALUES ( 117, 0 , 1, N'Allow remote access' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 124) INSERT sysconfigures (config, status, value, comment) VALUES ( 124, 1 , 0, N'default language' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 503) INSERT sysconfigures (config, status, value, comment) VALUES ( 503, 2 , 255, N'Maximum worker threads' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 505) INSERT sysconfigures (config, status, value, comment) VALUES ( 505, 3 , 4096, N'Network packet size' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 518) INSERT sysconfigures (config, status, value, comment) VALUES ( 518, 1 , 0, N'show advanced options' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 542) INSERT sysconfigures (config, status, value, comment) VALUES ( 542, 1 , 0, N'Create DTC transaction for remote procedures' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 544) INSERT sysconfigures (config, status, value, comment) VALUES ( 544, 2 , 0, N'c2 audit mode' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1126) INSERT sysconfigures (config, status, value, comment) VALUES ( 1126, 3 , 1033, N'default full-text language' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1127) INSERT sysconfigures (config, status, value, comment) VALUES ( 1127, 3 , 2049, N'two digit year cutoff' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1505) INSERT sysconfigures (config, status, value, comment) VALUES ( 1505, 3 , 0, N'Memory for index create sorts (kBytes)' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1517) INSERT sysconfigures (config, status, value, comment) VALUES ( 1517, 2 , 0, N'Priority boost' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1519) INSERT sysconfigures (config, status, value, comment) VALUES ( 1519, 1 , 20, N'remote login timeout' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1520) INSERT sysconfigures (config, status, value, comment) VALUES ( 1520, 1 , 600, N'remote query timeout' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1531) INSERT sysconfigures (config, status, value, comment) VALUES ( 1531, 3 , -1, N'cursor threshold' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1532) INSERT sysconfigures (config, status, value, comment) VALUES ( 1532, 2 , 0, N'set working set size' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1534) INSERT sysconfigures (config, status, value, comment) VALUES ( 1534, 1 , 0, N'user options' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1535) INSERT sysconfigures (config, status, value, comment) VALUES ( 1535, 2 , 0, N'affinity mask' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1536) INSERT sysconfigures (config, status, value, comment) VALUES ( 1536, 1 , 65536, N'Maximum size of a text field in replication.' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1537) INSERT sysconfigures (config, status, value, comment) VALUES ( 1537, 2 , 0, N'Tape retention period in days' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1538) INSERT sysconfigures (config, status, value, comment) VALUES ( 1538, 3 , 5, N'cost threshold for parallelism' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1539) INSERT sysconfigures (config, status, value, comment) VALUES ( 1539, 3 , 0, N'maximum degree of parallelism' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1540) INSERT sysconfigures (config, status, value, comment) VALUES ( 1540, 3 , 1024, N'minimum memory per query (kBytes)' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1541) INSERT sysconfigures (config, status, value, comment) VALUES ( 1541, 3 , -1, N'maximum time to wait for query memory (s)' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1543) INSERT sysconfigures (config, status, value, comment) VALUES ( 1543, 3 , 0, N'Minimum size of server memory (MB)' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1544) INSERT sysconfigures (config, status, value, comment) VALUES ( 1544, 3 ,2147483647, N'Maximum size of server memory (MB)' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1545) INSERT sysconfigures (config, status, value, comment) VALUES ( 1545, 3 , 0, N'Maximum estimated cost allowed by query governor' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1546) INSERT sysconfigures (config, status, value, comment) VALUES ( 1546, 2 , 0, N'User mode scheduler uses lightweight pooling' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1547) INSERT sysconfigures (config, status, value, comment) VALUES ( 1547, 2 , 0, N'scan for startup stored procedures' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1548) INSERT sysconfigures (config, status, value, comment) VALUES ( 1548, 2 , 0, N'AWE enabled in the server' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 1549) INSERT sysconfigures (config, status, value, comment) VALUES ( 1549, 2 , 0, N'affinity64 mask' ) IF NOT EXISTS (SELECT * FROM sysconfigures WHERE config = 400) INSERT sysconfigures (config, status, value, comment) VALUES ( 400, 1 , 0, N'Cross DB Ownership Chaining' ) go -- GUARD against arbitrary addition of options -- Deleting all except those we know are present -- If you are adding an option, also add the config number to list below -- DO NOT ADD any options beyond this point !!! delete sysconfigures where config not in (101, 102, 103, 106, 107, 109, 115, 117, 124, 400, 503, 505, 518, 542, 544, 1126, 1127, 1505, 1517, 1519, 1520, 1531, 1532, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1543, 1544, 1545, 1546, 1547, 1548, 1549 ) go checkpoint go ------------------------------------------------------------------------------- --------------------------------- BUILD SYSCHARSETS --------------------------- ------------------------------------------------------------------------------- -- -- 08Feb98 Added all the SQL Server supported DBCS sort orders. -- Note: case-sensitivity of far east sort orders are hard coded in server -- to avoid Sphinx beta2 - beta3 on disk format changes. -- Ranges 1-240 are documented to be reserved by SQL Server for system use -- DELETE syscharsets where id between 1 and 240 go INSERT syscharsets VALUES ( 1001, 1, 0, 0, N'iso_1', N'ISO 8859-1 (Latin-1) - Western European 8-bit character set.', 0x000008000101080002020800030308000404080005050800060608000707080008080800090908080a0a08080b0b08080c0c08080d0d08080e0e08080f0f0808101008001111080012120800131308001414080015150800161608001717080018180800191908001a1a08001b1b08001c1c08001d1d08001e1e08001f1f0800202008082121202022221020232301202424402025252020262620202727102028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f2020303002143131021432320214333302143434021435350214363602143737021438380214393902143a3a20203b3b20203c3c20203d3d20203e3e20203f3f2020404001204161011142620111436301114464011145650111466601114767010148680101496901014a6a01014b6b01014c6c01014d6d01014e6e01014f6f010150700101517101015272010153730101547401) UPDATE syscharsets set binarydefinition = binarydefinition + 0x0155750101567601015777010158780101597901015a7a01015b5b20205c5c20205d5d20205e5e20205f5f0120606020204161011242620112436301124464011245650112466601124767010248680102496901024a6a01024b6b01024c6c01024d6d01024e6e01024f6f0102507001025171010252720102537301025474010255750102567601025777010258780102597901025a7a01027b7b20207c7c20207d7d20207e7e20207f7f2000808001008181010082820100838301008484010085850100868601008787010088880100898901008a8a01008b8b01008c8c01008d8d01008e8e01088f8f0108909001009191010092920100939301009494010095950100969601009797010098980100999901009a9a01009b9b01009c9c01009d9d01009e9e01009f9f0100a0a00108a1a10120a2a20120a3a34020a4a44020a5a54020a6a60120a7a70120a8a80120a9a90120aaaa0120abab0120acac0120adad0108aeae0120afaf0120b0b00120b1b10120b2 + 0xb20120b3b30120b4b40120b5b50120b6b60120b7b70120b8b80120b9b90120baba0120bbbb0120bcbc0120bdbd0120bebe0120bfbf0120c0e00101c1e10101c2e20101c3e30101c4e40101c5e50101c6e60101c7e70101c8e80101c9e90101caea0101cbeb0101ccec0101cded0101ceee0101cfef0101d0f00101d1f10101d2f20101d3f30101d4f40101d5f50101d6f60101d7d70120d8f80101d9f90101dafa0101dbfb0101dcfc0101ddfd0101defe0101dfdf0101c0e00102c1e10102c2e20102c3e30102c4e40102c5e50102c6e60102c7e70102c8e80102c9e90102caea0102cbeb0102ccec0102cded0102ceee0102cfef0102d0f00102d1f10102d2f20102d3f30102d4f40102d5f50102d6f60102f7f70120d8f80102d9f90102dafa0102dbfb0102dcfc0102ddfd0102defe0102ffff0102000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 + 0x000000000000303132333031323030323234353530313236323330313032303200000000000030313233303132303032323435353031323632333031303230320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003030303030303030303030303030303030303030303030003030303030303030303030303030303030303030303030303030303030303000303030303030303000 WHERE id = 1 go INSERT syscharsets VALUES ( 1001, 2, 0, 0, N'cp850', N'Code Page 850 (Multilingual) character set.', 0x000008000101202002022020030320200404202005052020060620200707082008080820090908080a0a08080b0b08080c0c08080d0d08080e0e20200f0f2020101020201111202012122020131320201414012015150120161620201717202018182020191920201a1a20201b1b20201c1c08201d1d20201e1e20201f1f2020202008082121202022221020232301202424402025252020262620202727102028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f2020303002143131021432320214333302143434021435350214363602143737021438380214393902143a3a20203b3b20203c3c20203d3d20203e3e20203f3f2020404001204161011142620111436301114464011145650111466601114767010148680101496901014a6a01014b6b01014c6c01014d6d01014e6e01014f6f010150700101517101015272010153730101547401015575010156760101) UPDATE syscharsets set binarydefinition = binarydefinition + 0x5777010158780101597901015a7a01015b5b20205c5c20205d5d20205e5e20205f5f0120606020204161011242620112436301124464011245650112466601124767010248680102496901024a6a01024b6b01024c6c01024d6d01024e6e01024f6f0102507001025171010252720102537301025474010255750102567601025777010258780102597901025a7a01027b7b20207c7c20207d7d20207e7e20207f7f2008808701019a81010290820102b68301028e840102b78501028f86010280870102d2880102d3890102d48a0102d88b0102d78c0102de8d01028e8401018f860101908201019291010292910101e293010299940102e3950102ea960102eb97010259980102999401019a8101019d9b01029c9c40209d9b01019e9e01209f9f0120b5a00102d6a10102e0a20102e9a30102a5a40102a5a40101a6a60120a7a70120a8a80120a9a90120aaaa0120abab0120acac0120adad0120aeae0120afaf0120b0b00120b1b10120b2b20120b3b30120b4b4 + 0x0120b5a00101b6830101b7850101b8b80120b9b90120baba0120bbbb0120bcbc0120bdbd0120bebe4020bfbf0120c0c00120c1c10120c2c20120c3c30120c4c40120c5c50120c7c60102c7c60101c8c80120c9c90120caca0120cbcb0120cccc0120cdcd0120cece0120cfcf4020d1d00102d1d00101d2880101d3890101d48a010149d50102d6a10101d78c0101d88b0101d9d90120dada0120dbdb0120dcdc0120dddd0120de8d0101dfdf0120e0a20101e1e10102e2930101e3950101e5e40102e5e40101e6e60102e8e70102e8e70101e9a30101ea960101eb970101edec0102edec0101eeee0120efef0120f0f00120f1f10120f2f20120f3f30120f4f40120f5f50120f6f60120f7f70120f8f80120f9f90120fafa0120fbfb0120fcfc0120fdfd0120fefe0120ffff0120000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000303132 + 0x333031323030323234353530313236323330313032303200000000000030313233303132303032323435353031323632333031303230320000000000303030303030303030303030303030303030303030303030303030300030000030303030303000000000000000000000000000000030303000000000000000000000000000003030000000000000000030303030303030303000000000003000300030303030003030303030303000000000000000000000000000000000000000 WHERE id = 2 go INSERT syscharsets VALUES ( 1001, 3, 0, 0, N'cp437', N'Code Page 437 (United States) character set.', 0x000008000101202002022020030320200404202005052020060620200707082008080820090908080a0a08080b0b08080c0c08080d0d08080e0e20200f0f2020101020201111202012122020131320201414012015150120161620201717202018182020191920201a1a20201b1b20201c1c08201d1d20201e1e20201f1f2020202008082121202022221020232301202424402025252020262620202727102028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f2020303002143131021432320214333302143434021435350214363602143737021438380214393902143a3a20203b3b20203c3c20203d3d20203e3e20203f3f2020404001204161011142620111436301114464011145650111466601114767010148680101496901014a6a01014b6b01014c6c01014d6d01014e6e01014f6f0101507001015171010152720101537301015474010155750101567601) UPDATE syscharsets set binarydefinition = binarydefinition + 0x015777010158780101597901015a7a01015b5b20205c5c20205d5d20205e5e20205f5f0120606020204161011242620112436301124464011245650112466601124767010248680102496901024a6a01024b6b01024c6c01024d6d01024e6e01024f6f0102507001025171010252720102537301025474010255750102567601025777010258780102597901025a7a01027b7b20207c7c20207d7d20207e7e20207f7f2008808701019a81010290820102838301028e840102858501028f8601028087010288880102898901028a8a01028b8b01028c8c01028d8d01028e8401018f860101908201019291010292910101939301029994010295950102969601029797010259980102999401019a8101019b9b01209c9c40209d9d40209e9e01209f9f0120a0a00102a1a10102a2a20102a3a30102a5a40102a5a40101a6a60120a7a70120a8a80120a9a90120aaaa0120abab0120acac0120adad0120aeae0120afaf0120b0b00120b1b10120b2b20120b3b30120b4 + 0xb40120b5b50120b6b60120b7b70120b8b80120b9b90120baba0120bbbb0120bcbc0120bdbd0120bebe0120bfbf0120c0c00120c1c10120c2c20120c3c30120c4c40120c5c50120c6c60120c7c70120c8c80120c9c90120caca0120cbcb0120cccc0120cdcd0120cece0120cfcf0120d0d00120d1d10120d2d20120d3d30120d4d40120d5d50120d6d60120d7d70120d8d80120d9d90120dada0120dbdb0120dcdc0120dddd0120dede0120dfdf0120e0e00102e1e10102e2e20101e3e30102e4e50101e4e50102e6e60102e7e70102e8e80101e9e90101eaea0101ebeb0102ecec0102eded0102eeee0102efef0120f0f00120f1f10120f2f20120f3f30120f4f40120f5f50120f6f60120f7f70120f8f80120f9f90120fafa0120fbfb0120fcfc0120fdfd0120fefe0120ffff01080000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003031 + 0x32333031323030323234353530313236323330313032303200000000000030313233303132303032323435353031323632333031303230320000000000303030303030303030303030303030303030303030303030303030000000000030303030303000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WHERE id = 3 go INSERT syscharsets VALUES ( 1001, 4, 0, 0, N'cp1250', N'Code page 1250', 0x000008000101202002022020030320200404202005052020060620200707082008080820090908080a0a08080b0b08080c0c08080d0d08080e0e20200f0f2020101020201111202012122020131320201414012015150120161620201717202018182020191920201a1a20201b1b20201c1c08201d1d20201e1e20201f1f2020202008082121202022221020232301202424402025252020262620202727102028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f2020303002143131021432320214333302143434021435350214363602143737021438380214393