home *** CD-ROM | disk | FTP | other *** search
| Microsoft Advisor Help | 1992-02-26 | 33.7 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: Microsoft Advisor Help
(document/microsoftAdvisorHelp).
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 66%
| dexvert
| AMOS Picture Packer (image/amosPicturePacker)
| ext
| Supported |
| 1%
| dexvert
| Debian floppy split (archive/debianFloppySplit)
| ext
| Unsupported |
| 1%
| dexvert
| Microsoft Advisor Help (document/microsoftAdvisorHelp)
| magic
| Unsupported |
| 1%
| dexvert
| Quick Help (document/quickHelp)
| magic
| Unsupported |
| 1%
| dexvert
| Sound Images sound sample (audio/soundImagesSoundSample)
| ext
| Unsupported |
| 1%
| dexvert
| STarKos tune (music/sTarKosTune)
| ext
| Unsupported |
| 1%
| dexvert
| CADVANCE drawing (image/cadvanceDrawing)
| ext
| Unsupported |
| 1%
| dexvert
| DESI-III drawing (image/desiIIIDrawing)
| ext
| Unsupported |
| 1%
| dexvert
| MS-DOS PMODE extender executable (executable/msdosPMODEExtenderExecutable)
| ext
| Unsupported |
| 1%
| dexvert
| Alien Trilogytextures (other/alienTrilogyTextures)
| ext
| Unsupported |
| 1%
| dexvert
| APT cache data (other/aptCacheData)
| ext
| Unsupported |
| 1%
| dexvert
| CADVANCE 2D symbol (other/cadvance2DSymbol)
| ext
| Unsupported |
| 1%
| dexvert
| Cakewalk Groove (other/cakewalkGroove)
| ext
| Unsupported |
| 1%
| dexvert
| Comic Book Creator Background (other/comicBookCreatorBackground)
| ext
| Unsupported |
| 1%
| dexvert
| Comic Book Creator shape Table (other/comicBookCreatorShapeTable)
| ext
| Unsupported |
| 1%
| dexvert
| CorelTRACE configuration (other/corelTRACEConfiguration)
| ext
| Unsupported |
| 1%
| dexvert
| Dreamcast Disc (other/dreamcastDisc)
| ext
| Unsupported |
| 1%
| dexvert
| EST flat binary (other/estFlatBinary)
| ext
| Unsupported |
| 1%
| dexvert
| Finale Enigma Binary Format (other/finaleEnigmaBinaryFormat)
| ext
| Unsupported |
| 1%
| dexvert
| Sega Genesis/Megadrive/32x ROM (other/genesisROM)
| ext
| Unsupported |
| 1%
| dexvert
| Myth: The Fallen Lords game archive (other/mythTheFallenLordsGameArchive)
| ext
| Unsupported |
| 1%
| dexvert
| Sega Saturn ROM (other/segaSaturnROM)
| ext
| Unsupported |
| 1%
| dexvert
| Sound Images Sound Driver (other/soundImagesSoundDriver)
| ext
| Unsupported |
| 1%
| dexvert
| Symantec/Norton Config (other/symantecNortonConfig)
| ext
| Unsupported |
| 1%
| dexvert
| Vectrex ROM (other/vectrexROM)
| ext
| Unsupported |
| 1%
| dexvert
| Adrenaline Rush Hour game data (other/adrenalineRushHourGameData)
| ext
| Unsupported |
| 1%
| dexvert
| Bandai Tamagochi game data (other/bandaiTamagochiGameData)
| ext
| Unsupported |
| 1%
| dexvert
| BIS raP encoded format (other/bisraPEncoded)
| ext
| Unsupported |
| 1%
| dexvert
| Linksys RT31P2-NA firmware (other/linksysRT31P2NAFirmware)
| ext
| Unsupported |
| 1%
| dexvert
| Pascal Script binary (other/pascalScriptBinary)
| ext
| Unsupported |
| 1%
| dexvert
| 7th Level game data archive (other/seventhLevelGameDataArchive)
| ext
| Unsupported |
| 1%
| dexvert
| Star Wars Galaxies TRE archive (other/starWarsGalaxiesTREArchive)
| ext
| Unsupported |
| 1%
| dexvert
| Statistica MFM data (other/statisticaMFMData)
| ext
| Unsupported |
| 1%
| dexvert
| Surf's Up game data archive (other/surfsUpGameDataArchive)
| ext
| Unsupported |
| 1%
| dexvert
| TP-Link router firmware (other/tpLinkRouterFirmware)
| ext
| Unsupported |
| 1%
| dexvert
| Binary Text (image/binaryText)
| fallback
| Supported |
| 100%
| file
| MS Advisor help file
| default
| |
| 99%
| file
| data
| default
| |
| 100%
| TrID
| Microsoft Advisor Help
| default
| |
| 100%
| detectItEasy
| Format: Quick Help
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4c 4e 02 00 00 00 3a 00 | 30 00 30 00 4c 00 00 00 |LN....:.|0.0.L...|
|00000010| 73 71 6c 2e 68 6c 70 00 | 00 00 00 00 00 00 00 00 |sql.hlp.|........|
|00000020| 00 00 46 00 00 00 0a 01 | 00 00 d3 02 00 00 00 00 |..F.....|........|
|00000030| 00 00 00 00 00 00 33 03 | 00 00 00 00 00 00 00 00 |......3.|........|
|00000040| 00 00 c3 86 00 00 33 03 | 00 00 38 03 00 00 95 0a |......3.|..8.....|
|00000050| 00 00 c7 0a 00 00 fb 0a | 00 00 34 0b 00 00 6d 0b |........|..4...m.|
|00000060| 00 00 a3 0b 00 00 e1 0b | 00 00 27 0c 00 00 5c 0c |........|..'...\.|
|00000070| 00 00 07 12 00 00 40 17 | 00 00 45 1a 00 00 01 22 |......@.|..E...."|
|00000080| 00 00 a6 27 00 00 f8 2a | 00 00 08 2f 00 00 46 33 |...'...*|.../..F3|
|00000090| 00 00 5c 3c 00 00 e2 3d | 00 00 07 43 00 00 58 48 |..\<...=|...C..XH|
|000000a0| 00 00 2c 4c 00 00 9e 52 | 00 00 97 56 00 00 30 58 |..,L...R|...V..0X|
|000000b0| 00 00 bc 59 00 00 d1 5b | 00 00 03 5e 00 00 39 60 |...Y...[|...^..9`|
|000000c0| 00 00 d6 61 00 00 42 63 | 00 00 76 64 00 00 4a 66 |...a..Bc|..vd..Jf|
|000000d0| 00 00 f2 69 00 00 f6 6c | 00 00 4a 6e 00 00 d3 71 |...i...l|..Jn...q|
|000000e0| 00 00 ac 73 00 00 71 75 | 00 00 57 77 00 00 49 79 |...s..qu|..Ww..Iy|
|000000f0| 00 00 8d 7b 00 00 9f 7d | 00 00 e0 7f 00 00 0e 81 |...{...}|........|
|00000100| 00 00 b4 86 00 00 c3 86 | 00 00 68 2e 63 6f 6e 74 |........|..h.cont|
|00000110| 65 78 74 00 63 6f 6e 74 | 65 6e 74 73 00 6d 64 65 |ext.cont|ents.mde|
|00000120| 76 69 63 65 73 00 6d 64 | 61 74 61 62 61 73 65 73 |vices.md|atabases|
|00000130| 00 6c 6f 67 69 6e 69 64 | 73 00 6d 64 62 75 73 65 |.loginid|s.mdbuse|
|00000140| 72 73 00 6d 70 65 72 6d | 69 73 73 69 6f 6e 73 00 |rs.mperm|issions.|
|00000150| 62 61 63 6b 72 65 63 00 | 63 6f 6e 66 70 65 72 66 |backrec.|confperf|
|00000160| 00 6d 6f 70 74 69 6f 6e | 73 00 61 64 64 64 65 76 |.moption|s.adddev|
|00000170| 69 63 65 00 61 64 64 64 | 75 6d 70 00 64 72 6f 70 |ice.addd|ump.drop|
|00000180| 64 62 64 65 76 69 63 65 | 00 74 72 61 6e 73 6c 6f |dbdevice|.translo|
|00000190| 67 00 64 65 66 61 75 6c | 74 64 62 64 65 76 69 63 |g.defaul|tdbdevic|
|000001a0| 65 00 61 6c 74 65 72 64 | 62 00 61 6c 74 65 72 64 |e.alterd|b.alterd|
|000001b0| 62 74 72 61 6e 73 00 64 | 62 63 63 00 63 72 65 61 |btrans.d|bcc.crea|
|000001c0| 74 65 64 62 00 64 72 6f | 70 64 62 00 67 72 61 6e |tedb.dro|pdb.gran|
|000001d0| 74 00 72 65 76 6f 6b 65 | 00 64 62 6f 70 74 69 6f |t.revoke|.dboptio|
|000001e0| 6e 73 00 71 75 65 72 79 | 00 61 64 64 6c 6f 67 00 |ns.query|.addlog.|
|000001f0| 63 68 61 6e 67 65 70 61 | 73 73 00 63 68 61 6e 67 |changepa|ss.chang|
|00000200| 65 64 65 66 00 64 65 6c | 65 74 65 6c 6f 67 00 61 |edef.del|etelog.a|
|00000210| 64 64 75 73 65 72 00 61 | 64 64 67 72 6f 75 70 00 |dduser.a|ddgroup.|
|00000220| 61 64 64 75 67 72 6f 75 | 70 00 63 68 61 6e 67 65 |addugrou|p.change|
|00000230| 67 72 6f 75 70 00 64 72 | 6f 70 75 64 62 00 72 65 |group.dr|opudb.re|
|00000240| 6d 6f 76 65 67 72 6f 75 | 70 00 63 68 61 6e 67 65 |movegrou|p.change|
|00000250| 64 62 6f 00 63 72 65 61 | 74 65 61 6c 69 61 73 00 |dbo.crea|tealias.|
|00000260| 72 65 6d 6f 76 65 61 6c | 69 61 73 00 62 61 63 6b |removeal|ias.back|
|00000270| 75 70 64 62 00 62 61 63 | 6b 75 70 74 6c 00 72 65 |updb.bac|kuptl.re|
|00000280| 73 74 6f 72 65 64 62 00 | 72 65 73 74 6f 72 65 74 |storedb.|restoret|
|00000290| 6c 00 74 72 75 6e 63 74 | 6c 00 6d 65 6d 6f 70 74 |l.trunct|l.memopt|
|000002a0| 69 6f 6e 73 00 67 65 6e | 6f 70 74 69 6f 6e 73 00 |ions.gen|options.|
|000002b0| 64 79 6e 6f 70 74 69 6f | 6e 73 00 68 65 6c 70 68 |dynoptio|ns.helph|
|000002c0| 65 6c 70 00 68 65 6c 70 | 6b 65 79 73 00 64 75 6d |elp.help|keys.dum|
|000002d0| 6d 79 00 00 00 01 00 02 | 00 03 00 04 00 05 00 06 |my......|........|
|000002e0| 00 07 00 08 00 09 00 0a | 00 0b 00 0c 00 0d 00 0e |........|........|
|000002f0| 00 0f 00 10 00 11 00 12 | 00 13 00 14 00 15 00 16 |........|........|
|00000300| 00 17 00 18 00 19 00 1a | 00 1b 00 1c 00 1d 00 1e |........|........|
|00000310| 00 1f 00 20 00 21 00 22 | 00 23 00 24 00 25 00 26 |... .!."|.#.$.%.&|
|00000320| 00 27 00 28 00 29 00 2a | 00 2b 00 2c 00 2d 00 2e |.'.(.).*|.+.,.-..|
|00000330| 00 2f 00 03 00 01 02 00 | 91 07 1a 11 4d 61 6e 61 |./......|....Mana|
|00000340| 67 69 6e 67 20 44 65 76 | 69 63 65 73 0e 00 ff 0a |ging Dev|ices....|
|00000350| 1a 10 6d 64 65 76 69 63 | 65 73 00 1e 18 05 41 64 |..mdevic|es....Ad|
|00000360| 64 69 6e 67 20 61 20 44 | 61 74 61 62 61 73 65 20 |ding a D|atabase |
|00000370| 44 65 76 69 63 65 0f 00 | ff 06 1d 61 64 64 64 65 |Device..|...addde|
|00000380| 76 69 63 65 00 1a 1a 18 | 05 41 64 64 69 6e 67 20 |vice....|.Adding |
|00000390| 61 20 44 75 6d 70 20 44 | 65 76 69 63 65 0d 00 ff |a Dump D|evice...|
|000003a0| 06 1a 19 61 64 64 64 75 | 6d 70 00 1a 17 18 05 44 |...adddu|mp.....D|
|000003b0| 72 6f 70 70 69 6e 67 20 | 61 20 44 65 76 69 63 65 |ropping |a Device|
|000003c0| 1a 12 00 ff 06 1a 16 64 | 72 6f 70 64 62 64 65 76 |.......d|ropdbdev|
|000003d0| 69 63 65 00 3f 18 05 50 | 75 74 74 69 6e 67 20 74 |ice.?..P|utting t|
|000003e0| 68 65 20 54 72 61 6e 73 | 61 63 74 69 6f 6e 20 4c |he Trans|action L|
|000003f0| 6f 67 20 6f 6e 20 61 20 | 53 65 70 61 72 61 74 65 |og on a |Separate|
|00000400| 20 44 61 74 61 62 61 73 | 65 20 44 65 76 69 63 65 | Databas|e Device|
|00000410| 0e 00 ff 06 3e 74 72 61 | 6e 73 6c 6f 67 00 2a 18 |....>tra|nslog.*.|
|00000420| 05 53 65 74 74 69 6e 67 | 20 75 70 20 61 20 44 65 |.Setting| up a De|
|00000430| 66 61 75 6c 74 20 44 61 | 74 61 62 61 73 65 20 44 |fault Da|tabase D|
|00000440| 65 76 69 63 65 1a 15 00 | ff 06 29 64 65 66 61 75 |evice...|..)defau|
|00000450| 6c 74 64 62 64 65 76 69 | 63 65 00 1a 13 4d 61 6e |ltdbdevi|ce...Man|
|00000460| 61 67 69 6e 67 20 44 61 | 74 61 62 61 73 65 73 1a |aging Da|tabases.|
|00000470| 10 00 ff 0a 1a 12 6d 64 | 61 74 61 62 61 73 65 73 |......md|atabases|
|00000480| 00 23 18 05 43 68 65 63 | 6b 69 6e 67 20 44 61 74 |.#..Chec|king Dat|
|00000490| 61 62 61 73 65 20 43 6f | 6e 73 69 73 74 65 6e 63 |abase Co|nsistenc|
|000004a0| 79 0a 00 ff 06 22 64 62 | 63 63 00 2d 18 05 43 72 |y...."db|cc.-..Cr|
|000004b0| 65 61 74 69 6e 67 20 61 | 20 44 61 74 61 62 61 73 |eating a| Databas|
|000004c0| 65 20 61 6e 64 20 54 72 | 61 6e 73 61 63 74 69 6f |e and Tr|ansactio|
|000004d0| 6e 20 4c 6f 67 0e 00 ff | 06 2c 63 72 65 61 74 65 |n Log...|.,create|
|000004e0| 64 62 00 1a 19 18 05 44 | 72 6f 70 70 69 6e 67 20 |db.....D|ropping |
|000004f0| 61 20 44 61 74 61 62 61 | 73 65 0c 00 ff 06 1a 18 |a Databa|se......|
|00000500| 64 72 6f 70 64 62 00 1e | 18 05 49 6e 63 72 65 61 |dropdb..|..Increa|
|00000510| 73 69 6e 67 20 44 61 74 | 61 62 61 73 65 20 53 69 |sing Dat|abase Si|
|00000520| 7a 65 0d 00 ff 06 1d 61 | 6c 74 65 72 64 62 00 25 |ze.....a|lterdb.%|
|00000530| 18 05 49 6e 63 72 65 61 | 73 69 6e 67 20 54 72 61 |..Increa|sing Tra|
|00000540| 6e 73 61 63 74 69 6f 6e | 20 4c 6f 67 20 53 69 7a |nsaction| Log Siz|
|00000550| 65 1a 12 00 ff 06 24 61 | 6c 74 65 72 64 62 74 72 |e.....$a|lterdbtr|
|00000560| 61 6e 73 00 1a 18 4d 61 | 6e 61 67 69 6e 67 20 55 |ans...Ma|naging U|
|00000570| 73 65 72 20 4c 6f 67 69 | 6e 20 49 44 73 0e 00 ff |ser Logi|n IDs...|
|00000580| 1a 15 1a 17 6c 6f 67 69 | 6e 69 64 73 00 1a 17 18 |....logi|nids....|
|00000590| 05 41 64 64 69 6e 67 20 | 61 20 4c 6f 67 69 6e 20 |.Adding |a Login |
|000005a0| 49 44 0c 00 ff 06 1a 16 | 61 64 64 6c 6f 67 00 18 |ID......|addlog..|
|000005b0| 06 43 68 61 6e 67 69 6e | 67 20 61 20 55 73 65 72 |.Changin|g a User|
|000005c0| 27 73 20 50 61 73 73 77 | 6f 72 64 1a 10 00 ff 06 |'s Passw|ord.....|
|000005d0| 1f 63 68 61 6e 67 65 70 | 61 73 73 00 28 18 05 43 |.changep|ass.(..C|
|000005e0| 68 61 6e 67 69 6e 67 20 | 61 20 55 73 65 72 27 73 |hanging |a User's|
|000005f0| 20 44 65 66 61 75 6c 74 | 20 44 61 74 61 62 61 73 | Default| Databas|
|00000600| 65 0f 00 ff 06 27 63 68 | 61 6e 67 65 64 65 66 00 |e....'ch|angedef.|
|00000610| 27 18 05 44 65 6c 65 74 | 69 6e 67 20 61 20 4c 6f |'..Delet|ing a Lo|
|00000620| 67 69 6e 20 49 44 20 66 | 72 6f 6d 20 61 20 53 65 |gin ID f|rom a Se|
|00000630| 72 76 65 72 0f 00 ff 06 | 26 64 65 6c 65 74 65 6c |rver....|&deletel|
|00000640| 6f 67 00 1a 18 4d 61 6e | 61 67 69 6e 67 20 44 61 |og...Man|aging Da|
|00000650| 74 61 62 61 73 65 20 55 | 73 65 72 73 0e 00 ff 1a |tabase U|sers....|
|00000660| 13 1a 17 6d 64 62 75 73 | 65 72 73 00 21 18 05 41 |...mdbus|ers.!..A|
|00000670| 64 64 69 6e 67 20 61 20 | 55 73 65 72 20 74 6f 20 |dding a |User to |
|00000680| 61 20 44 61 74 61 62 61 | 73 65 0d 00 ff 06 20 61 |a Databa|se.... a|
|00000690| 64 64 75 73 65 72 00 1a | 14 18 05 41 64 64 69 6e |dduser..|...Addin|
|000006a0| 67 20 61 20 47 72 6f 75 | 70 0e 00 ff 06 1a 13 61 |g a Grou|p......a|
|000006b0| 64 64 67 72 6f 75 70 00 | 1e 18 05 41 64 64 69 6e |ddgroup.|...Addin|
|000006c0| 67 20 61 20 55 73 65 72 | 20 74 6f 20 61 20 47 72 |g a User| to a Gr|
|000006d0| 6f 75 70 0f 00 ff 06 1d | 61 64 64 75 67 72 6f 75 |oup.....|addugrou|
|000006e0| 70 00 1d 18 05 43 68 61 | 6e 67 69 6e 67 20 61 20 |p....Cha|nging a |
|000006f0| 55 73 65 72 27 73 20 47 | 72 6f 75 70 1a 11 00 ff |User's G|roup....|
|00000700| 06 1c 63 68 61 6e 67 65 | 67 72 6f 75 70 00 25 18 |..change|group.%.|
|00000710| 05 44 72 6f 70 70 69 6e | 67 20 61 20 55 73 65 72 |.Droppin|g a User|
|00000720| 20 66 72 6f 6d 20 61 20 | 44 61 74 61 62 61 73 65 | from a |Database|
|00000730| 0d 00 ff 06 24 64 72 6f | 70 75 64 62 00 1a 16 18 |....$dro|pudb....|
|00000740| 05 52 65 6d 6f 76 69 6e | 67 20 61 20 47 72 6f 75 |.Removin|g a Grou|
|00000750| 70 1a 11 00 ff 06 1a 15 | 72 65 6d 6f 76 65 67 72 |p.......|removegr|
|00000760| 6f 75 70 00 1f 18 05 43 | 68 61 6e 67 69 6e 67 20 |oup....C|hanging |
|00000770| 61 20 44 61 74 61 62 61 | 73 65 20 4f 77 6e 65 72 |a Databa|se Owner|
|00000780| 0f 00 ff 06 1e 63 68 61 | 6e 67 65 64 62 6f 00 1a |.....cha|ngedbo..|
|00000790| 17 18 05 43 72 65 61 74 | 69 6e 67 20 61 6e 20 41 |...Creat|ing an A|
|000007a0| 6c 69 61 73 1a 11 00 ff | 06 1a 16 63 72 65 61 74 |lias....|...creat|
|000007b0| 65 61 6c 69 61 73 00 1a | 17 18 05 52 65 6d 6f 76 |ealias..|...Remov|
|000007c0| 69 6e 67 20 61 6e 20 41 | 6c 69 61 73 1a 11 00 ff |ing an A|lias....|
|000007d0| 06 1a 16 72 65 6d 6f 76 | 65 61 6c 69 61 73 00 1a |...remov|ealias..|
|000007e0| 15 4d 61 6e 61 67 69 6e | 67 20 50 65 72 6d 69 73 |.Managin|g Permis|
|000007f0| 73 69 6f 6e 73 1a 12 00 | ff 0a 1a 14 6d 70 65 72 |sions...|....mper|
|00000800| 6d 69 73 73 69 6f 6e 73 | 00 1a 1a 18 05 47 72 61 |missions|.....Gra|
|00000810| 6e 74 69 6e 67 20 50 65 | 72 6d 69 73 73 69 6f 6e |nting Pe|rmission|
|00000820| 73 0b 00 ff 06 1a 19 67 | 72 61 6e 74 00 1a 1a 18 |s......g|rant....|
|00000830| 05 52 65 76 6f 6b 69 6e | 67 20 50 65 72 6d 69 73 |.Revokin|g Permis|
|00000840| 73 69 6f 6e 73 0c 00 ff | 06 1a 19 72 65 76 6f 6b |sions...|...revok|
|00000850| 65 00 1d 4d 61 6e 61 67 | 69 6e 67 20 42 61 63 6b |e..Manag|ing Back|
|00000860| 75 70 20 61 6e 64 20 52 | 65 63 6f 76 65 72 79 0d |up and R|ecovery.|
|00000870| 00 ff 1a 15 1c 62 61 63 | 6b 72 65 63 00 1b 18 05 |.....bac|krec....|
|00000880| 42 61 63 6b 69 6e 67 20 | 55 70 20 61 20 44 61 74 |Backing |Up a Dat|
|00000890| 61 62 61 73 65 0e 00 ff | 06 1a 1a 62 61 63 6b 75 |abase...|...backu|
|000008a0| 70 64 62 00 22 18 05 42 | 61 63 6b 69 6e 67 20 55 |pdb."..B|acking U|
|000008b0| 70 20 61 20 54 72 61 6e | 73 61 63 74 69 6f 6e 20 |p a Tran|saction |
|000008c0| 4c 6f 67 0e 00 ff 06 21 | 62 61 63 6b 75 70 74 6c |Log....!|backuptl|
|000008d0| 00 1a 1a 18 05 52 65 73 | 74 6f 72 69 6e 67 20 61 |.....Res|toring a|
|000008e0| 20 44 61 74 61 62 61 73 | 65 0f 00 ff 06 1a 19 72 | Databas|e......r|
|000008f0| 65 73 74 6f 72 65 64 62 | 00 21 18 05 52 65 73 74 |estoredb|.!..Rest|
|00000900| 6f 72 69 6e 67 20 61 20 | 54 72 61 6e 73 61 63 74 |oring a |Transact|
|00000910| 69 6f 6e 20 4c 6f 67 0f | 00 ff 06 20 72 65 73 74 |ion Log.|... rest|
|00000920| 6f 72 65 74 6c 00 22 18 | 05 54 72 75 6e 63 61 74 |oretl.".|.Truncat|
|00000930| 69 6e 67 20 61 20 54 72 | 61 6e 73 61 63 74 69 6f |ing a Tr|ansactio|
|00000940| 6e 20 4c 6f 67 0d 00 ff | 06 21 74 72 75 6e 63 74 |n Log...|.!trunct|
|00000950| 6c 00 27 4d 61 6e 61 67 | 69 6e 67 20 43 6f 6e 66 |l.'Manag|ing Conf|
|00000960| 69 67 75 72 61 74 69 6f | 6e 20 61 6e 64 20 50 65 |iguratio|n and Pe|
|00000970| 72 66 6f 72 6d 61 6e 63 | 65 0e 00 ff 1c 26 63 6f |rformanc|e....&co|
|00000980| 6e 66 70 65 72 66 00 1d | 18 05 43 68 61 6e 67 69 |nfperf..|..Changi|
|00000990| 6e 67 20 4d 65 6d 6f 72 | 79 20 4f 70 74 69 6f 6e |ng Memor|y Option|
|000009a0| 73 1a 10 00 ff 06 1c 6d | 65 6d 6f 70 74 69 6f 6e |s......m|emoption|
|000009b0| 73 00 2c 18 05 43 68 61 | 6e 67 69 6e 67 20 47 65 |s.,..Cha|nging Ge|
|000009c0| 6e 65 72 61 6c 20 43 6f | 6e 66 69 67 75 72 61 74 |neral Co|nfigurat|
|000009d0| 69 6f 6e 20 4f 70 74 69 | 6f 6e 73 1a 10 00 ff 06 |ion Opti|ons.....|
|000009e0| 2b 67 65 6e 6f 70 74 69 | 6f 6e 73 00 2c 18 05 43 |+genopti|ons.,..C|
|000009f0| 68 61 6e 67 69 6e 67 20 | 44 79 6e 61 6d 69 63 20 |hanging |Dynamic |
|00000a00| 43 6f 6e 66 69 67 75 72 | 61 74 69 6f 6e 20 4f 70 |Configur|ation Op|
|00000a10| 74 69 6f 6e 73 1a 10 00 | ff 06 2b 64 79 6e 6f 70 |tions...|..+dynop|
|00000a20| 74 69 6f 6e 73 00 1a 11 | 4d 61 6e 61 67 69 6e 67 |tions...|Managing|
|00000a30| 20 4f 70 74 69 6f 6e 73 | 0e 00 ff 0a 1a 10 6d 6f | Options|......mo|
|00000a40| 70 74 69 6f 6e 73 00 1e | 18 05 53 65 74 74 69 6e |ptions..|..Settin|
|00000a50| 67 20 44 61 74 61 62 61 | 73 65 20 4f 70 74 69 6f |g Databa|se Optio|
|00000a60| 6e 73 0f 00 ff 06 1d 64 | 62 6f 70 74 69 6f 6e 73 |ns.....d|boptions|
|00000a70| 00 1b 18 05 53 65 74 74 | 69 6e 67 20 51 75 65 72 |....Sett|ing Quer|
|00000a80| 79 20 4f 70 74 69 6f 6e | 73 0b 00 ff 06 1a 1a 71 |y Option|s......q|
|00000a90| 75 65 72 79 00 30 00 2e | 53 65 6c 65 63 74 20 61 |uery.0..|Select a|
|00000aa0| 20 73 75 62 68 65 61 64 | 69 6e 67 20 75 6e 64 65 | subhead|ing unde|
|00000ab0| 72 20 22 4d 61 6e 61 67 | 69 6e 67 20 44 65 76 69 |r "Manag|ing Devi|
|00000ac0| 63 65 73 2e 22 02 00 32 | 00 30 53 65 6c 65 63 74 |ces."..2|.0Select|
|00000ad0| 20 61 20 73 75 62 68 65 | 61 64 69 6e 67 20 75 6e | a subhe|ading un|
|00000ae0| 64 65 72 20 22 4d 61 6e | 61 67 69 6e 67 20 44 61 |der "Man|aging Da|
|00000af0| 74 61 62 61 73 65 73 2e | 22 02 00 37 00 35 53 65 |tabases.|"..7.5Se|
|00000b00| 6c 65 63 74 20 61 20 73 | 75 62 68 65 61 64 69 6e |lect a s|ubheadin|
|00000b10| 67 20 75 6e 64 65 72 20 | 22 4d 61 6e 61 67 69 6e |g under |"Managin|
|00000b20| 67 20 55 73 65 72 20 4c | 6f 67 69 6e 20 49 44 73 |g User L|ogin IDs|
|00000b30| 2e 22 02 00 37 00 35 53 | 65 6c 65 63 74 20 61 20 |."..7.5S|elect a |
|00000b40| 73 75 62 68 65 61 64 69 | 6e 67 20 75 6e 64 65 72 |subheadi|ng under|
|00000b50| 20 22 4d 61 6e 61 67 69 | 6e 67 20 44 61 74 61 62 | "Managi|ng Datab|
|00000b60| 61 73 65 20 55 73 65 72 | 73 2e 22 02 00 34 00 32 |ase User|s."..4.2|
|00000b70| 53 65 6c 65 63 74 20 61 | 20 73 75 62 68 65 61 64 |Select a| subhead|
|00000b80| 69 6e 67 20 75 6e 64 65 | 72 20 22 4d 61 6e 61 67 |ing unde|r "Manag|
|00000b90| 69 6e 67 20 50 65 72 6d | 69 73 73 69 6f 6e 73 2e |ing Perm|issions.|
|00000ba0| 22 02 00 3c 00 3a 53 65 | 6c 65 63 74 20 61 20 73 |"..<.:Se|lect a s|
|00000bb0| 75 62 68 65 61 64 69 6e | 67 20 75 6e 64 65 72 20 |ubheadin|g under |
|00000bc0| 22 4d 61 6e 61 67 69 6e | 67 20 42 61 63 6b 75 70 |"Managin|g Backup|
|00000bd0| 20 61 6e 64 20 52 65 63 | 6f 76 65 72 79 2e 22 02 | and Rec|overy.".|
|00000be0| 00 44 00 42 53 65 6c 65 | 63 74 20 61 20 73 75 62 |.D.BSele|ct a sub|
|00000bf0| 68 65 61 64 69 6e 67 20 | 75 6e 64 65 72 20 4d 61 |heading |under Ma|
|00000c00| 6e 61 67 69 6e 67 20 43 | 6f 6e 66 69 67 75 72 61 |naging C|onfigura|
|00000c10| 74 69 6f 6e 20 61 6e 64 | 20 50 65 72 66 6f 72 6d |tion and| Perform|
|00000c20| 61 6e 63 65 2e 02 00 33 | 00 2e 53 65 6c 65 63 74 |ance...3|..Select|
|00000c30| 20 61 20 73 75 62 68 65 | 61 64 69 6e 67 20 75 6e | a subhe|ading un|
|00000c40| 64 65 72 20 22 4d 61 6e | 61 67 69 6e 67 20 4f 70 |der "Man|aging Op|
|00000c50| 74 69 6f 6e 73 2e 22 02 | 00 01 02 00 31 06 1c 3a |tions.".|....1..:|
|00000c60| 6e 20 41 64 64 69 6e 67 | 20 61 20 44 61 74 61 62 |n Adding| a Datab|
|00000c70| 61 73 65 20 44 65 76 69 | 63 65 02 00 3e 44 61 74 |ase Devi|ce..>Dat|
|00000c80| 61 62 61 73 65 20 64 65 | 76 69 63 65 73 20 61 72 |abase de|vices ar|
|00000c90| 65 20 68 61 72 64 20 64 | 69 73 6b 20 66 69 6c 65 |e hard d|isk file|
|00000ca0| 73 20 74 68 61 74 20 73 | 74 6f 72 65 20 64 61 74 |s that s|tore dat|
|00000cb0| 61 62 61 73 65 73 20 61 | 6e 64 02 00 40 74 72 61 |abases a|nd..@tra|
|00000cc0| 6e 73 61 63 74 69 6f 6e | 20 6c 6f 67 73 2e 20 20 |nsaction| logs. |
|00000cd0| 42 65 66 6f 72 65 20 63 | 72 65 61 74 69 6e 67 20 |Before c|reating |
|00000ce0| 61 20 6e 65 77 20 64 61 | 74 61 62 61 73 65 2c 20 |a new da|tabase, |
|00000cf0| 79 6f 75 20 6d 61 79 20 | 68 61 76 65 02 00 36 74 |you may |have..6t|
|00000d00| 6f 20 61 64 64 20 64 61 | 74 61 62 61 73 65 20 64 |o add da|tabase d|
|00000d10| 65 76 69 63 65 73 20 74 | 6f 20 73 74 6f 72 65 20 |evices t|o store |
|00000d20| 74 68 65 20 64 61 74 61 | 62 61 73 65 20 61 6e 64 |the data|base and|
|00000d30| 20 69 74 73 02 00 2c 74 | 72 61 6e 73 61 63 74 69 | its..,t|ransacti|
|00000d40| 6f 6e 20 6c 6f 67 2e 20 | 20 54 6f 20 61 64 64 20 |on log. | To add |
|00000d50| 61 20 64 61 74 61 62 61 | 73 65 20 64 65 76 69 63 |a databa|se devic|
|00000d60| 65 3a 02 00 01 02 00 3d | 31 2e 20 20 28 4f 70 74 |e:.....=|1. (Opt|
|00000d70| 69 6f 6e 61 6c 29 20 46 | 6f 72 20 61 20 6c 69 73 |ional) F|or a lis|
|00000d80| 74 20 6f 66 20 76 69 72 | 74 75 61 6c 20 64 65 76 |t of vir|tual dev|
|00000d90| 69 63 65 20 6e 75 6d 62 | 65 72 73 2c 20 65 78 65 |ice numb|ers, exe|
|00000da0| 63 75 74 65 02 00 1a 13 | 18 04 73 70 5f 68 65 6c |cute....|..sp_hel|
|00000db0| 70 64 65 76 69 63 65 2e | 02 00 01 02 00 1a 17 32 |pdevice.|.......2|
|00000dc0| 2e 20 20 45 78 65 63 75 | 74 65 20 44 49 53 4b 20 |. Execu|te DISK |
|00000dd0| 49 4e 49 54 3a 02 00 01 | 02 00 41 18 04 44 49 53 |INIT:...|..A..DIS|
|00000de0| 4b 20 49 4e 49 54 20 4e | 41 4d 45 20 3d 20 22 6c |K INIT N|AME = "l|
|00000df0| 6f 67 69 63 61 6c 5f 6e | 61 6d 65 22 2c 20 50 48 |ogical_n|ame", PH|
|00000e00| 59 53 4e 41 4d 45 20 3d | 20 22 70 68 79 73 69 63 |YSNAME =| "physic|
|00000e10| 61 6c 5f 6e 61 6d 65 22 | 2c 02 00 41 18 06 56 44 |al_name"|,..A..VD|
|00000e20| 45 56 4e 4f 20 3d 20 76 | 69 72 74 75 61 6c 5f 64 |EVNO = v|irtual_d|
|00000e30| 65 76 69 63 65 5f 6e 75 | 6d 62 65 72 2c 20 53 49 |evice_nu|mber, SI|
|00000e40| 5a 45 20 3d 20 6e 75 6d | 62 65 72 5f 6f 66 5f 32 |ZE = num|ber_of_2|
|00000e50| 4b 5f 62 6c 6f 63 6b 73 | 02 00 01 02 00 2b 18 15 |K_blocks|.....+..|
|00000e60| 3c 50 72 65 73 73 20 50 | 67 44 6e 20 66 6f 72 20 |<Press P|gDn for |
|00000e70| 6d 6f 72 65 3e 02 00 01 | 02 00 36 18 06 2d 20 56 |more>...|..6..- V|
|00000e80| 44 45 56 4e 4f 20 69 73 | 20 61 20 76 69 72 74 75 |DEVNO is| a virtu|
|00000e90| 61 6c 20 64 65 76 69 63 | 65 20 6e 75 6d 62 65 72 |al devic|e number|
|00000ea0| 20 6e 6f 74 20 69 6e 20 | 75 73 65 2e 02 00 3e 18 | not in |use...>.|
|00000eb0| 06 2d 20 53 49 5a 45 20 | 69 73 20 74 68 65 20 6e |.- SIZE |is the n|
|00000ec0| 75 6d 62 65 72 20 6f 66 | 20 32 2d 6b 69 6c 6f 62 |umber of| 2-kilob|
|00000ed0| 79 74 65 20 62 6c 6f 63 | 6b 73 3b 20 66 6f 72 20 |yte bloc|ks; for |
|00000ee0| 65 78 61 6d 70 6c 65 2c | 02 00 29 18 08 61 20 53 |example,|..)..a S|
|00000ef0| 49 5a 45 20 6f 66 20 35 | 31 32 20 65 71 75 61 6c |IZE of 5|12 equal|
|00000f00| 73 20 31 20 6d 65 67 61 | 62 79 74 65 2e 02 00 01 |s 1 mega|byte....|
|00000f10| 02 00 3f 33 2e 20 20 28 | 4f 70 74 69 6f 6e 61 6c |..?3. (|Optional|
|00000f20| 29 20 54 6f 20 6d 61 6b | 65 20 74 68 69 73 20 64 |) To mak|e this d|
|00000f30| 61 74 61 62 61 73 65 20 | 64 65 76 69 63 65 20 61 |atabase |device a|
|00000f40| 20 64 65 66 61 75 6c 74 | 20 64 61 74 61 62 61 73 | default| databas|
|00000f50| 65 02 00 24 18 04 64 65 | 76 69 63 65 2c 20 65 78 |e..$..de|vice, ex|
|00000f60| 65 63 75 74 65 20 73 70 | 5f 64 69 73 6b 64 65 66 |ecute sp|_diskdef|
|00000f70| 61 75 6c 74 3a 02 00 01 | 02 00 3d 18 04 73 70 5f |ault:...|..=..sp_|
|00000f80| 64 69 73 6b 64 65 66 61 | 75 6c 74 20 64 61 74 61 |diskdefa|ult data|
|00000f90| 62 61 73 65 5f 64 65 76 | 69 63 65 2c 20 7b 64 65 |base_dev|ice, {de|
|00000fa0| 66 61 75 6c 74 6f 6e 20 | 7c 20 64 65 66 61 75 6c |faulton || defaul|
|00000fb0| 74 6f 66 66 7d 02 00 3e | 18 04 2d 20 64 65 66 61 |toff}..>|..- defa|
|00000fc0| 75 6c 74 6f 6e 20 61 64 | 64 73 20 61 20 64 61 74 |ulton ad|ds a dat|
|00000fd0| 61 62 61 73 65 20 64 65 | 76 69 63 65 20 74 6f 20 |abase de|vice to |
|00000fe0| 74 68 65 20 70 6f 6f 6c | 20 6f 66 20 64 65 66 61 |the pool| of defa|
|00000ff0| 75 6c 74 02 00 0f 18 06 | 64 65 76 69 63 65 73 2e |ult.....|devices.|
|00001000| 02 00 3c 18 04 2d 20 64 | 65 66 61 75 6c 74 6f 66 |..<..- d|efaultof|
|00001010| 66 20 72 65 6d 6f 76 65 | 73 20 61 20 64 61 74 61 |f remove|s a data|
|00001020| 62 61 73 65 20 64 65 76 | 69 63 65 20 66 72 6f 6d |base dev|ice from|
|00001030| 20 74 68 65 20 70 6f 6f | 6c 20 6f 66 02 00 1a 17 | the poo|l of....|
|00001040| 18 06 64 65 66 61 75 6c | 74 20 64 65 76 69 63 65 |..defaul|t device|
|00001050| 73 2e 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |s......+|..<Press|
|00001060| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|00001070| 00 01 02 00 3f 34 2e 20 | 20 44 75 6d 70 20 74 68 |....?4. | Dump th|
|00001080| 65 20 6d 61 73 74 65 72 | 20 64 61 74 61 62 61 73 |e master| databas|
|00001090| 65 20 75 73 69 6e 67 20 | 74 68 65 20 53 41 46 20 |e using |the SAF |
|000010a0| 41 64 6d 69 6e 20 6d 65 | 6e 75 2e 20 20 49 66 20 |Admin me|nu. If |
|000010b0| 79 6f 75 02 00 3f 18 04 | 61 72 65 20 67 6f 69 6e |you..?..|are goin|
|000010c0| 67 20 74 6f 20 6d 61 6b | 65 20 6d 6f 72 65 20 63 |g to mak|e more c|
|000010d0| 68 61 6e 67 65 73 20 74 | 6f 20 74 68 65 20 6d 61 |hanges t|o the ma|
|000010e0| 73 74 65 72 20 64 61 74 | 61 62 61 73 65 2c 20 79 |ster dat|abase, y|
|000010f0| 6f 75 02 00 43 18 04 63 | 61 6e 20 64 75 6d 70 20 |ou..C..c|an dump |
|00001100| 74 68 65 20 6d 61 73 74 | 65 72 20 64 61 74 61 62 |the mast|er datab|
|00001110| 61 73 65 20 61 66 74 65 | 72 20 61 6c 6c 20 63 68 |ase afte|r all ch|
|00001120| 61 6e 67 65 73 20 68 61 | 76 65 20 62 65 65 6e 20 |anges ha|ve been |
|00001130| 6d 61 64 65 2e 02 00 01 | 02 00 1a 14 45 78 61 6d |made....|....Exam|
|00001140| 70 6c 65 3a 20 20 64 69 | 73 6b 20 69 6e 69 74 02 |ple: di|sk init.|
|00001150| 00 25 18 0c 6e 61 6d 65 | 20 3d 20 22 70 72 6f 64 |.%..name| = "prod|
|00001160| 75 63 74 73 5f 64 62 64 | 65 76 22 2c 02 00 31 18 |ucts_dbd|ev",..1.|
|00001170| 0c 70 68 79 73 6e 61 6d | 65 20 3d 20 22 63 3a 5c |.physnam|e = "c:\|
|00001180| 73 71 6c 5c 64 61 74 61 | 5c 70 72 6f 64 64 62 2e |sql\data|\proddb.|
|00001190| 64 61 74 22 2c 02 00 1a | 18 18 0c 76 64 65 76 6e |dat",...|...vdevn|
|000011a0| 6f 20 3d 20 35 2c 02 00 | 1a 18 18 0c 73 69 7a 65 |o = 5,..|....size|
|000011b0| 20 3d 20 31 30 32 34 02 | 00 1a 14 18 0a 3c 65 78 | = 1024.|.....<ex|
|000011c0| 65 63 75 74 65 3e 02 00 | 33 18 0a 73 70 5f 64 69 |ecute>..|3..sp_di|
|000011d0| 73 6b 64 65 66 61 75 6c | 74 20 70 72 6f 64 75 63 |skdefaul|t produc|
|000011e0| 74 73 5f 64 62 64 65 76 | 2c 20 64 65 66 61 75 6c |ts_dbdev|, defaul|
|000011f0| 74 6f 6e 02 00 1a 14 18 | 0a 3c 65 78 65 63 75 74 |ton.....|.<execut|
|00001200| 65 3e 02 00 01 02 00 99 | 05 1a 18 3a 6e 20 41 64 |e>......|...:n Ad|
|00001210| 64 69 6e 67 20 61 20 44 | 75 6d 70 20 44 65 76 69 |ding a D|ump Devi|
|00001220| 63 65 02 00 40 44 75 6d | 70 20 64 65 76 69 63 65 |ce..@Dum|p device|
|00001230| 73 20 61 72 65 20 64 69 | 73 6b 65 74 74 65 20 6f |s are di|skette o|
|00001240| 72 20 68 61 72 64 20 64 | 69 73 6b 20 66 69 6c 65 |r hard d|isk file|
|00001250| 73 20 74 68 61 74 20 73 | 74 6f 72 65 20 62 61 63 |s that s|tore bac|
|00001260| 6b 75 70 73 02 00 42 28 | 64 75 6d 70 73 29 20 6f |kups..B(|dumps) o|
|00001270| 66 20 64 61 74 61 62 61 | 73 65 73 20 61 6e 64 20 |f databa|ses and |
|00001280| 74 72 61 6e 73 61 63 74 | 69 6f 6e 20 6c 6f 67 73 |transact|ion logs|
|00001290| 2e 20 20 54 6f 20 61 64 | 64 20 61 20 64 75 6d 70 |. To ad|d a dump|
|000012a0| 20 64 65 76 69 63 65 3a | 02 00 01 02 00 3d 31 2e | device:|.....=1.|
|000012b0| 20 20 28 4f 70 74 69 6f | 6e 61 6c 29 20 20 46 6f | (Optio|nal) Fo|
|000012c0| 72 20 61 20 6c 69 73 74 | 20 6f 66 20 65 78 69 73 |r a list| of exis|
|000012d0| 74 69 6e 67 20 64 75 6d | 70 20 64 65 76 69 63 65 |ting dum|p device|
|000012e0| 73 2c 20 65 78 65 63 75 | 74 65 02 00 1a 13 18 04 |s, execu|te......|
|000012f0| 73 70 5f 68 65 6c 70 64 | 65 76 69 63 65 2e 02 00 |sp_helpd|evice...|
|00001300| 01 02 00 1d 32 2e 20 20 | 45 78 65 63 75 74 65 20 |....2. |Execute |
|00001310| 73 70 5f 61 64 64 75 6d | 70 64 65 76 69 63 65 3a |sp_addum|pdevice:|
|00001320| 02 00 01 02 00 3b 18 04 | 73 70 5f 61 64 64 75 6d |.....;..|sp_addum|
|00001330| 70 64 65 76 69 63 65 20 | 7b 22 64 69 73 6b 22 20 |pdevice |{"disk" |
|00001340| 7c 20 22 64 69 73 6b 65 | 74 74 65 22 7d 2c 20 22 || "diske|tte"}, "|
|00001350| 6c 6f 67 69 63 61 6c 5f | 6e 61 6d 65 22 2c 02 00 |logical_|name",..|
|00001360| 33 18 06 22 70 68 79 73 | 69 63 61 6c 5f 6e 61 6d |3.."phys|ical_nam|
|00001370| 65 22 2c 20 63 6e 74 72 | 6c 74 79 70 65 20 5b 2c |e", cntr|ltype [,|
|00001380| 20 6e 6f 20 73 6b 69 70 | 20 7c 20 73 6b 69 70 02 | no skip| | skip.|
|00001390| 00 27 18 06 5b 2c 20 6d | 65 64 69 61 5f 63 61 70 |.'..[, m|edia_cap|
|000013a0| 61 63 69 74 79 5f 69 6e | 5f 6d 65 67 61 62 79 74 |acity_in|_megabyt|
|000013b0| 65 73 5d 5d 02 00 01 02 | 00 01 02 00 2b 18 15 3c |es]]....|....+..<|
|000013c0| 50 72 65 73 73 20 50 67 | 44 6e 20 66 6f 72 20 6d |Press Pg|Dn for m|
|000013d0| 6f 72 65 3e 02 00 01 02 | 00 01 02 00 31 18 04 2d |ore>....|....1..-|
|000013e0| 20 63 6e 74 72 6c 74 79 | 70 65 20 66 6f 72 20 68 | cntrlty|pe for h|
|000013f0| 61 72 64 20 64 69 73 6b | 20 64 75 6d 70 20 64 65 |ard disk| dump de|
|00001400| 76 69 63 65 73 20 69 73 | 20 32 2e 02 00 35 18 04 |vices is| 2...5..|
|00001410| 2d 20 63 6e 74 72 6c 74 | 79 70 65 20 66 6f 72 20 |- cntrlt|ype for |
|00001420| 64 69 73 6b 65 74 74 65 | 20 64 75 6d 70 20 64 65 |diskette| dump de|
|00001430| 76 69 63 65 73 20 69 73 | 20 33 20 6f 72 20 34 2e |vices is| 3 or 4.|
|00001440| 02 00 01 02 00 3f 33 2e | 20 20 44 75 6d 70 20 74 |.....?3.| Dump t|
|00001450| 68 65 20 6d 61 73 74 65 | 72 20 64 61 74 61 62 61 |he maste|r databa|
|00001460| 73 65 20 75 73 69 6e 67 | 20 74 68 65 20 53 41 46 |se using| the SAF|
|00001470| 20 41 64 6d 69 6e 20 6d | 65 6e 75 2e 20 20 49 66 | Admin m|enu. If|
|00001480| 20 79 6f 75 02 00 3f 18 | 04 61 72 65 20 67 6f 69 | you..?.|.are goi|
|00001490| 6e 67 20 74 6f 20 6d 61 | 6b 65 20 6d 6f 72 65 20 |ng to ma|ke more |
|000014a0| 63 68 61 6e 67 65 73 20 | 74 6f 20 74 68 65 20 6d |changes |to the m|
|000014b0| 61 73 74 65 72 20 64 61 | 74 61 62 61 73 65 2c 20 |aster da|tabase, |
|000014c0| 79 6f 75 02 00 43 18 04 | 63 61 6e 20 64 75 6d 70 |you..C..|can dump|
|000014d0| 20 74 68 65 20 6d 61 73 | 74 65 72 20 64 61 74 61 | the mas|ter data|
|000014e0| 62 61 73 65 20 61 66 74 | 65 72 20 61 6c 6c 20 63 |base aft|er all c|
|000014f0| 68 61 6e 67 65 73 20 68 | 61 76 65 20 62 65 65 6e |hanges h|ave been|
|00001500| 20 6d 61 64 65 2e 02 00 | 01 02 00 40 4e 6f 74 65 | made...|...@Note|
|00001510| 3a 20 20 54 6f 20 64 75 | 6d 70 20 61 20 64 61 74 |: To du|mp a dat|
|00001520| 61 62 61 73 65 20 6f 6e | 74 6f 20 61 20 68 61 72 |abase on|to a har|
|00001530| 64 20 64 69 73 6b 2c 20 | 62 65 20 73 75 72 65 20 |d disk, |be sure |
|00001540| 74 6f 20 63 72 65 61 74 | 65 20 61 02 00 39 64 75 |to creat|e a..9du|
|00001550| 6d 70 20 64 65 76 69 63 | 65 20 6f 74 68 65 72 20 |mp devic|e other |
|00001560| 74 68 61 6e 20 22 64 69 | 73 6b 64 75 6d 70 22 2c |than "di|skdump",|
|00001570| 20 77 68 69 63 68 20 69 | 73 20 63 72 65 61 74 65 | which i|s create|
|00001580| 64 20 77 68 65 6e 02 00 | 3b 53 51 4c 20 53 65 72 |d when..|;SQL Ser|
|00001590| 76 65 72 20 69 73 20 69 | 6e 73 74 61 6c 6c 65 64 |ver is i|nstalled|
|000015a0| 2e 20 20 44 75 6d 70 69 | 6e 67 20 61 20 64 61 74 |. Dumpi|ng a dat|
|000015b0| 61 62 61 73 65 20 74 6f | 20 22 64 69 73 6b 64 75 |abase to| "diskdu|
|000015c0| 6d 70 22 02 00 3c 64 6f | 65 73 20 6e 6f 74 20 64 |mp"..<do|es not d|
|000015d0| 75 6d 70 20 79 6f 75 72 | 20 64 61 74 61 20 74 6f |ump your| data to|
|000015e0| 20 61 20 66 69 6c 65 3b | 20 69 74 20 64 75 6d 70 | a file;| it dump|
|000015f0| 73 20 69 74 20 74 6f 20 | 74 68 65 20 22 4e 55 4c |s it to |the "NUL|
|00001600| 22 02 00 35 64 65 76 69 | 63 65 20 28 77 68 69 63 |"..5devi|ce (whic|
|00001610| 68 20 69 73 20 74 68 65 | 20 73 61 6d 65 20 61 73 |h is the| same as|
|00001620| 20 64 75 6d 70 69 6e 67 | 20 69 74 20 74 6f 20 6e | dumping| it to n|
|00001630| 6f 77 68 65 72 65 29 2e | 02 00 01 02 00 2b 18 15 |owhere).|.....+..|
|00001640| 3c 50 72 65 73 73 20 50 | 67 44 6e 20 66 6f 72 20 |<Press P|gDn for |
|00001650| 6d 6f 72 65 3e 02 00 01 | 02 00 35 45 78 61 6d 70 |more>...|..5Examp|
|00001660| 6c 65 20 31 3a 20 20 73 | 70 5f 61 64 64 75 6d 70 |le 1: s|p_addump|
|00001670| 64 65 76 69 63 65 20 22 | 64 69 73 6b 22 2c 20 22 |device "|disk", "|
|00001680| 70 72 6f 64 75 63 74 73 | 5f 64 75 6d 70 22 2c 02 |products|_dump",.|
|00001690| 00 2c 18 0e 22 64 3a 5c | 73 71 6c 5c 64 61 74 61 |.,.."d:\|sql\data|
|000016a0| 5c 70 72 6f 64 64 75 6d | 70 2e 64 61 74 22 2c 20 |\proddum|p.dat", |
|000016b0| 32 02 00 1a 16 18 0c 3c | 65 78 65 63 75 74 65 3e |2......<|execute>|
|000016c0| 02 00 01 02 00 38 45 78 | 61 6d 70 6c 65 20 32 3a |.....8Ex|ample 2:|
|000016d0| 20 20 73 70 5f 61 64 64 | 75 6d 70 64 65 76 69 63 | sp_add|umpdevic|
|000016e0| 65 20 22 64 69 73 6b 65 | 74 74 65 22 2c 20 64 69 |e "diske|tte", di|
|000016f0| 73 6b 65 74 74 65 64 75 | 6d 70 66 22 2c 02 00 39 |skettedu|mpf",..9|
|00001700| 18 0e 22 66 3a 5c 73 71 | 6c 5c 64 61 74 61 5c 73 |.."f:\sq|l\data\s|
|00001710| 71 6c 74 61 62 6c 65 2e | 64 61 74 22 2c 20 33 2c |qltable.|dat", 3,|
|00001720| 20 6e 6f 73 6b 69 70 2c | 20 2e 33 36 02 00 1a 16 | noskip,| .36....|
|00001730| 18 0c 3c 65 78 65 63 75 | 74 65 3e 02 00 01 02 00 |..<execu|te>.....|
|00001740| 33 03 1a 15 3a 6e 20 44 | 72 6f 70 70 69 6e 67 20 |3...:n D|ropping |
|00001750| 61 20 44 65 76 69 63 65 | 02 00 2a 54 6f 20 64 72 |a Device|..*To dr|
|00001760| 6f 70 20 61 20 64 61 74 | 61 62 61 73 65 20 64 65 |op a dat|abase de|
|00001770| 76 69 63 65 20 6f 72 20 | 64 75 6d 70 20 64 65 76 |vice or |dump dev|
|00001780| 69 63 65 3a 02 00 01 02 | 00 3e 31 2e 20 20 28 4f |ice:....|.>1. (O|
|00001790| 70 74 69 6f 6e 61 6c 29 | 20 20 46 6f 72 20 61 20 |ptional)| For a |
|000017a0| 6c 69 73 74 20 6f 66 20 | 64 65 76 69 63 65 73 2c |list of |devices,|
|000017b0| 20 65 78 65 63 75 74 65 | 20 73 70 5f 68 65 6c 70 | execute| sp_help|
|000017c0| 64 65 76 69 63 65 2e 02 | 00 01 02 00 3a 32 2e 20 |device..|....:2. |
|000017d0| 20 42 65 66 6f 72 65 20 | 64 72 6f 70 70 69 6e 67 | Before |dropping|
|000017e0| 20 61 20 64 61 74 61 62 | 61 73 65 20 64 65 76 69 | a datab|ase devi|
|000017f0| 63 65 2c 20 64 72 6f 70 | 20 61 6c 6c 20 64 61 74 |ce, drop| all dat|
|00001800| 61 62 61 73 65 73 02 00 | 36 18 04 73 74 6f 72 65 |abases..|6..store|
|00001810| 64 20 6f 6e 20 74 68 61 | 74 20 64 65 76 69 63 65 |d on tha|t device|
|00001820| 20 62 79 20 65 78 65 63 | 75 74 69 6e 67 20 44 52 | by exec|uting DR|
|00001830| 4f 50 20 44 41 54 41 42 | 41 53 45 2e 02 00 01 02 |OP DATAB|ASE.....|
|00001840| 00 1b 33 2e 20 20 45 78 | 65 63 75 74 65 20 73 70 |..3. Ex|ecute sp|
|00001850| 5f 64 72 6f 70 64 65 76 | 69 63 65 3a 02 00 1f 18 |_dropdev|ice:....|
|00001860| 04 73 70 5f 64 72 6f 70 | 64 65 76 69 63 65 20 6c |.sp_drop|device l|
|00001870| 6f 67 69 63 61 6c 5f 6e | 61 6d 65 02 00 01 02 00 |ogical_n|ame.....|
|00001880| 01 02 00 01 02 00 2b 18 | 15 3c 50 72 65 73 73 20 |......+.|.<Press |
|00001890| 50 67 44 6e 20 66 6f 72 | 20 6d 6f 72 65 3e 02 00 |PgDn for| more>..|
|000018a0| 01 02 00 01 02 00 3f 34 | 2e 20 20 44 75 6d 70 20 |......?4|. Dump |
|000018b0| 74 68 65 20 6d 61 73 74 | 65 72 20 64 61 74 61 62 |the mast|er datab|
|000018c0| 61 73 65 20 75 73 69 6e | 67 20 74 68 65 20 53 41 |ase usin|g the SA|
|000018d0| 46 20 41 64 6d 69 6e 20 | 6d 65 6e 75 2e 20 20 49 |F Admin |menu. I|
|000018e0| 66 20 79 6f 75 02 00 3f | 18 04 61 72 65 20 67 6f |f you..?|..are go|
|000018f0| 69 6e 67 20 74 6f 20 6d | 61 6b 65 20 6d 6f 72 65 |ing to m|ake more|
|00001900| 20 63 68 61 6e 67 65 73 | 20 74 6f 20 74 68 65 20 | changes| to the |
|00001910| 6d 61 73 74 65 72 20 64 | 61 74 61 62 61 73 65 2c |master d|atabase,|
|00001920| 20 79 6f 75 02 00 43 18 | 04 63 61 6e 20 64 75 6d | you..C.|.can dum|
|00001930| 70 20 74 68 65 20 6d 61 | 73 74 65 72 20 64 61 74 |p the ma|ster dat|
|00001940| 61 62 61 73 65 20 61 66 | 74 65 72 20 61 6c 6c 20 |abase af|ter all |
|00001950| 63 68 61 6e 67 65 73 20 | 68 61 76 65 20 62 65 65 |changes |have bee|
|00001960| 6e 20 6d 61 64 65 2e 02 | 00 01 02 00 3a 4e 6f 74 |n made..|....:Not|
|00001970| 65 3a 20 20 44 65 76 69 | 63 65 20 6e 75 6d 62 65 |e: Devi|ce numbe|
|00001980| 72 73 20 6f 66 20 64 72 | 6f 70 70 65 64 20 64 65 |rs of dr|opped de|
|00001990| 76 69 63 65 73 20 63 61 | 6e 6e 6f 74 20 62 65 20 |vices ca|nnot be |
|000019a0| 72 65 75 73 65 64 02 00 | 33 75 6e 74 69 6c 20 53 |reused..|3until S|
|000019b0| 51 4c 20 53 65 72 76 65 | 72 20 68 61 73 20 62 65 |QL Serve|r has be|
|000019c0| 65 6e 20 73 68 75 74 20 | 64 6f 77 6e 20 61 6e 64 |en shut |down and|
|000019d0| 20 72 65 73 74 61 72 74 | 65 64 2e 02 00 01 02 00 | restart|ed......|
|000019e0| 21 45 78 61 6d 70 6c 65 | 3a 20 20 64 72 6f 70 20 |!Example|: drop |
|000019f0| 64 61 74 61 62 61 73 65 | 20 70 72 6f 64 75 63 74 |database| product|
|00001a00| 73 02 00 1a 14 18 0a 3c | 65 78 65 78 75 74 65 3e |s......<|exexute>|
|00001a10| 02 00 27 18 0a 73 70 5f | 64 72 6f 70 64 65 76 69 |..'..sp_|dropdevi|
|00001a20| 63 65 20 70 72 6f 64 75 | 63 74 73 5f 64 62 64 65 |ce produ|cts_dbde|
|00001a30| 76 02 00 1a 14 18 0a 3c | 65 78 65 63 75 74 65 3e |v......<|execute>|
|00001a40| 02 00 01 02 00 77 08 3d | 3a 6e 20 50 75 74 74 69 |.....w.=|:n Putti|
|00001a50| 6e 67 20 74 68 65 20 54 | 72 61 6e 73 61 63 74 69 |ng the T|ransacti|
|00001a60| 6f 6e 20 4c 6f 67 20 6f | 6e 20 61 20 53 65 70 61 |on Log o|n a Sepa|
|00001a70| 72 61 74 65 20 44 61 74 | 61 62 61 73 65 20 44 65 |rate Dat|abase De|
|00001a80| 76 69 63 65 02 00 3c 46 | 6f 72 20 64 61 74 61 62 |vice..<F|or datab|
|00001a90| 61 73 65 73 20 6c 61 72 | 67 65 72 20 74 68 61 6e |ases lar|ger than|
|00001aa0| 20 34 20 6d 65 67 61 62 | 79 74 65 73 2c 20 79 6f | 4 megab|ytes, yo|
|00001ab0| 75 20 73 68 6f 75 6c 64 | 20 73 74 6f 72 65 20 74 |u should| store t|
|00001ac0| 68 65 02 00 3f 64 61 74 | 61 62 61 73 65 20 61 6e |he..?dat|abase an|
|00001ad0| 64 20 69 74 73 20 74 72 | 61 6e 73 61 63 74 69 6f |d its tr|ansactio|
|00001ae0| 6e 20 6c 6f 67 20 6f 6e | 20 64 69 66 66 65 72 65 |n log on| differe|
|00001af0| 6e 74 20 64 61 74 61 62 | 61 73 65 20 64 65 76 69 |nt datab|ase devi|
|00001b00| 63 65 73 02 00 3d 73 6f | 20 74 68 61 74 20 79 6f |ces..=so| that yo|
|00001b10| 75 20 63 61 6e 20 64 75 | 6d 70 20 74 68 65 20 6c |u can du|mp the l|
|00001b20| 6f 67 20 61 6e 64 20 74 | 68 65 20 64 61 74 61 62 |og and t|he datab|
|00001b30| 61 73 65 20 73 65 70 61 | 72 61 74 65 6c 79 2e 20 |ase sepa|rately. |
|00001b40| 54 6f 02 00 2e 70 75 74 | 20 74 68 65 20 74 72 61 |To...put| the tra|
|00001b50| 6e 73 61 63 74 69 6f 6e | 20 6c 6f 67 20 6f 6e 20 |nsaction| log on |
|00001b60| 61 20 73 65 70 61 72 61 | 74 65 20 64 65 76 69 63 |a separa|te devic|
|00001b70| 65 3a 02 00 01 02 00 39 | 31 2e 20 20 28 4f 70 74 |e:.....9|1. (Opt|
|00001b80| 69 6f 6e 61 6c 29 20 20 | 46 6f 72 20 61 20 6c 69 |ional) |For a li|
|00001b90| 73 74 20 6f 66 20 65 78 | 69 73 74 69 6e 67 20 64 |st of ex|isting d|
|00001ba0| 61 74 61 62 61 73 65 20 | 64 65 76 69 63 65 73 2c |atabase |devices,|
|00001bb0| 02 00 3e 18 04 65 78 65 | 63 75 74 65 20 73 70 5f |..>..exe|cute sp_|
|00001bc0| 68 65 6c 70 64 65 76 69 | 63 65 2e 20 20 46 6f 72 |helpdevi|ce. For|
|00001bd0| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 20 6f 6e 20 | informa|tion on |
|00001be0| 77 68 69 63 68 20 64 61 | 74 61 62 61 73 65 02 00 |which da|tabase..|
|00001bf0| 37 18 04 64 65 76 69 63 | 65 20 61 20 64 61 74 61 |7..devic|e a data|
|00001c00| 62 61 73 65 20 69 73 20 | 73 74 6f 72 65 64 20 6f |base is |stored o|
|00001c10| 6e 2c 20 65 78 65 63 75 | 74 65 20 73 70 5f 68 65 |n, execu|te sp_he|
|00001c20| 6c 70 64 62 2e 02 00 01 | 02 00 3e 32 2e 20 20 28 |lpdb....|..>2. (|
|00001c30| 4f 70 74 69 6f 6e 61 6c | 29 20 20 49 66 20 79 6f |Optional|) If yo|
|00001c40| 75 20 63 61 6e 6e 6f 74 | 20 75 73 65 20 61 6e 20 |u cannot| use an |
|00001c50| 65 78 69 73 74 69 6e 67 | 20 64 65 76 69 63 65 20 |existing| device |
|00001c60| 61 6e 64 20 77 61 6e 74 | 02 00 2c 18 04 74 6f 20 |and want|..,..to |
|00001c70| 63 72 65 61 74 65 20 61 | 20 6e 65 77 20 6f 6e 65 |create a| new one|
|00001c80| 2c 20 65 78 65 63 75 74 | 65 20 44 49 53 4b 20 49 |, execut|e DISK I|
|00001c90| 4e 49 54 3a 02 00 01 02 | 00 01 02 00 2b 18 15 3c |NIT:....|....+..<|
|00001ca0| 50 72 65 73 73 20 50 67 | 44 6e 20 66 6f 72 20 6d |Press Pg|Dn for m|
|00001cb0| 6f 72 65 3e 02 00 01 02 | 00 01 02 00 42 18 04 44 |ore>....|....B..D|
|00001cc0| 49 53 4b 20 49 4e 49 54 | 20 4e 41 4d 45 20 3d 20 |ISK INIT| NAME = |
|00001cd0| 22 6c 6f 67 69 63 61 6c | 5f 6e 61 6d 65 22 2c 20 |"logical|_name", |
|00001ce0| 20 50 48 59 53 4e 41 4d | 45 20 3d 20 22 70 68 79 | PHYSNAM|E = "phy|
|00001cf0| 73 69 63 61 6c 5f 6e 61 | 6d 65 22 2c 02 00 42 18 |sical_na|me",..B.|
|00001d00| 06 56 44 45 56 4e 4f 20 | 3d 20 76 69 72 74 75 61 |.VDEVNO |= virtua|
|00001d10| 6c 5f 64 65 76 69 63 65 | 5f 6e 75 6d 62 65 72 2c |l_device|_number,|
|00001d20| 20 20 53 49 5a 45 20 3d | 20 6e 75 6d 62 65 72 5f | SIZE =| number_|
|00001d30| 6f 66 5f 32 4b 5f 62 6c | 6f 63 6b 73 02 00 36 18 |of_2K_bl|ocks..6.|
|00001d40| 06 2d 20 56 44 45 56 4e | 4f 20 69 73 20 61 20 76 |.- VDEVN|O is a v|
|00001d50| 69 72 74 75 61 6c 20 64 | 65 76 69 63 65 20 6e 75 |irtual d|evice nu|
|00001d60| 6d 62 65 72 20 6e 6f 74 | 20 69 6e 20 75 73 65 2e |mber not| in use.|
|00001d70| 02 00 3e 18 06 2d 20 53 | 49 5a 45 20 69 73 20 74 |..>..- S|IZE is t|
|00001d80| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 32 2d 6b |he numbe|r of 2-k|
|00001d90| 69 6c 6f 62 79 74 65 20 | 62 6c 6f 63 6b 73 3b 20 |ilobyte |blocks; |
|00001da0| 66 6f 72 20 65 78 61 6d | 70 6c 65 2c 02 00 29 18 |for exam|ple,..).|
|00001db0| 08 61 20 53 49 5a 45 20 | 6f 66 20 35 31 32 20 65 |.a SIZE |of 512 e|
|00001dc0| 71 75 61 6c 73 20 31 20 | 6d 65 67 61 62 79 74 65 |quals 1 |megabyte|
|00001dd0| 2e 02 00 01 02 00 39 33 | 2e 20 20 28 4f 70 74 69 |......93|. (Opti|
|00001de0| 6f 6e 61 6c 29 20 45 78 | 65 63 75 74 65 20 41 4c |onal) Ex|ecute AL|
|00001df0| 54 45 52 20 44 41 54 41 | 42 41 53 45 20 74 6f 20 |TER DATA|BASE to |
|00001e00| 61 73 73 69 67 6e 20 61 | 74 20 6c 65 61 73 74 02 |assign a|t least.|
|00001e10| 00 32 18 04 31 20 6d 65 | 67 61 62 79 74 65 20 6f |.2..1 me|gabyte o|
|00001e20| 66 20 73 74 6f 72 61 67 | 65 20 74 6f 20 74 68 65 |f storag|e to the|
|00001e30| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 20 6c 6f 67 | transac|tion log|
|00001e40| 3a 02 00 01 02 00 21 18 | 04 41 4c 54 45 52 20 44 |:.....!.|.ALTER D|
|00001e50| 41 54 41 42 41 53 45 20 | 64 61 74 61 62 61 73 65 |ATABASE |database|
|00001e60| 5f 6e 61 6d 65 02 00 3c | 18 06 5b 4f 4e 20 7b 44 |_name..<|..[ON {D|
|00001e70| 45 46 41 55 4c 54 20 7c | 20 64 61 74 61 62 61 73 |EFAULT || databas|
|00001e80| 65 5f 64 65 76 69 63 65 | 7d 20 5b 3d 20 73 69 7a |e_device|} [= siz|
|00001e90| 65 5f 69 6e 5f 6d 65 67 | 61 62 79 74 65 73 5d 02 |e_in_meg|abytes].|
|00001ea0| 00 35 18 06 5b 2c 20 64 | 61 74 61 62 61 73 65 5f |.5..[, d|atabase_|
|00001eb0| 64 65 76 69 63 65 20 5b | 3d 20 73 69 7a 65 5f 69 |device [|= size_i|
|00001ec0| 6e 5f 6d 65 67 61 62 79 | 74 65 73 5d 5d 20 2e 2e |n_megaby|tes]] ..|
|00001ed0| 2e 5d 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |.].....+|..<Press|
|00001ee0| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|00001ef0| 00 01 02 00 3d 18 06 2d | 20 49 66 20 79 6f 75 20 |....=..-| If you |
|00001f00| 64 6f 20 6e 6f 74 20 73 | 70 65 63 69 66 79 20 61 |do not s|pecify a|
|00001f10| 20 73 69 7a 65 2c 20 32 | 20 6d 65 67 61 62 79 74 | size, 2| megabyt|
|00001f20| 65 73 20 61 72 65 20 61 | 64 64 65 64 2e 02 00 3e |es are a|dded...>|
|00001f30| 18 06 2d 20 49 66 20 79 | 6f 75 20 64 6f 20 6e 6f |..- If y|ou do no|
|00001f40| 74 20 73 70 65 63 69 66 | 79 20 61 20 64 61 74 61 |t specif|y a data|
|00001f50| 62 61 73 65 5f 64 65 76 | 69 63 65 2c 20 74 68 65 |base_dev|ice, the|
|00001f60| 20 73 70 61 63 65 20 69 | 73 02 00 3d 18 08 61 6c | space i|s..=..al|
|00001f70| 6c 6f 63 61 74 65 64 20 | 66 72 6f 6d 20 74 68 65 |located |from the|
|00001f80| 20 70 6f 6f 6c 20 6f 66 | 20 64 65 66 61 75 6c 74 | pool of| default|
|00001f90| 20 64 61 74 61 62 61 73 | 65 20 64 65 76 69 63 65 | databas|e device|
|00001fa0| 73 2e 02 00 01 02 00 41 | 34 2e 20 20 45 78 65 63 |s......A|4. Exec|
|00001fb0| 75 74 65 20 73 70 5f 6c | 6f 67 64 65 76 69 63 65 |ute sp_l|ogdevice|
|00001fc0| 20 74 6f 20 6d 61 6b 65 | 20 74 68 65 20 61 64 64 | to make| the add|
|00001fd0| 69 74 69 6f 6e 61 6c 20 | 73 70 61 63 65 20 61 76 |itional |space av|
|00001fe0| 61 69 6c 61 62 6c 65 3a | 02 00 01 02 00 29 18 04 |ailable:|.....)..|
|00001ff0| 73 70 5f 6c 6f 67 64 65 | 76 69 63 65 20 64 62 6e |sp_logde|vice dbn|
|00002000| 61 6d 65 2c 20 64 61 74 | 61 62 61 73 65 5f 64 65 |ame, dat|abase_de|
|00002010| 76 69 63 65 02 00 01 02 | 00 3f 35 2e 20 20 44 75 |vice....|.?5. Du|
|00002020| 6d 70 20 74 68 65 20 6d | 61 73 74 65 72 20 64 61 |mp the m|aster da|
|00002030| 74 61 62 61 73 65 20 75 | 73 69 6e 67 20 74 68 65 |tabase u|sing the|
|00002040| 20 53 41 46 20 41 64 6d | 69 6e 20 6d 65 6e 75 2e | SAF Adm|in menu.|
|00002050| 20 20 49 66 20 79 6f 75 | 02 00 3f 18 04 61 72 65 | If you|..?..are|
|00002060| 20 67 6f 69 6e 67 20 74 | 6f 20 6d 61 6b 65 20 6d | going t|o make m|
|00002070| 6f 72 65 20 63 68 61 6e | 67 65 73 20 74 6f 20 74 |ore chan|ges to t|
|00002080| 68 65 20 6d 61 73 74 65 | 72 20 64 61 74 61 62 61 |he maste|r databa|
|00002090| 73 65 2c 20 79 6f 75 02 | 00 43 18 04 63 61 6e 20 |se, you.|.C..can |
|000020a0| 64 75 6d 70 20 74 68 65 | 20 6d 61 73 74 65 72 20 |dump the| master |
|000020b0| 64 61 74 61 62 61 73 65 | 20 61 66 74 65 72 20 61 |database| after a|
|000020c0| 6c 6c 20 63 68 61 6e 67 | 65 73 20 68 61 76 65 20 |ll chang|es have |
|000020d0| 62 65 65 6e 20 6d 61 64 | 65 2e 02 00 01 02 00 2b |been mad|e......+|
|000020e0| 18 15 3c 50 72 65 73 73 | 20 50 67 44 6e 20 66 6f |..<Press| PgDn fo|
|000020f0| 72 20 6d 6f 72 65 3e 02 | 00 01 02 00 1a 14 45 78 |r more>.|......Ex|
|00002100| 61 6d 70 6c 65 3a 20 20 | 64 69 73 6b 20 69 6e 69 |ample: |disk ini|
|00002110| 74 02 00 23 18 0c 6e 61 | 6d 65 20 3d 20 22 70 72 |t..#..na|me = "pr|
|00002120| 6f 64 75 63 74 73 5f 6c | 6f 67 22 2c 02 00 31 18 |oducts_l|og",..1.|
|00002130| 0c 70 68 79 73 6e 61 6d | 65 20 3d 20 22 63 3a 5c |.physnam|e = "c:\|
|00002140| 73 71 6c 5c 6c 6f 67 5c | 70 72 6f 64 6c 6f 67 2e |sql\log\|prodlog.|
|00002150| 64 61 74 22 2c 02 00 1a | 18 18 0c 76 64 65 76 6e |dat",...|...vdevn|
|00002160| 6f 20 3d 20 35 2c 02 00 | 1a 18 18 0c 73 69 7a 65 |o = 5,..|....size|
|00002170| 20 3d 20 31 30 32 34 02 | 00 1a 14 18 0a 3c 65 78 | = 1024.|.....<ex|
|00002180| 65 63 75 74 65 3e 02 00 | 36 18 0a 61 6c 74 65 72 |ecute>..|6..alter|
|00002190| 20 64 61 74 61 62 61 73 | 65 20 70 72 6f 64 75 63 | databas|e produc|
|000021a0| 74 73 20 6f 6e 20 70 72 | 6f 64 75 63 74 73 5f 6c |ts on pr|oducts_l|
|000021b0| 6f 67 20 3d 20 33 02 00 | 1a 14 18 0a 3c 65 78 65 |og = 3..|....<exe|
|000021c0| 63 75 74 65 3e 02 00 2e | 18 0a 73 70 5f 6c 6f 67 |cute>...|..sp_log|
|000021d0| 64 65 76 69 63 65 20 70 | 72 6f 64 75 63 74 73 2c |device p|roducts,|
|000021e0| 20 70 72 6f 64 75 63 74 | 73 5f 6c 6f 67 02 00 1a | product|s_log...|
|000021f0| 14 18 0a 3c 65 78 65 63 | 75 74 65 3e 02 00 01 02 |...<exec|ute>....|
|00002200| 00 23 06 28 3a 6e 20 53 | 65 74 74 69 6e 67 20 55 |.#.(:n S|etting U|
|00002210| 70 20 61 20 44 65 66 61 | 75 6c 74 20 44 61 74 61 |p a Defa|ult Data|
|00002220| 62 61 73 65 20 44 65 76 | 69 63 65 02 00 40 57 68 |base Dev|ice..@Wh|
|00002230| 65 6e 20 63 72 65 61 74 | 69 6e 67 20 6f 72 20 61 |en creat|ing or a|
|00002240| 6c 74 65 72 69 6e 67 20 | 61 20 64 61 74 61 62 61 |ltering |a databa|
|00002250| 73 65 2c 20 79 6f 75 20 | 63 61 6e 20 61 73 73 69 |se, you |can assi|
|00002260| 67 6e 20 64 69 73 6b 20 | 73 70 61 63 65 02 00 41 |gn disk |space..A|
|00002270| 74 6f 20 61 20 73 70 65 | 63 69 66 69 63 20 64 61 |to a spe|cific da|
|00002280| 74 61 62 61 73 65 20 64 | 65 76 69 63 65 20 6f 72 |tabase d|evice or|
|00002290| 20 74 6f 20 74 68 65 20 | 64 65 66 61 75 6c 74 20 | to the |default |
|000022a0| 70 6f 6f 6c 20 6f 66 20 | 64 61 74 61 62 61 73 65 |pool of |database|
|000022b0| 02 00 38 64 65 76 69 63 | 65 73 2e 20 20 54 6f 20 |..8devic|es. To |
|000022c0| 61 64 64 20 61 20 64 61 | 74 61 62 61 73 65 20 64 |add a da|tabase d|
|000022d0| 65 76 69 63 65 20 74 6f | 20 74 68 65 20 64 65 66 |evice to| the def|
|000022e0| 61 75 6c 74 20 70 6f 6f | 6c 3a 02 00 01 02 00 3c |ault poo|l:.....<|
|000022f0| 31 2e 20 20 28 4f 70 74 | 69 6f 6e 61 6c 29 20 20 |1. (Opt|ional) |
|00002300| 54 6f 20 73 65 65 20 68 | 6f 77 20 6d 75 63 68 20 |To see h|ow much |
|00002310| 73 70 61 63 65 20 69 73 | 20 61 76 61 69 6c 61 62 |space is| availab|
|00002320| 6c 65 2c 20 65 78 65 63 | 75 74 65 02 00 01 02 00 |le, exec|ute.....|
|00002330| 1a 12 18 04 73 70 5f 73 | 70 61 63 65 75 73 65 64 |....sp_s|paceused|
|00002340| 2e 02 00 01 02 00 3e 32 | 2e 20 20 28 4f 70 74 69 |......>2|. (Opti|
|00002350| 6f 6e 61 6c 29 20 20 49 | 66 20 61 20 64 61 74 61 |onal) I|f a data|
|00002360| 62 61 73 65 20 64 65 76 | 69 63 65 20 77 69 74 68 |base dev|ice with|
|00002370| 20 66 72 65 65 20 73 70 | 61 63 65 20 64 6f 65 73 | free sp|ace does|
|00002380| 20 6e 6f 74 02 00 3a 18 | 04 65 78 69 73 74 2c 20 | not..:.|.exist, |
|00002390| 65 78 65 63 75 74 65 20 | 44 49 53 4b 20 49 4e 49 |execute |DISK INI|
|000023a0| 54 20 74 6f 20 63 72 65 | 61 74 65 20 61 20 64 61 |T to cre|ate a da|
|000023b0| 74 61 62 61 73 65 20 64 | 65 76 69 63 65 3a 02 00 |tabase d|evice:..|
|000023c0| 01 02 00 41 18 04 44 49 | 53 4b 20 49 4e 49 54 20 |...A..DI|SK INIT |
|000023d0| 4e 41 4d 45 20 3d 20 22 | 6c 6f 67 69 63 61 6c 5f |NAME = "|logical_|
|000023e0| 6e 61 6d 65 22 2c 20 50 | 48 59 53 4e 41 4d 45 20 |name", P|HYSNAME |
|000023f0| 3d 20 22 70 68 79 73 69 | 63 61 6c 5f 6e 61 6d 65 |= "physi|cal_name|
|00002400| 22 2c 02 00 41 18 06 56 | 44 45 56 4e 4f 20 3d 20 |",..A..V|DEVNO = |
|00002410| 76 69 72 74 75 61 6c 5f | 64 65 76 69 63 65 5f 6e |virtual_|device_n|
|00002420| 75 6d 62 65 72 2c 20 53 | 49 5a 45 20 3d 20 6e 75 |umber, S|IZE = nu|
|00002430| 6d 62 65 72 5f 6f 66 5f | 32 4b 5f 62 6c 6f 63 6b |mber_of_|2K_block|
|00002440| 73 02 00 01 02 00 2b 18 | 15 3c 50 72 65 73 73 20 |s.....+.|.<Press |
|00002450| 50 67 44 6e 20 66 6f 72 | 20 6d 6f 72 65 3e 02 00 |PgDn for| more>..|
|00002460| 01 02 00 36 18 06 2d 20 | 56 44 45 56 4e 4f 20 69 |...6..- |VDEVNO i|
|00002470| 73 20 61 20 76 69 72 74 | 75 61 6c 20 64 65 76 69 |s a virt|ual devi|
|00002480| 63 65 20 6e 75 6d 62 65 | 72 20 6e 6f 74 20 69 6e |ce numbe|r not in|
|00002490| 20 75 73 65 2e 02 00 3e | 18 06 2d 20 53 49 5a 45 | use...>|..- SIZE|
|000024a0| 20 69 73 20 74 68 65 20 | 6e 75 6d 62 65 72 20 6f | is the |number o|
|000024b0| 66 20 32 2d 6b 69 6c 6f | 62 79 74 65 20 62 6c 6f |f 2-kilo|byte blo|
|000024c0| 63 6b 73 3b 20 66 6f 72 | 20 65 78 61 6d 70 6c 65 |cks; for| example|
|000024d0| 2c 02 00 29 18 08 61 20 | 53 49 5a 45 20 6f 66 20 |,..)..a |SIZE of |
|000024e0| 35 31 32 20 65 71 75 61 | 6c 73 20 31 20 6d 65 67 |512 equa|ls 1 meg|
|000024f0| 61 62 79 74 65 2e 02 00 | 01 02 00 1c 33 2e 20 20 |abyte...|....3. |
|00002500| 45 78 65 63 75 74 65 20 | 73 70 5f 64 69 73 6b 64 |Execute |sp_diskd|
|00002510| 65 66 61 75 6c 74 3a 02 | 00 01 02 00 3d 18 04 73 |efault:.|....=..s|
|00002520| 70 5f 64 69 73 6b 64 65 | 66 61 75 6c 74 20 64 61 |p_diskde|fault da|
|00002530| 74 61 62 61 73 65 5f 64 | 65 76 69 63 65 2c 20 7b |tabase_d|evice, {|
|00002540| 64 65 66 61 75 6c 74 6f | 6e 20 7c 20 64 65 66 61 |defaulto|n | defa|
|00002550| 75 6c 74 6f 66 66 7d 02 | 00 01 02 00 3e 18 04 2d |ultoff}.|....>..-|
|00002560| 20 64 65 66 61 75 6c 74 | 6f 6e 20 61 64 64 73 20 | default|on adds |
|00002570| 61 20 64 61 74 61 62 61 | 73 65 20 64 65 76 69 63 |a databa|se devic|
|00002580| 65 20 74 6f 20 74 68 65 | 20 70 6f 6f 6c 20 6f 66 |e to the| pool of|
|00002590| 20 64 65 66 61 75 6c 74 | 02 00 0f 18 06 64 65 76 | default|.....dev|
|000025a0| 69 63 65 73 2e 02 00 3c | 18 04 2d 20 64 65 66 61 |ices...<|..- defa|
|000025b0| 75 6c 74 6f 66 66 20 72 | 65 6d 6f 76 65 73 20 61 |ultoff r|emoves a|
|000025c0| 20 64 61 74 61 62 61 73 | 65 20 64 65 76 69 63 65 | databas|e device|
|000025d0| 20 66 72 6f 6d 20 74 68 | 65 20 70 6f 6f 6c 20 6f | from th|e pool o|
|000025e0| 66 02 00 1a 17 18 06 64 | 65 66 61 75 6c 74 20 64 |f......d|efault d|
|000025f0| 65 76 69 63 65 73 2e 02 | 00 01 02 00 2b 18 15 3c |evices..|....+..<|
|00002600| 50 72 65 73 73 20 50 67 | 44 6e 20 66 6f 72 20 6d |Press Pg|Dn for m|
|00002610| 6f 72 65 3e 02 00 01 02 | 00 3e 34 2e 20 20 44 75 |ore>....|.>4. Du|
|00002620| 6d 70 20 74 68 65 20 6d | 61 73 74 65 72 20 64 61 |mp the m|aster da|
|00002630| 74 61 62 61 73 65 20 75 | 73 69 6e 67 20 74 68 65 |tabase u|sing the|
|00002640| 20 53 41 46 20 41 64 6d | 69 6e 20 6d 65 6e 75 2e | SAF Adm|in menu.|
|00002650| 20 49 66 20 79 6f 75 02 | 00 3f 18 04 61 72 65 20 | If you.|.?..are |
|00002660| 67 6f 69 6e 67 20 74 6f | 20 6d 61 6b 65 20 6d 6f |going to| make mo|
|00002670| 72 65 20 63 68 61 6e 67 | 65 73 20 74 6f 20 74 68 |re chang|es to th|
|00002680| 65 20 6d 61 73 74 65 72 | 20 64 61 74 61 62 61 73 |e master| databas|
|00002690| 65 2c 20 79 6f 75 02 00 | 43 18 04 63 61 6e 20 64 |e, you..|C..can d|
|000026a0| 75 6d 70 20 74 68 65 20 | 6d 61 73 74 65 72 20 64 |ump the |master d|
|000026b0| 61 74 61 62 61 73 65 20 | 61 66 74 65 72 20 61 6c |atabase |after al|
|000026c0| 6c 20 63 68 61 6e 67 65 | 73 20 68 61 76 65 20 62 |l change|s have b|
|000026d0| 65 65 6e 20 6d 61 64 65 | 2e 02 00 01 02 00 2d 45 |een made|......-E|
|000026e0| 78 61 6d 70 6c 65 3a 20 | 20 64 69 73 6b 20 69 6e |xample: | disk in|
|000026f0| 69 74 20 6e 61 6d 65 20 | 3d 20 22 70 72 6f 64 75 |it name |= "produ|
|00002700| 63 74 73 5f 64 62 64 65 | 76 22 2c 02 00 31 18 0c |cts_dbde|v",..1..|
|00002710| 70 68 79 73 6e 61 6d 65 | 20 3d 20 22 63 3a 5c 73 |physname| = "c:\s|
|00002720| 71 6c 5c 64 61 74 61 5c | 70 72 6f 64 64 62 2e 64 |ql\data\|proddb.d|
|00002730| 61 74 22 2c 02 00 1a 18 | 18 0c 76 64 65 76 6e 6f |at",....|..vdevno|
|00002740| 20 3d 20 35 2c 02 00 1a | 18 18 0c 73 69 7a 65 20 | = 5,...|...size |
|00002750| 3d 20 31 30 32 34 02 00 | 1a 14 18 0a 3c 65 78 65 |= 1024..|....<exe|
|00002760| 63 75 74 65 3e 02 00 33 | 18 0a 73 70 5f 64 69 73 |cute>..3|..sp_dis|
|00002770| 6b 64 65 66 61 75 6c 74 | 20 70 72 6f 64 75 63 74 |kdefault| product|
|00002780| 73 5f 64 62 64 65 76 2c | 20 64 65 66 61 75 6c 74 |s_dbdev,| default|
|00002790| 6f 6e 02 00 1a 14 18 0a | 3c 65 78 65 63 75 74 65 |on......|<execute|
|000027a0| 3e 02 00 01 02 00 84 03 | 1c 3a 6e 20 49 6e 63 72 |>.......|.:n Incr|
|000027b0| 65 61 73 69 6e 67 20 44 | 61 74 61 62 61 73 65 20 |easing D|atabase |
|000027c0| 53 69 7a 65 02 00 1b 54 | 6f 20 69 6e 63 72 65 61 |Size...T|o increa|
|000027d0| 73 65 20 64 61 74 61 62 | 61 73 65 20 73 69 7a 65 |se datab|ase size|
|000027e0| 3a 02 00 01 02 00 3f 31 | 2e 20 20 28 4f 70 74 69 |:.....?1|. (Opti|
|000027f0| 6f 6e 61 6c 29 20 54 6f | 20 66 69 6e 64 20 74 68 |onal) To| find th|
|00002800| 65 20 6c 6f 67 69 63 61 | 6c 20 6e 61 6d 65 20 6f |e logica|l name o|
|00002810| 66 20 74 68 65 20 64 61 | 74 61 62 61 73 65 20 64 |f the da|tabase d|
|00002820| 65 76 69 63 65 02 00 38 | 18 04 6f 6e 20 77 68 69 |evice..8|..on whi|
|00002830| 63 68 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |ch the d|atabase |
|00002840| 69 73 20 73 74 6f 72 65 | 64 2c 20 65 78 65 63 75 |is store|d, execu|
|00002850| 74 65 20 73 70 5f 68 65 | 6c 70 64 62 2e 02 00 01 |te sp_he|lpdb....|
|00002860| 02 00 1c 32 2e 20 20 45 | 78 65 63 75 74 65 20 41 |...2. E|xecute A|
|00002870| 4c 54 45 52 20 44 41 54 | 41 42 41 53 45 3a 02 00 |LTER DAT|ABASE:..|
|00002880| 01 02 00 21 18 04 41 4c | 54 45 52 20 44 41 54 41 |...!..AL|TER DATA|
|00002890| 42 41 53 45 20 64 61 74 | 61 62 61 73 65 5f 6e 61 |BASE dat|abase_na|
|000028a0| 6d 65 02 00 3d 18 07 5b | 4f 4e 20 7b 44 45 46 41 |me..=..[|ON {DEFA|
|000028b0| 55 4c 54 20 7c 20 64 61 | 74 61 62 61 73 65 5f 64 |ULT | da|tabase_d|
|000028c0| 65 76 69 63 65 7d 20 5b | 3d 20 73 69 7a 65 5f 69 |evice} [|= size_i|
|000028d0| 6e 5f 6d 65 67 61 62 79 | 74 65 73 5d 02 00 36 18 |n_megaby|tes]..6.|
|000028e0| 07 5b 2c 20 64 61 74 61 | 62 61 73 65 5f 64 65 76 |.[, data|base_dev|
|000028f0| 69 63 65 20 5b 3d 20 73 | 69 7a 65 5f 69 6e 5f 6d |ice [= s|ize_in_m|
|00002900| 65 67 61 62 79 74 65 73 | 5d 5d 20 2e 2e 2e 5d 02 |egabytes|]] ...].|
|00002910| 00 01 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |.......+|..<Press|
|00002920| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|00002930| 00 01 02 00 01 02 00 3b | 18 04 2d 20 49 66 20 79 |.......;|..- If y|
|00002940| 6f 75 20 64 6f 20 6e 6f | 74 20 73 70 65 63 69 66 |ou do no|t specif|
|00002950| 79 20 61 20 73 69 7a 65 | 2c 20 32 20 6d 65 67 61 |y a size|, 2 mega|
|00002960| 62 79 74 65 73 20 61 72 | 65 20 61 64 64 65 64 2e |bytes ar|e added.|
|00002970| 02 00 3c 18 04 2d 20 49 | 66 20 79 6f 75 20 64 6f |..<..- I|f you do|
|00002980| 20 6e 6f 74 20 73 70 65 | 63 69 66 79 20 61 20 64 | not spe|cify a d|
|00002990| 61 74 61 62 61 73 65 5f | 64 65 76 69 63 65 2c 20 |atabase_|device, |
|000029a0| 74 68 65 20 73 70 61 63 | 65 20 69 73 02 00 3b 18 |the spac|e is..;.|
|000029b0| 06 61 6c 6c 6f 63 61 74 | 65 64 20 66 72 6f 6d 20 |.allocat|ed from |
|000029c0| 74 68 65 20 70 6f 6f 6c | 20 6f 66 20 64 65 66 61 |the pool| of defa|
|000029d0| 75 6c 74 20 64 61 74 61 | 62 61 73 65 20 64 65 76 |ult data|base dev|
|000029e0| 69 63 65 73 2e 02 00 01 | 02 00 3f 33 2e 20 20 44 |ices....|..?3. D|
|000029f0| 75 6d 70 20 74 68 65 20 | 6d 61 73 74 65 72 20 64 |ump the |master d|
|00002a00| 61 74 61 62 61 73 65 20 | 75 73 69 6e 67 20 74 68 |atabase |using th|
|00002a10| 65 20 53 41 46 20 41 64 | 6d 69 6e 20 6d 65 6e 75 |e SAF Ad|min menu|
|00002a20| 2e 20 20 49 66 20 79 6f | 75 02 00 3f 18 04 61 72 |. If yo|u..?..ar|
|00002a30| 65 20 67 6f 69 6e 67 20 | 74 6f 20 6d 61 6b 65 20 |e going |to make |
|00002a40| 6d 6f 72 65 20 63 68 61 | 6e 67 65 73 20 74 6f 20 |more cha|nges to |
|00002a50| 74 68 65 20 6d 61 73 74 | 65 72 20 64 61 74 61 62 |the mast|er datab|
|00002a60| 61 73 65 2c 20 79 6f 75 | 02 00 43 18 04 63 61 6e |ase, you|..C..can|
|00002a70| 20 64 75 6d 70 20 74 68 | 65 20 6d 61 73 74 65 72 | dump th|e master|
|00002a80| 20 64 61 74 61 62 61 73 | 65 20 61 66 74 65 72 20 | databas|e after |
|00002a90| 61 6c 6c 20 63 68 61 6e | 67 65 73 20 68 61 76 65 |all chan|ges have|
|00002aa0| 20 62 65 65 6e 20 6d 61 | 64 65 2e 02 00 01 02 00 | been ma|de......|
|00002ab0| 34 45 78 61 6d 70 6c 65 | 3a 20 20 61 6c 74 65 72 |4Example|: alter|
|00002ac0| 20 64 61 74 61 62 61 73 | 65 20 70 72 6f 64 75 63 | databas|e produc|
|00002ad0| 74 73 20 6f 6e 20 70 72 | 6f 64 75 63 74 73 5f 64 |ts on pr|oducts_d|
|00002ae0| 62 64 65 76 02 00 1a 14 | 18 0a 3c 65 78 65 63 75 |bdev....|..<execu|
|00002af0| 74 65 3e 02 00 01 02 00 | 51 04 23 3a 6e 20 49 6e |te>.....|Q.#:n In|
|00002b00| 63 72 65 61 73 69 6e 67 | 20 54 72 61 6e 73 61 63 |creasing| Transac|
|00002b10| 74 69 6f 6e 20 4c 6f 67 | 20 53 69 7a 65 02 00 22 |tion Log| Size.."|
|00002b20| 54 6f 20 69 6e 63 72 65 | 61 73 65 20 74 72 61 6e |To incre|ase tran|
|00002b30| 73 61 63 74 69 6f 6e 20 | 6c 6f 67 20 73 69 7a 65 |saction |log size|
|00002b40| 3a 02 00 01 02 00 40 31 | 2e 20 20 28 4f 70 74 69 |:.....@1|. (Opti|
|00002b50| 6f 6e 61 6c 29 20 20 54 | 6f 20 66 69 6e 64 20 74 |onal) T|o find t|
|00002b60| 68 65 20 6c 6f 67 69 63 | 61 6c 20 6e 61 6d 65 20 |he logic|al name |
|00002b70| 6f 66 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |of the d|atabase |
|00002b80| 64 65 76 69 63 65 02 00 | 3f 18 04 6f 6e 20 77 68 |device..|?..on wh|
|00002b90| 69 63 68 20 74 68 65 20 | 74 72 61 6e 73 61 63 74 |ich the |transact|
|00002ba0| 69 6f 6e 20 6c 6f 67 20 | 69 73 20 73 74 6f 72 65 |ion log |is store|
|00002bb0| 64 2c 20 65 78 65 63 75 | 74 65 20 73 70 5f 68 65 |d, execu|te sp_he|
|00002bc0| 6c 70 64 62 2e 02 00 01 | 02 00 1c 32 2e 20 20 45 |lpdb....|...2. E|
|00002bd0| 78 65 63 75 74 65 20 41 | 4c 54 45 52 20 44 41 54 |xecute A|LTER DAT|
|00002be0| 41 42 41 53 45 3a 02 00 | 01 02 00 21 18 04 41 4c |ABASE:..|...!..AL|
|00002bf0| 54 45 52 20 44 41 54 41 | 42 41 53 45 20 64 61 74 |TER DATA|BASE dat|
|00002c00| 61 62 61 73 65 5f 6e 61 | 6d 65 02 00 3c 18 06 5b |abase_na|me..<..[|
|00002c10| 4f 4e 20 7b 44 45 46 41 | 55 4c 54 20 7c 20 64 61 |ON {DEFA|ULT | da|
|00002c20| 74 61 62 61 73 65 5f 64 | 65 76 69 63 65 7d 20 5b |tabase_d|evice} [|
|00002c30| 3d 20 73 69 7a 65 5f 69 | 6e 5f 6d 65 67 61 62 79 |= size_i|n_megaby|
|00002c40| 74 65 73 5d 02 00 35 18 | 06 5b 2c 20 64 61 74 61 |tes]..5.|.[, data|
|00002c50| 62 61 73 65 5f 64 65 76 | 69 63 65 20 5b 3d 20 73 |base_dev|ice [= s|
|00002c60| 69 7a 65 5f 69 6e 5f 6d | 65 67 61 62 79 74 65 73 |ize_in_m|egabytes|
|00002c70| 5d 5d 20 2e 2e 2e 5d 02 | 00 01 02 00 01 02 00 01 |]] ...].|........|
|00002c80| 02 00 2b 18 15 3c 50 72 | 65 73 73 20 50 67 44 6e |..+..<Pr|ess PgDn|
|00002c90| 20 66 6f 72 20 6d 6f 72 | 65 3e 02 00 01 02 00 3b | for mor|e>.....;|
|00002ca0| 18 04 2d 20 49 66 20 79 | 6f 75 20 64 6f 20 6e 6f |..- If y|ou do no|
|00002cb0| 74 20 73 70 65 63 69 66 | 79 20 61 20 73 69 7a 65 |t specif|y a size|
|00002cc0| 2c 20 32 20 6d 65 67 61 | 62 79 74 65 73 20 61 72 |, 2 mega|bytes ar|
|00002cd0| 65 20 61 64 64 65 64 2e | 02 00 3c 18 04 2d 20 49 |e added.|..<..- I|
|00002ce0| 66 20 79 6f 75 20 64 6f | 20 6e 6f 74 20 73 70 65 |f you do| not spe|
|00002cf0| 63 69 66 79 20 61 20 64 | 61 74 61 62 61 73 65 5f |cify a d|atabase_|
|00002d00| 64 65 76 69 63 65 2c 20 | 74 68 65 20 73 70 61 63 |device, |the spac|
|00002d10| 65 20 69 73 02 00 3b 18 | 06 61 6c 6c 6f 63 61 74 |e is..;.|.allocat|
|00002d20| 65 64 20 66 72 6f 6d 20 | 74 68 65 20 70 6f 6f 6c |ed from |the pool|
|00002d30| 20 6f 66 20 64 65 66 61 | 75 6c 74 20 64 61 74 61 | of defa|ult data|
|00002d40| 62 61 73 65 20 64 65 76 | 69 63 65 73 2e 02 00 01 |base dev|ices....|
|00002d50| 02 00 41 33 2e 20 20 45 | 78 65 63 75 74 65 20 73 |..A3. E|xecute s|
|00002d60| 70 5f 6c 6f 67 64 65 76 | 69 63 65 20 74 6f 20 6d |p_logdev|ice to m|
|00002d70| 61 6b 65 20 74 68 65 20 | 61 64 64 69 74 69 6f 6e |ake the |addition|
|00002d80| 61 6c 20 73 70 61 63 65 | 20 61 76 61 69 6c 61 62 |al space| availab|
|00002d90| 6c 65 3a 02 00 29 18 04 | 73 70 5f 6c 6f 67 64 65 |le:..)..|sp_logde|
|00002da0| 76 69 63 65 20 64 62 6e | 61 6d 65 2c 20 64 61 74 |vice dbn|ame, dat|
|00002db0| 61 62 61 73 65 5f 64 65 | 76 69 63 65 02 00 01 02 |abase_de|vice....|
|00002dc0| 00 3f 34 2e 20 20 44 75 | 6d 70 20 74 68 65 20 6d |.?4. Du|mp the m|
|00002dd0| 61 73 74 65 72 20 64 61 | 74 61 62 61 73 65 20 75 |aster da|tabase u|
|00002de0| 73 69 6e 67 20 74 68 65 | 20 53 41 46 20 41 64 6d |sing the| SAF Adm|
|00002df0| 69 6e 20 6d 65 6e 75 2e | 20 20 49 66 20 79 6f 75 |in menu.| If you|
|00002e00| 02 00 3f 18 04 61 72 65 | 20 67 6f 69 6e 67 20 74 |..?..are| going t|
|00002e10| 6f 20 6d 61 6b 65 20 6d | 6f 72 65 20 63 68 61 6e |o make m|ore chan|
|00002e20| 67 65 73 20 74 6f 20 74 | 68 65 20 6d 61 73 74 65 |ges to t|he maste|
|00002e30| 72 20 64 61 74 61 62 61 | 73 65 2c 20 79 6f 75 02 |r databa|se, you.|
|00002e40| 00 43 18 04 63 61 6e 20 | 64 75 6d 70 20 74 68 65 |.C..can |dump the|
|00002e50| 20 6d 61 73 74 65 72 20 | 64 61 74 61 62 61 73 65 | master |database|
|00002e60| 20 61 66 74 65 72 20 61 | 6c 6c 20 63 68 61 6e 67 | after a|ll chang|
|00002e70| 65 73 20 68 61 76 65 20 | 62 65 65 6e 20 6d 61 64 |es have |been mad|
|00002e80| 65 2e 02 00 01 02 00 36 | 45 78 61 6d 70 6c 65 3a |e......6|Example:|
|00002e90| 20 20 61 6c 74 65 72 20 | 64 61 74 61 62 61 73 65 | alter |database|
|00002ea0| 20 70 72 6f 64 75 63 74 | 73 20 6f 6e 20 70 72 6f | product|s on pro|
|00002eb0| 64 75 63 74 73 5f 6c 6f | 67 20 3d 20 33 02 00 1a |ducts_lo|g = 3...|
|00002ec0| 14 18 0a 3c 65 78 65 63 | 75 74 65 3e 02 00 2e 18 |...<exec|ute>....|
|00002ed0| 0a 73 70 5f 6c 6f 67 64 | 65 76 69 63 65 20 70 72 |.sp_logd|evice pr|
|00002ee0| 6f 64 75 63 74 73 2c 20 | 70 72 6f 64 75 63 74 73 |oducts, |products|
|00002ef0| 5f 6c 6f 67 02 00 1a 14 | 18 0a 3c 65 78 65 63 75 |_log....|..<execu|
|00002f00| 74 65 3e 02 00 01 02 00 | 78 04 21 3a 6e 20 43 68 |te>.....|x.!:n Ch|
|00002f10| 65 63 6b 69 6e 67 20 44 | 61 74 61 62 61 73 65 20 |ecking D|atabase |
|00002f20| 43 6f 6e 73 69 73 74 65 | 6e 63 79 02 00 3f 43 68 |Consiste|ncy..?Ch|
|00002f30| 65 63 6b 20 64 61 74 61 | 62 61 73 65 20 63 6f 6e |eck data|base con|
|00002f40| 73 69 73 74 65 6e 63 79 | 20 77 68 65 6e 20 61 6e |sistency| when an|
|00002f50| 20 65 72 72 6f 72 20 77 | 69 74 68 20 61 20 73 65 | error w|ith a se|
|00002f60| 76 65 72 69 74 79 20 6c | 65 76 65 6c 02 00 3e 6f |verity l|evel..>o|
|00002f70| 66 20 32 30 2d 32 33 20 | 6f 63 63 75 72 73 2c 20 |f 20-23 |occurs, |
|00002f80| 77 68 65 6e 20 79 6f 75 | 20 73 75 73 70 65 63 74 |when you| suspect|
|00002f90| 20 74 68 61 74 20 61 20 | 64 61 74 61 62 61 73 65 | that a |database|
|00002fa0| 20 69 73 20 64 61 6d 61 | 67 65 64 2c 02 00 36 6f | is dama|ged,..6o|
|00002fb0| 72 20 61 73 20 70 61 72 | 74 20 6f 66 20 61 20 70 |r as par|t of a p|
|00002fc0| 65 72 69 6f 64 69 63 20 | 63 6f 6e 73 69 73 74 65 |eriodic |consiste|
|00002fd0| 6e 63 79 20 63 68 65 63 | 6b 2e 20 20 54 6f 20 63 |ncy chec|k. To c|
|00002fe0| 68 65 63 6b 02 00 33 64 | 61 74 61 62 61 73 65 20 |heck..3d|atabase |
|00002ff0| 63 6f 6e 73 69 73 74 65 | 6e 63 79 2c 20 20 65 78 |consiste|ncy, ex|
|00003000| 65 63 75 74 65 20 74 68 | 65 20 44 42 43 43 20 73 |ecute th|e DBCC s|
|00003010| 74 61 74 65 6d 65 6e 74 | 3a 02 00 01 02 00 25 18 |tatement|:.....%.|
|00003020| 05 44 42 43 43 20 7b 43 | 48 45 43 4b 54 41 42 4c |.DBCC {C|HECKTABL|
|00003030| 45 20 28 74 61 62 6c 65 | 5f 6e 61 6d 65 29 20 7c |E (table|_name) ||
|00003040| 02 00 23 18 07 43 48 45 | 43 4b 44 42 20 5b 28 64 |..#..CHE|CKDB [(d|
|00003050| 61 74 61 62 61 73 65 5f | 6e 61 6d 65 29 5d 20 7c |atabase_|name)] ||
|00003060| 02 00 26 18 07 43 48 45 | 43 4b 41 4c 4c 4f 43 20 |..&..CHE|CKALLOC |
|00003070| 5b 28 64 61 74 61 62 61 | 73 65 5f 6e 61 6d 65 29 |[(databa|se_name)|
|00003080| 5d 20 7c 02 00 28 18 07 | 43 48 45 43 4b 43 41 54 |] |..(..|CHECKCAT|
|00003090| 41 4c 4f 47 20 5b 28 64 | 61 74 61 62 61 73 65 5f |ALOG [(d|atabase_|
|000030a0| 6e 61 6d 65 29 5d 20 7c | 02 00 2a 18 07 44 42 52 |name)] ||..*..DBR|
|000030b0| 45 50 41 49 52 20 28 64 | 61 74 61 62 61 73 65 5f |EPAIR (d|atabase_|
|000030c0| 6e 61 6d 65 2c 20 44 52 | 4f 50 44 42 29 20 7d 02 |name, DR|OPDB) }.|
|000030d0| 00 01 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |.......+|..<Press|
|000030e0| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|000030f0| 00 01 02 00 01 02 00 40 | 18 07 2d 20 44 42 52 45 |.......@|..- DBRE|
|00003100| 50 41 49 52 20 64 72 6f | 70 73 20 61 20 64 61 6d |PAIR dro|ps a dam|
|00003110| 61 67 65 64 20 64 61 74 | 61 62 61 73 65 20 61 6e |aged dat|abase an|
|00003120| 64 20 69 73 20 65 78 65 | 63 75 74 65 64 20 66 72 |d is exe|cuted fr|
|00003130| 6f 6d 02 00 3b 18 09 22 | 6d 61 73 74 65 72 2e 22 |om..;.."|master."|
|00003140| 20 20 4d 61 6b 65 20 73 | 75 72 65 20 6e 6f 20 6f | Make s|ure no o|
|00003150| 6e 65 20 69 73 20 75 73 | 69 6e 67 20 74 68 65 20 |ne is us|ing the |
|00003160| 64 61 74 61 62 61 73 65 | 02 00 24 18 09 77 68 65 |database|..$..whe|
|00003170| 6e 20 79 6f 75 20 65 78 | 65 63 75 74 65 20 44 42 |n you ex|ecute DB|
|00003180| 52 45 50 41 49 52 2e 02 | 00 01 02 00 3d 4e 6f 74 |REPAIR..|....=Not|
|00003190| 65 3a 20 20 44 42 43 43 | 20 6d 61 79 20 72 65 63 |e: DBCC| may rec|
|000031a0| 6f 6d 6d 65 6e 64 20 6d | 61 6b 69 6e 67 20 63 68 |ommend m|aking ch|
|000031b0| 61 6e 67 65 73 20 74 6f | 20 73 79 73 74 65 6d 20 |anges to| system |
|000031c0| 74 61 62 6c 65 73 20 74 | 6f 02 00 3a 72 65 73 74 |tables t|o..:rest|
|000031d0| 6f 72 65 20 63 6f 6e 73 | 69 73 74 65 6e 63 79 2e |ore cons|istency.|
|000031e0| 20 20 54 6f 20 6d 61 6b | 65 20 74 68 65 73 65 20 | To mak|e these |
|000031f0| 63 68 61 6e 67 65 73 2c | 20 79 6f 75 20 6d 75 73 |changes,| you mus|
|00003200| 74 20 72 75 6e 02 00 3c | 53 51 4c 20 53 65 72 76 |t run..<|SQL Serv|
|00003210| 65 72 20 69 6e 20 73 69 | 6e 67 6c 65 2d 75 73 65 |er in si|ngle-use|
|00003220| 72 20 6d 6f 64 65 20 6f | 72 20 73 65 74 20 74 68 |r mode o|r set th|
|00003230| 65 20 22 41 6c 6c 6f 77 | 20 55 70 64 61 74 65 73 |e "Allow| Updates|
|00003240| 20 74 6f 02 00 42 53 79 | 73 74 65 6d 20 54 61 62 | to..BSy|stem Tab|
|00003250| 6c 65 73 22 20 63 6f 6e | 66 69 67 75 72 61 74 69 |les" con|figurati|
|00003260| 6f 6e 20 6f 70 74 69 6f | 6e 2e 20 20 28 53 65 65 |on optio|n. (See|
|00003270| 20 74 68 65 20 22 53 51 | 4c 20 53 65 72 76 65 72 | the "SQ|L Server|
|00003280| 20 53 79 73 74 65 6d 02 | 00 1a 19 41 64 6d 69 6e | System.|...Admin|
|00003290| 69 73 74 72 61 74 6f 72 | 27 73 20 47 75 69 64 65 |istrator|'s Guide|
|000032a0| 2e 22 29 02 00 01 02 00 | 3e 55 6e 6c 65 73 73 20 |.").....|>Unless |
|000032b0| 79 6f 75 20 61 72 65 20 | 76 65 72 79 20 66 61 6d |you are |very fam|
|000032c0| 69 6c 69 61 72 20 77 69 | 74 68 20 74 68 65 20 73 |iliar wi|th the s|
|000032d0| 74 72 75 63 74 75 72 65 | 20 6f 66 20 74 68 65 20 |tructure| of the |
|000032e0| 73 79 73 74 65 6d 02 00 | 3a 74 61 62 6c 65 73 2c |system..|:tables,|
|000032f0| 20 63 6f 6e 74 61 63 74 | 20 79 6f 75 72 20 73 75 | contact| your su|
|00003300| 70 70 6f 72 74 20 72 65 | 70 72 65 73 65 6e 74 61 |pport re|presenta|
|00003310| 74 69 76 65 20 62 65 66 | 6f 72 65 20 6d 61 6b 69 |tive bef|ore maki|
|00003320| 6e 67 02 00 1d 63 68 61 | 6e 67 65 73 20 72 65 63 |ng...cha|nges rec|
|00003330| 6f 6d 6d 65 6e 64 65 64 | 20 62 79 20 44 42 43 43 |ommended| by DBCC|
|00003340| 2e 02 00 01 02 00 13 0a | 2b 3a 6e 20 43 72 65 61 |........|+:n Crea|
|00003350| 74 69 6e 67 20 61 20 44 | 61 74 61 62 61 73 65 20 |ting a D|atabase |
|00003360| 61 6e 64 20 54 72 61 6e | 73 61 63 74 69 6f 6e 20 |and Tran|saction |
|00003370| 4c 6f 67 02 00 3c 46 6f | 72 20 64 61 74 61 62 61 |Log..<Fo|r databa|
|00003380| 73 65 73 20 6c 61 72 67 | 65 72 20 74 68 61 6e 20 |ses larg|er than |
|00003390| 34 20 6d 65 67 61 62 79 | 74 65 73 2c 20 79 6f 75 |4 megaby|tes, you|
|000033a0| 20 73 68 6f 75 6c 64 20 | 73 74 6f 72 65 20 74 68 | should |store th|
|000033b0| 65 02 00 37 64 61 74 61 | 62 61 73 65 20 61 6e 64 |e..7data|base and|
|000033c0| 20 69 74 73 20 74 72 61 | 6e 73 61 63 74 69 6f 6e | its tra|nsaction|
|000033d0| 20 6c 6f 67 20 6f 6e 20 | 64 69 66 66 65 72 65 6e | log on |differen|
|000033e0| 74 20 64 61 74 61 62 61 | 73 65 02 00 36 64 65 76 |t databa|se..6dev|
|000033f0| 69 63 65 73 2e 20 20 54 | 6f 20 63 72 65 61 74 65 |ices. T|o create|
|00003400| 20 61 20 64 61 74 61 62 | 61 73 65 20 61 6e 64 20 | a datab|ase and |
|00003410| 61 20 74 72 61 6e 73 61 | 63 74 69 6f 6e 20 6c 6f |a transa|ction lo|
|00003420| 67 3a 02 00 01 02 00 3b | 31 2e 20 20 28 4f 70 74 |g:.....;|1. (Opt|
|00003430| 69 6f 6e 61 6c 29 20 20 | 54 6f 20 73 65 65 20 61 |ional) |To see a|
|00003440| 76 61 69 6c 61 62 6c 65 | 20 64 61 74 61 62 61 73 |vailable| databas|
|00003450| 65 20 64 65 76 69 63 65 | 73 2c 20 65 78 65 63 75 |e device|s, execu|
|00003460| 74 65 02 00 3c 18 04 73 | 70 5f 68 65 6c 70 64 65 |te..<..s|p_helpde|
|00003470| 76 69 63 65 2e 20 20 54 | 6f 20 73 65 65 20 68 6f |vice. T|o see ho|
|00003480| 77 20 6d 75 63 68 20 73 | 70 61 63 65 20 69 73 20 |w much s|pace is |
|00003490| 61 76 61 69 6c 61 62 6c | 65 20 6f 6e 20 61 02 00 |availabl|e on a..|
|000034a0| 38 18 04 67 69 76 65 6e | 20 64 61 74 61 62 61 73 |8..given| databas|
|000034b0| 65 20 64 65 76 69 63 65 | 2c 20 75 73 65 20 74 68 |e device|, use th|
|000034c0| 65 20 72 65 70 6f 72 74 | 20 6f 62 74 61 69 6e 65 |e report| obtaine|
|000034d0| 64 20 66 72 6f 6d 02 00 | 38 18 04 73 70 5f 68 65 |d from..|8..sp_he|
|000034e0| 6c 70 64 65 76 69 63 65 | 20 61 6e 64 20 73 75 62 |lpdevice| and sub|
|000034f0| 74 72 61 63 74 20 74 68 | 65 20 22 6c 6f 77 22 20 |tract th|e "low" |
|00003500| 76 61 6c 75 65 20 66 72 | 6f 6d 20 74 68 65 02 00 |value fr|om the..|
|00003510| 1a 12 18 04 22 68 69 67 | 68 22 20 76 61 6c 75 65 |...."hig|h" value|
|00003520| 2e 02 00 01 02 00 3e 32 | 2e 20 20 28 4f 70 74 69 |......>2|. (Opti|
|00003530| 6f 6e 61 6c 29 20 20 49 | 66 20 6e 6f 20 64 61 74 |onal) I|f no dat|
|00003540| 61 62 61 73 65 20 64 65 | 76 69 63 65 73 20 61 72 |abase de|vices ar|
|00003550| 65 20 61 76 61 69 6c 61 | 62 6c 65 2c 20 65 78 65 |e availa|ble, exe|
|00003560| 63 75 74 65 02 00 41 18 | 04 44 49 53 4b 20 49 4e |cute..A.|.DISK IN|
|00003570| 49 54 20 74 6f 20 63 72 | 65 61 74 65 20 6f 6e 65 |IT to cr|eate one|
|00003580| 20 64 61 74 61 62 61 73 | 65 20 64 65 76 69 63 65 | databas|e device|
|00003590| 20 66 6f 72 20 74 68 65 | 20 64 61 74 61 62 61 73 | for the| databas|
|000035a0| 65 20 61 6e 64 02 00 31 | 18 04 6f 6e 65 20 64 61 |e and..1|..one da|
|000035b0| 74 61 62 61 73 65 20 64 | 65 76 69 63 65 20 66 6f |tabase d|evice fo|
|000035c0| 72 20 74 68 65 20 74 72 | 61 6e 73 61 63 74 69 6f |r the tr|ansactio|
|000035d0| 6e 20 6c 6f 67 3a 02 00 | 01 02 00 2b 18 15 3c 50 |n log:..|...+..<P|
|000035e0| 72 65 73 73 20 50 67 44 | 6e 20 66 6f 72 20 6d 6f |ress PgD|n for mo|
|000035f0| 72 65 3e 02 00 01 02 00 | 41 18 04 44 49 53 4b 20 |re>.....|A..DISK |
|00003600| 49 4e 49 54 20 4e 41 4d | 45 20 3d 20 22 6c 6f 67 |INIT NAM|E = "log|
|00003610| 69 63 61 6c 5f 6e 61 6d | 65 22 2c 20 50 48 59 53 |ical_nam|e", PHYS|
|00003620| 4e 41 4d 45 20 3d 20 22 | 70 68 79 73 69 63 61 6c |NAME = "|physical|
|00003630| 5f 6e 61 6d 65 22 2c 02 | 00 41 18 06 56 44 45 56 |_name",.|.A..VDEV|
|00003640| 4e 4f 20 3d 20 76 69 72 | 74 75 61 6c 5f 64 65 76 |NO = vir|tual_dev|
|00003650| 69 63 65 5f 6e 75 6d 62 | 65 72 2c 20 53 49 5a 45 |ice_numb|er, SIZE|
|00003660| 20 3d 20 6e 75 6d 62 65 | 72 5f 6f 66 5f 32 4b 5f | = numbe|r_of_2K_|
|00003670| 62 6c 6f 63 6b 73 02 00 | 01 02 00 36 18 06 2d 20 |blocks..|...6..- |
|00003680| 56 44 45 56 4e 4f 20 69 | 73 20 61 20 76 69 72 74 |VDEVNO i|s a virt|
|00003690| 75 61 6c 20 64 65 76 69 | 63 65 20 6e 75 6d 62 65 |ual devi|ce numbe|
|000036a0| 72 20 6e 6f 74 20 69 6e | 20 75 73 65 2e 02 00 3e |r not in| use...>|
|000036b0| 18 06 2d 20 53 49 5a 45 | 20 69 73 20 74 68 65 20 |..- SIZE| is the |
|000036c0| 6e 75 6d 62 65 72 20 6f | 66 20 32 2d 6b 69 6c 6f |number o|f 2-kilo|
|000036d0| 62 79 74 65 20 62 6c 6f | 63 6b 73 3b 20 66 6f 72 |byte blo|cks; for|
|000036e0| 20 65 78 61 6d 70 6c 65 | 2c 02 00 29 18 08 61 20 | example|,..)..a |
|000036f0| 53 49 5a 45 20 6f 66 20 | 35 31 32 20 65 71 75 61 |SIZE of |512 equa|
|00003700| 6c 73 20 31 20 6d 65 67 | 61 62 79 74 65 2e 02 00 |ls 1 meg|abyte...|
|00003710| 01 02 00 1d 33 2e 20 20 | 45 78 65 63 75 74 65 20 |....3. |Execute |
|00003720| 43 52 45 41 54 45 20 44 | 41 54 41 42 41 53 45 3a |CREATE D|ATABASE:|
|00003730| 02 00 01 02 00 22 18 04 | 43 52 45 41 54 45 20 44 |....."..|CREATE D|
|00003740| 41 54 41 42 41 53 45 20 | 64 61 74 61 62 61 73 65 |ATABASE |database|
|00003750| 5f 6e 61 6d 65 02 00 3c | 18 06 5b 4f 4e 20 7b 44 |_name..<|..[ON {D|
|00003760| 45 46 41 55 4c 54 20 7c | 20 64 61 74 61 62 61 73 |EFAULT || databas|
|00003770| 65 5f 64 65 76 69 63 65 | 7d 20 5b 3d 20 73 69 7a |e_device|} [= siz|
|00003780| 65 5f 69 6e 5f 6d 65 67 | 61 62 79 74 65 73 5d 02 |e_in_meg|abytes].|
|00003790| 00 35 18 06 5b 2c 20 64 | 61 74 61 62 61 73 65 5f |.5..[, d|atabase_|
|000037a0| 64 65 76 69 63 65 20 5b | 3d 20 73 69 7a 65 5f 69 |device [|= size_i|
|000037b0| 6e 5f 6d 65 67 61 62 79 | 74 65 73 5d 5d 20 2e 2e |n_megaby|tes]] ..|
|000037c0| 2e 5d 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |.].....+|..<Press|
|000037d0| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|000037e0| 00 01 02 00 33 18 06 5b | 4c 4f 47 20 4f 4e 20 64 |....3..[|LOG ON d|
|000037f0| 61 74 61 62 61 73 65 5f | 64 65 76 69 63 65 20 5b |atabase_|device [|
|00003800| 3d 73 69 7a 65 5f 69 6e | 5f 6d 65 67 61 62 79 74 |=size_in|_megabyt|
|00003810| 65 73 5d 02 00 34 18 06 | 5b 2c 20 64 61 74 61 62 |es]..4..|[, datab|
|00003820| 61 73 65 5f 64 65 76 69 | 63 65 20 5b 3d 20 73 69 |ase_devi|ce [= si|
|00003830| 7a 65 5f 69 6e 5f 6d 65 | 67 61 62 79 74 65 73 5d |ze_in_me|gabytes]|
|00003840| 5d 2e 2e 2e 5d 02 00 01 | 02 00 42 18 06 2d 20 53 |]...]...|..B..- S|
|00003850| 70 65 63 69 66 79 20 61 | 74 20 6c 65 61 73 74 20 |pecify a|t least |
|00003860| 74 77 6f 20 65 78 69 73 | 74 69 6e 67 20 64 61 74 |two exis|ting dat|
|00003870| 61 62 61 73 65 20 64 65 | 76 69 63 65 73 3a 20 74 |abase de|vices: t|
|00003880| 68 65 20 66 69 72 73 74 | 02 00 41 18 08 66 6f 72 |he first|..A..for|
|00003890| 20 74 68 65 20 64 61 74 | 61 62 61 73 65 20 61 6e | the dat|abase an|
|000038a0| 64 20 74 68 65 20 73 65 | 63 6f 6e 64 20 66 6f 72 |d the se|cond for|
|000038b0| 20 74 68 65 20 74 72 61 | 6e 73 61 63 74 69 6f 6e | the tra|nsaction|
|000038c0| 20 6c 6f 67 2e 02 00 3a | 18 06 2d 20 49 66 20 79 | log...:|..- If y|
|000038d0| 6f 75 20 73 70 65 63 69 | 66 79 20 44 45 46 41 55 |ou speci|fy DEFAU|
|000038e0| 4c 54 2c 20 74 68 65 20 | 64 61 74 61 62 61 73 65 |LT, the |database|
|000038f0| 20 69 73 20 70 6c 61 63 | 65 64 20 6f 6e 02 00 3a | is plac|ed on..:|
|00003900| 18 08 61 20 64 61 74 61 | 62 61 73 65 20 64 65 76 |..a data|base dev|
|00003910| 69 63 65 20 69 6e 20 74 | 68 65 20 64 65 66 61 75 |ice in t|he defau|
|00003920| 6c 74 20 70 6f 6f 6c 20 | 6f 66 20 64 65 76 69 63 |lt pool |of devic|
|00003930| 65 73 2e 02 00 01 02 00 | 3b 34 2e 20 20 45 78 65 |es......|;4. Exe|
|00003940| 63 75 74 65 20 73 70 5f | 6c 6f 67 64 65 76 69 63 |cute sp_|logdevic|
|00003950| 65 20 74 6f 20 70 75 74 | 20 74 68 65 20 74 72 61 |e to put| the tra|
|00003960| 6e 73 61 63 74 69 6f 6e | 20 6c 6f 67 20 6f 6e 20 |nsaction| log on |
|00003970| 74 68 65 02 00 26 18 04 | 73 70 65 63 69 66 69 65 |the..&..|specifie|
|00003980| 64 20 73 65 63 6f 6e 64 | 20 64 61 74 61 62 61 73 |d second| databas|
|00003990| 65 20 64 65 76 69 63 65 | 3a 02 00 01 02 00 29 18 |e device|:.....).|
|000039a0| 04 73 70 5f 6c 6f 67 64 | 65 76 69 63 65 20 64 62 |.sp_logd|evice db|
|000039b0| 6e 61 6d 65 2c 20 64 61 | 74 61 62 61 73 65 5f 64 |name, da|tabase_d|
|000039c0| 65 76 69 63 65 02 00 01 | 02 00 2b 18 15 3c 50 72 |evice...|..+..<Pr|
|000039d0| 65 73 73 20 50 67 44 6e | 20 66 6f 72 20 6d 6f 72 |ess PgDn| for mor|
|000039e0| 65 3e 02 00 01 02 00 3f | 35 2e 20 20 44 75 6d 70 |e>.....?|5. Dump|
|000039f0| 20 74 68 65 20 6d 61 73 | 74 65 72 20 64 61 74 61 | the mas|ter data|
|00003a00| 62 61 73 65 20 75 73 69 | 6e 67 20 74 68 65 20 53 |base usi|ng the S|
|00003a10| 41 46 20 41 64 6d 69 6e | 20 6d 65 6e 75 2e 20 20 |AF Admin| menu. |
|00003a20| 49 66 20 79 6f 75 02 00 | 3f 18 04 61 72 65 20 67 |If you..|?..are g|
|00003a30| 6f 69 6e 67 20 74 6f 20 | 6d 61 6b 65 20 6d 6f 72 |oing to |make mor|
|00003a40| 65 20 63 68 61 6e 67 65 | 73 20 74 6f 20 74 68 65 |e change|s to the|
|00003a50| 20 6d 61 73 74 65 72 20 | 64 61 74 61 62 61 73 65 | master |database|
|00003a60| 2c 20 79 6f 75 02 00 43 | 18 04 63 61 6e 20 64 75 |, you..C|..can du|
|00003a70| 6d 70 20 74 68 65 20 6d | 61 73 74 65 72 20 64 61 |mp the m|aster da|
|00003a80| 74 61 62 61 73 65 20 61 | 66 74 65 72 20 61 6c 6c |tabase a|fter all|
|00003a90| 20 63 68 61 6e 67 65 73 | 20 68 61 76 65 20 62 65 | changes| have be|
|00003aa0| 65 6e 20 6d 61 64 65 2e | 02 00 01 02 00 2e 45 78 |en made.|......Ex|
|00003ab0| 61 6d 70 6c 65 3a 20 20 | 64 69 73 6b 20 69 6e 69 |ample: |disk ini|
|00003ac0| 74 20 20 6e 61 6d 65 20 | 3d 20 22 70 72 6f 64 75 |t name |= "produ|
|00003ad0| 63 74 73 5f 64 62 64 65 | 76 22 2c 02 00 32 18 0c |cts_dbde|v",..2..|
|00003ae0| 70 68 79 73 6e 61 6d 65 | 20 3d 20 20 22 63 3a 5c |physname| = "c:\|
|00003af0| 73 71 6c 5c 64 61 74 61 | 5c 70 72 6f 64 64 62 2e |sql\data|\proddb.|
|00003b00| 64 61 74 22 2c 02 00 24 | 18 0c 76 64 65 76 6e 6f |dat",..$|..vdevno|
|00003b10| 20 3d 20 35 2c 20 73 69 | 7a 65 20 3d 20 31 30 32 | = 5, si|ze = 102|
|00003b20| 34 02 00 1a 14 18 0a 3c | 65 78 65 63 75 74 65 3e |4......<|execute>|
|00003b30| 02 00 2b 18 0a 64 69 73 | 6b 20 69 6e 69 74 20 6e |..+..dis|k init n|
|00003b40| 61 6d 65 20 3d 20 22 70 | 72 6f 64 75 63 74 73 5f |ame = "p|roducts_|
|00003b50| 6c 6f 67 22 2c 02 00 31 | 18 0c 70 68 79 73 6e 61 |log",..1|..physna|
|00003b60| 6d 65 20 3d 20 22 63 3a | 5c 73 71 6c 5c 6c 6f 67 |me = "c:|\sql\log|
|00003b70| 5c 70 72 6f 64 6c 6f 67 | 2e 64 61 74 22 2c 02 00 |\prodlog|.dat",..|
|00003b80| 23 18 0c 76 64 65 76 6e | 6f 20 3d 20 36 2c 20 73 |#..vdevn|o = 6, s|
|00003b90| 69 7a 65 20 3d 20 35 31 | 32 02 00 1a 14 18 0a 3c |ize = 51|2......<|
|00003ba0| 65 78 65 63 75 74 65 3e | 02 00 01 02 00 2b 18 15 |execute>|.....+..|
|00003bb0| 3c 50 72 65 73 73 20 50 | 67 44 6e 20 66 6f 72 20 |<Press P|gDn for |
|00003bc0| 6d 6f 72 65 3e 02 00 01 | 02 00 3a 18 0a 63 72 65 |more>...|..:..cre|
|00003bd0| 61 74 65 20 64 61 74 61 | 62 61 73 65 20 70 72 6f |ate data|base pro|
|00003be0| 64 75 63 74 73 20 6f 6e | 20 70 72 6f 64 75 63 74 |ducts on| product|
|00003bf0| 73 5f 64 62 64 65 76 20 | 3d 20 32 2c 02 00 1d 18 |s_dbdev |= 2,....|
|00003c00| 0c 70 72 6f 64 75 63 74 | 73 5f 6c 6f 67 20 3d 20 |.product|s_log = |
|00003c10| 31 02 00 1a 14 18 0a 3c | 65 78 65 63 75 74 65 3e |1......<|execute>|
|00003c20| 02 00 2e 18 0a 73 70 5f | 6c 6f 67 64 65 76 69 63 |.....sp_|logdevic|
|00003c30| 65 20 70 72 6f 64 75 63 | 74 73 2c 20 70 72 6f 64 |e produc|ts, prod|
|00003c40| 75 63 74 73 5f 6c 6f 67 | 02 00 1a 14 18 0a 3c 65 |ucts_log|......<e|
|00003c50| 78 65 63 75 74 65 3e 02 | 00 01 02 00 8f 01 1a 17 |xecute>.|........|
|00003c60| 3a 6e 20 44 72 6f 70 70 | 69 6e 67 20 61 20 44 61 |:n Dropp|ing a Da|
|00003c70| 74 61 62 61 73 65 02 00 | 1a 14 54 6f 20 64 72 6f |tabase..|..To dro|
|00003c80| 70 20 61 20 64 61 74 61 | 62 61 73 65 3a 02 00 01 |p a data|base:...|
|00003c90| 02 00 1b 31 2e 20 20 45 | 78 65 63 75 74 65 20 44 |...1. E|xecute D|
|00003ca0| 52 4f 50 20 44 41 54 41 | 42 41 53 45 3a 02 00 35 |ROP DATA|BASE:..5|
|00003cb0| 18 04 44 52 4f 50 20 44 | 41 54 41 42 41 53 45 20 |..DROP D|ATABASE |
|00003cc0| 64 61 74 61 62 61 73 65 | 5f 6e 61 6d 65 20 5b 2c |database|_name [,|
|00003cd0| 20 64 61 74 61 62 61 73 | 65 5f 6e 61 6d 65 2e 2e | databas|e_name..|
|00003ce0| 2e 5d 02 00 01 02 00 3f | 32 2e 20 20 44 75 6d 70 |.].....?|2. Dump|
|00003cf0| 20 74 68 65 20 6d 61 73 | 74 65 72 20 64 61 74 61 | the mas|ter data|
|00003d00| 62 61 73 65 20 75 73 69 | 6e 67 20 74 68 65 20 53 |base usi|ng the S|
|00003d10| 41 46 20 41 64 6d 69 6e | 20 6d 65 6e 75 2e 20 20 |AF Admin| menu. |
|00003d20| 49 66 20 79 6f 75 02 00 | 3f 18 04 61 72 65 20 67 |If you..|?..are g|
|00003d30| 6f 69 6e 67 20 74 6f 20 | 6d 61 6b 65 20 6d 6f 72 |oing to |make mor|
|00003d40| 65 20 63 68 61 6e 67 65 | 73 20 74 6f 20 74 68 65 |e change|s to the|
|00003d50| 20 6d 61 73 74 65 72 20 | 64 61 74 61 62 61 73 65 | master |database|
|00003d60| 2c 20 79 6f 75 02 00 43 | 18 04 63 61 6e 20 64 75 |, you..C|..can du|
|00003d70| 6d 70 20 74 68 65 20 6d | 61 73 74 65 72 20 64 61 |mp the m|aster da|
|00003d80| 74 61 62 61 73 65 20 61 | 66 74 65 72 20 61 6c 6c |tabase a|fter all|
|00003d90| 20 63 68 61 6e 67 65 73 | 20 68 61 76 65 20 62 65 | changes| have be|
|00003da0| 65 6e 20 6d 61 64 65 2e | 02 00 01 02 00 21 45 78 |en made.|.....!Ex|
|00003db0| 61 6d 70 6c 65 3a 20 20 | 64 72 6f 70 20 64 61 74 |ample: |drop dat|
|00003dc0| 61 62 61 73 65 20 70 72 | 6f 64 75 63 74 73 02 00 |abase pr|oducts..|
|00003dd0| 1a 14 18 0a 3c 65 78 65 | 63 75 74 65 3e 02 00 01 |....<exe|cute>...|
|00003de0| 02 00 8a 05 1a 18 3a 6e | 20 47 72 61 6e 74 69 6e |......:n| Grantin|
|00003df0| 67 20 50 65 72 6d 69 73 | 73 69 6f 6e 73 02 00 1a |g Permis|sions...|
|00003e00| 16 53 74 61 74 65 6d 65 | 6e 74 20 50 65 72 6d 69 |.Stateme|nt Permi|
|00003e10| 73 73 69 6f 6e 73 02 00 | 01 02 00 3a 54 6f 20 67 |ssions..|...:To g|
|00003e20| 72 61 6e 74 20 70 65 72 | 6d 69 73 73 69 6f 6e 73 |rant per|missions|
|00003e30| 20 74 6f 20 75 73 65 20 | 53 51 4c 20 73 74 61 74 | to use |SQL stat|
|00003e40| 65 6d 65 6e 74 73 2c 20 | 65 78 65 63 75 74 65 20 |ements, |execute |
|00003e50| 47 52 41 4e 54 02 00 1a | 12 77 69 74 68 20 74 68 |GRANT...|.with th|
|00003e60| 69 73 20 73 79 6e 74 61 | 78 3a 02 00 01 02 00 39 |is synta|x:.....9|
|00003e70| 18 04 47 52 41 4e 54 20 | 7b 41 4c 4c 20 7c 20 73 |..GRANT |{ALL | s|
|00003e80| 74 61 74 65 6d 65 6e 74 | 5f 6c 69 73 74 7d 20 54 |tatement|_list} T|
|00003e90| 4f 20 7b 50 55 42 4c 49 | 43 20 7c 20 6e 61 6d 65 |O {PUBLI|C | name|
|00003ea0| 5f 6c 69 73 74 7d 02 00 | 01 02 00 39 18 04 2d 20 |_list}..|...9..- |
|00003eb0| 73 74 61 74 65 6d 65 6e | 74 5f 6c 69 73 74 20 63 |statemen|t_list c|
|00003ec0| 61 6e 20 69 6e 63 6c 75 | 64 65 20 43 52 45 41 54 |an inclu|de CREAT|
|00003ed0| 45 20 44 41 54 41 42 41 | 53 45 2c 20 43 52 45 41 |E DATABA|SE, CREA|
|00003ee0| 54 45 02 00 3c 18 06 44 | 45 46 41 55 4c 54 2c 20 |TE..<..D|EFAULT, |
|00003ef0| 43 52 45 41 54 45 20 50 | 52 4f 43 45 44 55 52 45 |CREATE P|ROCEDURE|
|00003f00| 2c 20 43 52 45 41 54 45 | 20 52 55 4c 45 2c 20 43 |, CREATE| RULE, C|
|00003f10| 52 45 41 54 45 20 54 41 | 42 4c 45 2c 02 00 38 18 |REATE TA|BLE,..8.|
|00003f20| 06 43 52 45 41 54 45 20 | 56 49 45 57 2c 20 44 55 |.CREATE |VIEW, DU|
|00003f30| 4d 50 20 44 41 54 41 42 | 41 53 45 2c 20 61 6e 64 |MP DATAB|ASE, and|
|00003f40| 20 44 55 4d 50 20 54 52 | 41 4e 53 41 43 54 49 4f | DUMP TR|ANSACTIO|
|00003f50| 4e 2e 02 00 37 18 04 2d | 20 6e 61 6d 65 5f 6c 69 |N...7..-| name_li|
|00003f60| 73 74 20 69 6e 63 6c 75 | 64 65 73 20 75 73 65 72 |st inclu|des user|
|00003f70| 6e 61 6d 65 73 20 61 6e | 64 20 67 72 6f 75 70 6e |names an|d groupn|
|00003f80| 61 6d 65 73 20 69 6e 20 | 61 02 00 1b 18 06 70 61 |ames in |a.....pa|
|00003f90| 72 74 69 63 75 6c 61 72 | 20 64 61 74 61 62 61 73 |rticular| databas|
|00003fa0| 65 2e 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |e......+|..<Press|
|00003fb0| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|00003fc0| 00 01 02 00 41 45 78 61 | 6d 70 6c 65 3a 20 20 67 |....AExa|mple: g|
|00003fd0| 72 61 6e 74 20 63 72 65 | 61 74 65 20 64 61 74 61 |rant cre|ate data|
|00003fe0| 62 61 73 65 20 74 6f 20 | 62 6f 62 2c 20 64 69 63 |base to |bob, dic|
|00003ff0| 6b 2c 20 76 69 63 6b 69 | 2c 20 65 6e 67 69 6e 65 |k, vicki|, engine|
|00004000| 65 72 69 6e 67 02 00 1a | 14 18 0a 3c 65 78 65 63 |ering...|...<exec|
|00004010| 75 74 65 3e 02 00 01 02 | 00 1a 13 4f 62 6a 65 63 |ute>....|...Objec|
|00004020| 74 20 50 65 72 6d 69 73 | 73 69 6f 6e 73 02 00 01 |t Permis|sions...|
|00004030| 02 00 2e 54 6f 20 67 72 | 61 6e 74 20 70 65 72 6d |...To gr|ant perm|
|00004040| 69 73 73 69 6f 6e 73 20 | 74 6f 20 75 73 65 20 64 |issions |to use d|
|00004050| 61 74 61 62 61 73 65 20 | 6f 62 6a 65 63 74 73 3a |atabase |objects:|
|00004060| 02 00 01 02 00 39 31 2e | 20 20 45 6e 74 65 72 20 |.....91.| Enter |
|00004070| 74 68 65 20 64 61 74 61 | 62 61 73 65 20 69 6e 20 |the data|base in |
|00004080| 77 68 69 63 68 20 79 6f | 75 20 77 61 6e 74 20 74 |which yo|u want t|
|00004090| 6f 20 67 72 61 6e 74 20 | 6f 62 6a 65 63 74 02 00 |o grant |object..|
|000040a0| 1a 11 18 04 70 65 72 6d | 69 73 73 69 6f 6e 73 2e |....perm|issions.|
|000040b0| 02 00 01 02 00 3a 32 2e | 20 20 47 72 61 6e 74 20 |.....:2.| Grant |
|000040c0| 6f 62 6a 65 63 74 20 70 | 65 72 6d 69 73 73 69 6f |object p|ermissio|
|000040d0| 6e 73 20 62 79 20 65 78 | 65 63 75 74 69 6e 67 20 |ns by ex|ecuting |
|000040e0| 47 52 41 4e 54 20 77 69 | 74 68 20 74 68 69 73 02 |GRANT wi|th this.|
|000040f0| 00 0c 18 04 73 79 6e 74 | 61 78 3a 02 00 01 02 00 |....synt|ax:.....|
|00004100| 2b 18 15 3c 50 72 65 73 | 73 20 50 67 44 6e 20 66 |+..<Pres|s PgDn f|
|00004110| 6f 72 20 6d 6f 72 65 3e | 02 00 01 02 00 22 18 04 |or more>|....."..|
|00004120| 47 52 41 4e 54 20 7b 41 | 4c 4c 20 7c 20 70 65 72 |GRANT {A|LL | per|
|00004130| 6d 69 73 73 69 6f 6e 5f | 6c 69 73 74 7d 02 00 41 |mission_|list}..A|
|00004140| 18 04 4f 4e 20 7b 74 61 | 62 6c 65 5f 6e 61 6d 65 |..ON {ta|ble_name|
|00004150| 20 5b 28 63 6f 6c 75 6d | 6e 5f 6c 69 73 74 29 5d | [(colum|n_list)]|
|00004160| 20 7c 20 76 69 65 77 5f | 6e 61 6d 65 20 5b 28 63 | | view_|name [(c|
|00004170| 6f 6c 75 6d 6e 5f 6c 69 | 73 74 29 5d 20 7c 02 00 |olumn_li|st)] |..|
|00004180| 1d 18 06 73 74 6f 72 65 | 64 5f 70 72 6f 63 65 64 |...store|d_proced|
|00004190| 75 72 65 5f 6e 61 6d 65 | 7d 02 00 1c 18 04 54 4f |ure_name|}.....TO|
|000041a0| 20 7b 50 55 42 4c 49 43 | 20 7c 20 6e 61 6d 65 5f | {PUBLIC| | name_|
|000041b0| 6c 69 73 74 7d 02 00 01 | 02 00 3e 18 04 2d 20 70 |list}...|..>..- p|
|000041c0| 65 72 6d 69 73 73 69 6f | 6e 5f 6c 69 73 74 20 66 |ermissio|n_list f|
|000041d0| 6f 72 20 74 61 62 6c 65 | 73 20 6f 72 20 76 69 65 |or table|s or vie|
|000041e0| 77 73 20 63 61 6e 20 69 | 6e 63 6c 75 64 65 20 53 |ws can i|nclude S|
|000041f0| 45 4c 45 43 54 2c 02 00 | 22 18 06 49 4e 53 45 52 |ELECT,..|"..INSER|
|00004200| 54 2c 20 44 45 4c 45 54 | 45 2c 20 61 6e 64 20 55 |T, DELET|E, and U|
|00004210| 50 44 41 54 45 2e 02 00 | 41 18 04 2d 20 70 65 72 |PDATE...|A..- per|
|00004220| 6d 69 73 73 69 6f 6e 5f | 6c 69 73 74 20 66 6f 72 |mission_|list for|
|00004230| 20 63 6f 6c 75 6d 6e 73 | 20 63 61 6e 20 69 6e 63 | columns| can inc|
|00004240| 6c 75 64 65 20 53 45 4c | 45 43 54 20 61 6e 64 20 |lude SEL|ECT and |
|00004250| 55 50 44 41 54 45 2e 02 | 00 43 18 04 2d 20 70 65 |UPDATE..|.C..- pe|
|00004260| 72 6d 69 73 73 69 6f 6e | 5f 6c 69 73 74 20 66 6f |rmission|_list fo|
|00004270| 72 20 73 74 6f 72 65 64 | 20 70 72 6f 63 65 64 75 |r stored| procedu|
|00004280| 72 65 73 20 69 6e 63 6c | 75 64 65 73 20 45 58 45 |res incl|udes EXE|
|00004290| 43 55 54 45 20 6f 6e 6c | 79 2e 02 00 01 02 00 1a |CUTE onl|y.......|
|000042a0| 13 45 78 61 6d 70 6c 65 | 3a 20 20 75 73 65 20 70 |.Example|: use p|
|000042b0| 75 62 73 02 00 1a 14 18 | 0a 3c 65 78 65 63 75 74 |ubs.....|.<execut|
|000042c0| 65 3e 02 00 37 18 0a 67 | 72 61 6e 74 20 69 6e 73 |e>..7..g|rant ins|
|000042d0| 65 72 74 2c 20 64 65 6c | 65 74 65 20 6f 6e 20 74 |ert, del|ete on t|
|000042e0| 69 74 6c 65 73 20 74 6f | 20 6a 61 6e 65 74 2c 20 |itles to| janet, |
|000042f0| 70 61 6d 02 00 1a 14 18 | 0a 3c 65 78 65 63 75 74 |pam.....|.<execut|
|00004300| 65 3e 02 00 01 02 00 cd | 05 1a 18 3a 6e 20 52 65 |e>......|...:n Re|
|00004310| 76 6f 6b 69 6e 67 20 50 | 65 72 6d 69 73 73 69 6f |voking P|ermissio|
|00004320| 6e 73 02 00 1a 16 53 74 | 61 74 65 6d 65 6e 74 20 |ns....St|atement |
|00004330| 50 65 72 6d 69 73 73 69 | 6f 6e 73 02 00 01 02 00 |Permissi|ons.....|
|00004340| 3c 54 6f 20 72 65 76 6f | 6b 65 20 70 65 72 6d 69 |<To revo|ke permi|
|00004350| 73 73 69 6f 6e 73 20 74 | 6f 20 75 73 65 20 53 51 |ssions t|o use SQ|
|00004360| 4c 20 73 74 61 74 65 6d | 65 6e 74 73 2c 20 65 78 |L statem|ents, ex|
|00004370| 65 63 75 74 65 20 52 45 | 56 4f 4b 45 02 00 1a 12 |ecute RE|VOKE....|
|00004380| 77 69 74 68 20 74 68 69 | 73 20 73 79 6e 74 61 78 |with thi|s syntax|
|00004390| 3a 02 00 01 02 00 3c 18 | 04 52 45 56 4f 4b 45 20 |:.....<.|.REVOKE |
|000043a0| 7b 41 4c 4c 20 7c 20 73 | 74 61 74 65 6d 65 6e 74 |{ALL | s|tatement|
|000043b0| 5f 6c 69 73 74 7d 20 46 | 52 4f 4d 20 7b 50 55 42 |_list} F|ROM {PUB|
|000043c0| 4c 49 43 20 7c 20 6e 61 | 6d 65 5f 6c 69 73 74 7d |LIC | na|me_list}|
|000043d0| 02 00 01 02 00 39 18 04 | 2d 20 73 74 61 74 65 6d |.....9..|- statem|
|000043e0| 65 6e 74 5f 6c 69 73 74 | 20 63 61 6e 20 69 6e 63 |ent_list| can inc|
|000043f0| 6c 75 64 65 20 43 52 45 | 41 54 45 20 44 41 54 41 |lude CRE|ATE DATA|
|00004400| 42 41 53 45 2c 20 43 52 | 45 41 54 45 02 00 3c 18 |BASE, CR|EATE..<.|
|00004410| 06 44 45 46 41 55 4c 54 | 2c 20 43 52 45 41 54 45 |.DEFAULT|, CREATE|
|00004420| 20 50 52 4f 43 45 44 55 | 52 45 2c 20 43 52 45 41 | PROCEDU|RE, CREA|
|00004430| 54 45 20 52 55 4c 45 2c | 20 43 52 45 41 54 45 20 |TE RULE,| CREATE |
|00004440| 54 41 42 4c 45 2c 02 00 | 38 18 06 43 52 45 41 54 |TABLE,..|8..CREAT|
|00004450| 45 20 56 49 45 57 2c 20 | 44 55 4d 50 20 44 41 54 |E VIEW, |DUMP DAT|
|00004460| 41 42 41 53 45 2c 20 61 | 6e 64 20 44 55 4d 50 20 |ABASE, a|nd DUMP |
|00004470| 54 52 41 4e 53 41 43 54 | 49 4f 4e 2e 02 00 37 18 |TRANSACT|ION...7.|
|00004480| 04 2d 20 6e 61 6d 65 5f | 6c 69 73 74 20 69 6e 63 |.- name_|list inc|
|00004490| 6c 75 64 65 73 20 75 73 | 65 72 6e 61 6d 65 73 20 |ludes us|ernames |
|000044a0| 61 6e 64 20 67 72 6f 75 | 70 6e 61 6d 65 73 20 69 |and grou|pnames i|
|000044b0| 6e 20 61 02 00 1b 18 06 | 70 61 72 74 69 63 75 6c |n a.....|particul|
|000044c0| 61 72 20 64 61 74 61 62 | 61 73 65 2e 02 00 01 02 |ar datab|ase.....|
|000044d0| 00 2b 18 15 3c 50 72 65 | 73 73 20 50 67 44 6e 20 |.+..<Pre|ss PgDn |
|000044e0| 66 6f 72 20 6d 6f 72 65 | 3e 02 00 01 02 00 2f 45 |for more|>...../E|
|000044f0| 78 61 6d 70 6c 65 3a 20 | 20 72 65 76 6f 6b 65 20 |xample: | revoke |
|00004500| 64 75 6d 70 20 64 61 74 | 61 62 61 73 65 20 66 72 |dump dat|abase fr|
|00004510| 6f 6d 20 61 63 63 6f 75 | 6e 74 69 6e 67 02 00 1a |om accou|nting...|
|00004520| 14 18 0a 3c 65 78 65 63 | 75 74 65 3e 02 00 01 02 |...<exec|ute>....|
|00004530| 00 1a 13 4f 62 6a 65 63 | 74 20 50 65 72 6d 69 73 |...Objec|t Permis|
|00004540| 73 69 6f 6e 73 02 00 01 | 02 00 2f 54 6f 20 72 65 |sions...|../To re|
|00004550| 76 6f 6b 65 20 70 65 72 | 6d 69 73 73 69 6f 6e 73 |voke per|missions|
|00004560| 20 74 6f 20 75 73 65 20 | 64 61 74 61 62 61 73 65 | to use |database|
|00004570| 20 6f 62 6a 65 63 74 73 | 3a 02 00 01 02 00 3a 31 | objects|:.....:1|
|00004580| 2e 20 20 45 6e 74 65 72 | 20 74 68 65 20 64 61 74 |. Enter| the dat|
|00004590| 61 62 61 73 65 20 69 6e | 20 77 68 69 63 68 20 79 |abase in| which y|
|000045a0| 6f 75 20 77 61 6e 74 20 | 74 6f 20 72 65 76 6f 6b |ou want |to revok|
|000045b0| 65 20 6f 62 6a 65 63 74 | 02 00 1a 11 18 04 70 65 |e object|......pe|
|000045c0| 72 6d 69 73 73 69 6f 6e | 73 2e 02 00 01 02 00 3c |rmission|s......<|
|000045d0| 32 2e 20 20 52 65 76 6f | 6b 65 20 6f 62 6a 65 63 |2. Revo|ke objec|
|000045e0| 74 20 70 65 72 6d 69 73 | 73 69 6f 6e 73 20 62 79 |t permis|sions by|
|000045f0| 20 65 78 65 63 75 74 69 | 6e 67 20 52 45 56 4f 4b | executi|ng REVOK|
|00004600| 45 20 77 69 74 68 20 74 | 68 69 73 02 00 0c 18 04 |E with t|his.....|
|00004610| 73 79 6e 74 61 78 3a 02 | 00 01 02 00 01 02 00 2b |syntax:.|.......+|
|00004620| 18 15 3c 50 72 65 73 73 | 20 50 67 44 6e 20 66 6f |..<Press| PgDn fo|
|00004630| 72 20 6d 6f 72 65 3e 02 | 00 01 02 00 23 18 04 52 |r more>.|....#..R|
|00004640| 45 56 4f 4b 45 20 7b 41 | 4c 4c 20 7c 20 70 65 72 |EVOKE {A|LL | per|
|00004650| 6d 69 73 73 69 6f 6e 5f | 6c 69 73 74 7d 02 00 40 |mission_|list}..@|
|00004660| 18 04 4f 4e 20 7b 74 61 | 62 6c 65 5f 6e 61 6d 65 |..ON {ta|ble_name|
|00004670| 20 5b 28 63 6f 6c 75 6d | 6e 5f 6c 69 73 74 29 5d | [(colum|n_list)]|
|00004680| 7c 20 76 69 65 77 5f 6e | 61 6d 65 20 5b 28 63 6f || view_n|ame [(co|
|00004690| 6c 75 6d 6e 5f 6c 69 73 | 74 29 5d 20 7c 02 00 1d |lumn_lis|t)] |...|
|000046a0| 18 06 73 74 6f 72 65 64 | 5f 70 72 6f 63 65 64 75 |..stored|_procedu|
|000046b0| 72 65 5f 6e 61 6d 65 7d | 02 00 1e 18 04 46 52 4f |re_name}|.....FRO|
|000046c0| 4d 20 7b 50 55 42 4c 49 | 43 20 7c 20 6e 61 6d 65 |M {PUBLI|C | name|
|000046d0| 5f 6c 69 73 74 7d 02 00 | 01 02 00 3e 18 04 2d 20 |_list}..|...>..- |
|000046e0| 70 65 72 6d 69 73 73 69 | 6f 6e 5f 6c 69 73 74 20 |permissi|on_list |
|000046f0| 66 6f 72 20 74 61 62 6c | 65 73 20 6f 72 20 76 69 |for tabl|es or vi|
|00004700| 65 77 73 20 63 61 6e 20 | 69 6e 63 6c 75 64 65 20 |ews can |include |
|00004710| 53 45 4c 45 43 54 2c 02 | 00 22 18 06 49 4e 53 45 |SELECT,.|."..INSE|
|00004720| 52 54 2c 20 44 45 4c 45 | 54 45 2c 20 61 6e 64 20 |RT, DELE|TE, and |
|00004730| 55 50 44 41 54 45 2e 02 | 00 41 18 04 2d 20 70 65 |UPDATE..|.A..- pe|
|00004740| 72 6d 69 73 73 69 6f 6e | 5f 6c 69 73 74 20 66 6f |rmission|_list fo|
|00004750| 72 20 63 6f 6c 75 6d 6e | 73 20 63 61 6e 20 69 6e |r column|s can in|
|00004760| 63 6c 75 64 65 20 53 45 | 4c 45 43 54 20 61 6e 64 |clude SE|LECT and|
|00004770| 20 55 50 44 41 54 45 2e | 02 00 3d 18 04 2d 20 70 | UPDATE.|..=..- p|
|00004780| 65 72 6d 69 73 73 69 6f | 6e 5f 6c 69 73 74 20 66 |ermissio|n_list f|
|00004790| 6f 72 20 73 74 6f 72 65 | 64 20 70 72 6f 63 65 64 |or store|d proced|
|000047a0| 75 72 65 73 20 69 6e 63 | 6c 75 64 65 73 20 45 58 |ures inc|ludes EX|
|000047b0| 45 43 55 54 45 02 00 0c | 18 06 6f 6e 6c 79 2e 02 |ECUTE...|..only..|
|000047c0| 00 01 02 00 01 02 00 01 | 02 00 2b 18 15 3c 50 72 |........|..+..<Pr|
|000047d0| 65 73 73 20 50 67 44 6e | 20 66 6f 72 20 6d 6f 72 |ess PgDn| for mor|
|000047e0| 65 3e 02 00 01 02 00 1a | 13 45 78 61 6d 70 6c 65 |e>......|.Example|
|000047f0| 3a 20 20 75 73 65 20 70 | 75 62 73 02 00 1a 14 18 |: use p|ubs.....|
|00004800| 0a 3c 65 78 65 63 75 74 | 65 3e 02 00 40 18 0a 72 |.<execut|e>..@..r|
|00004810| 65 76 6f 6b 65 20 75 70 | 64 61 74 65 20 6f 6e 20 |evoke up|date on |
|00004820| 74 69 74 6c 65 73 20 28 | 72 6f 79 61 6c 74 79 2c |titles (|royalty,|
|00004830| 20 61 64 76 61 6e 63 65 | 29 20 66 72 6f 6d 20 73 | advance|) from s|
|00004840| 61 6c 65 73 02 00 1a 14 | 18 0a 3c 65 78 65 63 75 |ales....|..<execu|
|00004850| 74 65 3e 02 00 01 02 00 | 1c 05 1c 3a 6e 20 53 65 |te>.....|...:n Se|
|00004860| 74 74 69 6e 67 20 44 61 | 74 61 62 61 73 65 20 4f |tting Da|tabase O|
|00004870| 70 74 69 6f 6e 73 02 00 | 1a 19 54 6f 20 73 65 74 |ptions..|..To set|
|00004880| 20 64 61 74 61 62 61 73 | 65 20 6f 70 74 69 6f 6e | databas|e option|
|00004890| 73 3a 02 00 01 02 00 26 | 31 2e 20 20 4d 61 6b 65 |s:.....&|1. Make|
|000048a0| 20 6d 61 73 74 65 72 20 | 74 68 65 20 63 75 72 72 | master |the curr|
|000048b0| 65 6e 74 20 64 61 74 61 | 62 61 73 65 2e 02 00 01 |ent data|base....|
|000048c0| 02 00 1a 19 32 2e 20 20 | 45 78 65 63 75 74 65 20 |....2. |Execute |
|000048d0| 73 70 5f 64 62 6f 70 74 | 69 6f 6e 3a 02 00 01 02 |sp_dbopt|ion:....|
|000048e0| 00 36 18 04 73 70 5f 64 | 62 6f 70 74 69 6f 6e 20 |.6..sp_d|boption |
|000048f0| 5b 64 62 6e 61 6d 65 2c | 20 22 64 62 5f 6f 70 74 |[dbname,| "db_opt|
|00004900| 69 6f 6e 22 2c 20 7b 74 | 72 75 65 20 7c 20 66 61 |ion", {t|rue | fa|
|00004910| 6c 73 65 7d 5d 02 00 01 | 02 00 27 18 04 4f 70 74 |lse}]...|..'..Opt|
|00004920| 69 6f 6e 18 11 44 65 73 | 63 72 69 70 74 69 6f 6e |ion..Des|cription|
|00004930| 02 00 27 18 04 19 2d 06 | 18 11 19 2d 0b 02 00 3d |..'...-.|...-...=|
|00004940| 18 04 64 62 6f 20 75 73 | 65 20 6f 6e 6c 79 18 0b |..dbo us|e only..|
|00004950| 41 6c 6c 6f 77 73 20 6f | 6e 6c 79 20 64 61 74 61 |Allows o|nly data|
|00004960| 62 61 73 65 20 6f 77 6e | 65 72 20 74 6f 20 75 73 |base own|er to us|
|00004970| 65 02 00 24 18 1b 64 61 | 74 61 62 61 73 65 02 00 |e..$..da|tabase..|
|00004980| 40 18 04 6e 6f 20 63 68 | 6b 70 74 20 6f 6e 20 72 |@..no ch|kpt on r|
|00004990| 65 63 6f 76 65 72 79 18 | 03 4b 65 65 70 73 20 61 |ecovery.|.Keeps a|
|000049a0| 6e 20 75 70 2d 74 6f 2d | 64 61 74 65 20 63 6f 70 |n up-to-|date cop|
|000049b0| 79 20 6f 66 20 64 61 74 | 61 62 61 73 65 02 00 01 |y of dat|abase...|
|000049c0| 02 00 2b 18 15 3c 50 72 | 65 73 73 20 50 67 44 6e |..+..<Pr|ess PgDn|
|000049d0| 20 66 6f 72 20 6d 6f 72 | 65 3e 02 00 01 02 00 43 | for mor|e>.....C|
|000049e0| 18 04 72 65 61 64 20 6f | 6e 6c 79 18 0e 41 6c 6c |..read o|nly..All|
|000049f0| 6f 77 73 20 64 61 74 61 | 62 61 73 65 20 64 61 74 |ows data|base dat|
|00004a00| 61 20 74 6f 20 62 65 20 | 72 65 61 64 20 62 75 74 |a to be |read but|
|00004a10| 20 6e 6f 74 02 00 24 18 | 1b 6d 6f 64 69 66 69 65 | not..$.|.modifie|
|00004a20| 64 02 00 38 18 04 73 65 | 6c 65 63 74 20 69 6e 74 |d..8..se|lect int|
|00004a30| 6f 2f 62 75 6c 6b 63 6f | 70 79 18 03 41 6c 6c 6f |o/bulkco|py..Allo|
|00004a40| 77 73 20 6e 6f 6e 2d 6c | 6f 67 67 65 64 20 6f 70 |ws non-l|ogged op|
|00004a50| 65 72 61 74 69 6f 6e 73 | 02 00 34 18 1b 28 57 52 |erations|..4..(WR|
|00004a60| 49 54 45 54 45 58 54 2c | 20 53 45 4c 45 43 54 20 |ITETEXT,| SELECT |
|00004a70| 49 4e 54 4f 2c 02 00 34 | 18 1b 61 6e 64 20 62 63 |INTO,..4|..and bc|
|00004a80| 70 29 20 74 6f 20 62 65 | 20 70 65 72 66 6f 72 6d |p) to be| perform|
|00004a90| 65 64 02 00 3d 18 04 73 | 69 6e 67 6c 65 20 75 73 |ed..=..s|ingle us|
|00004aa0| 65 72 18 0c 41 6c 6c 6f | 77 73 20 6f 6e 6c 79 20 |er..Allo|ws only |
|00004ab0| 6f 6e 65 20 75 73 65 72 | 20 61 74 20 61 20 74 69 |one user| at a ti|
|00004ac0| 6d 65 20 74 6f 02 00 2b | 18 1b 61 63 63 65 73 73 |me to..+|..access|
|00004ad0| 20 64 61 74 61 62 61 73 | 65 02 00 38 18 04 74 72 | databas|e..8..tr|
|00004ae0| 75 6e 63 2e 20 6c 6f 67 | 20 6f 6e 20 63 68 6b 70 |unc. log| on chkp|
|00004af0| 74 2e 18 03 54 72 75 6e | 63 61 74 65 73 20 74 72 |t...Trun|cates tr|
|00004b00| 61 6e 73 61 63 74 69 6f | 6e 20 6c 6f 67 20 61 74 |ansactio|n log at|
|00004b10| 02 00 26 18 1b 63 68 65 | 63 6b 70 6f 69 6e 74 02 |..&..che|ckpoint.|
|00004b20| 00 01 02 00 40 33 2e 20 | 20 45 78 65 63 75 74 65 |....@3. | Execute|
|00004b30| 20 43 48 45 43 4b 50 4f | 49 4e 54 20 69 6e 20 74 | CHECKPO|INT in t|
|00004b40| 68 65 20 64 61 74 61 62 | 61 73 65 20 66 6f 72 20 |he datab|ase for |
|00004b50| 77 68 69 63 68 20 74 68 | 65 20 6f 70 74 69 6f 6e |which th|e option|
|00004b60| 20 77 61 73 02 00 09 18 | 04 73 65 74 2e 02 00 01 | was....|.set....|
|00004b70| 02 00 2b 18 15 3c 50 72 | 65 73 73 20 50 67 44 6e |..+..<Pr|ess PgDn|
|00004b80| 20 66 6f 72 20 6d 6f 72 | 65 3e 02 00 01 02 00 1a | for mor|e>......|
|00004b90| 15 45 78 61 6d 70 6c 65 | 3a 20 20 75 73 65 20 6d |.Example|: use m|
|00004ba0| 61 73 74 65 72 02 00 1a | 14 18 0a 3c 65 78 65 63 |aster...|...<exec|
|00004bb0| 75 74 65 3e 02 00 2e 18 | 0a 73 70 5f 64 62 6f 70 |ute>....|.sp_dbop|
|00004bc0| 74 69 6f 6e 20 70 75 62 | 73 2c 20 22 72 65 61 64 |tion pub|s, "read|
|00004bd0| 20 6f 6e 6c 79 22 2c 20 | 74 72 75 65 02 00 1a 14 | only", |true....|
|00004be0| 18 0a 3c 65 78 65 63 75 | 74 65 3e 02 00 1a 13 18 |..<execu|te>.....|
|00004bf0| 0a 75 73 65 20 70 75 62 | 73 02 00 1a 14 18 0a 3c |.use pub|s......<|
|00004c00| 65 78 65 63 75 74 65 3e | 02 00 1a 15 18 0a 63 68 |execute>|......ch|
|00004c10| 65 63 6b 70 6f 69 6e 74 | 02 00 1a 14 18 0a 3c 65 |eckpoint|......<e|
|00004c20| 78 65 63 75 74 65 3e 02 | 00 01 02 00 8f 08 1a 19 |xecute>.|........|
|00004c30| 3a 6e 20 53 65 74 74 69 | 6e 67 20 51 75 65 72 79 |:n Setti|ng Query|
|00004c40| 20 4f 70 74 69 6f 6e 73 | 02 00 3b 51 75 65 72 79 | Options|..;Query|
|00004c50| 20 6f 70 74 69 6f 6e 73 | 20 63 68 61 6e 67 65 20 | options| change |
|00004c60| 74 68 65 20 77 61 79 20 | 71 75 65 72 69 65 73 20 |the way |queries |
|00004c70| 61 6e 64 20 73 74 6f 72 | 65 64 20 70 72 6f 63 65 |and stor|ed proce|
|00004c80| 64 75 72 65 73 02 00 40 | 61 72 65 20 68 61 6e 64 |dures..@|are hand|
|00004c90| 6c 65 64 2e 20 20 41 20 | 71 75 65 72 79 20 6f 70 |led. A |query op|
|00004ca0| 74 69 6f 6e 20 69 73 20 | 69 6e 20 65 66 66 65 63 |tion is |in effec|
|00004cb0| 74 20 66 72 6f 6d 20 74 | 68 65 20 74 69 6d 65 20 |t from t|he time |
|00004cc0| 79 6f 75 20 73 65 74 02 | 00 3a 69 74 20 75 6e 74 |you set.|.:it unt|
|00004cd0| 69 6c 20 79 6f 75 20 6c | 6f 67 20 6f 66 66 2e 20 |il you l|og off. |
|00004ce0| 20 54 6f 20 73 65 74 20 | 71 75 65 72 79 20 6f 70 | To set |query op|
|00004cf0| 74 69 6f 6e 73 2c 20 65 | 78 65 63 75 74 65 20 53 |tions, e|xecute S|
|00004d00| 45 54 3a 02 00 01 02 00 | 3c 18 04 53 45 54 20 7b |ET:.....|<..SET {|
|00004d10| 7b 41 52 49 54 48 41 42 | 4f 52 54 20 7c 20 41 52 |{ARITHAB|ORT | AR|
|00004d20| 49 54 48 49 47 4e 4f 52 | 45 20 7c 20 42 41 43 4b |ITHIGNOR|E | BACK|
|00004d30| 47 52 4f 55 4e 44 20 7c | 20 4e 4f 43 4f 55 4e 54 |GROUND || NOCOUNT|
|00004d40| 20 7c 02 00 3d 18 06 4e | 4f 45 58 45 43 20 7c 20 | |..=..N|OEXEC | |
|00004d50| 4f 46 46 53 45 54 53 20 | 7b 6b 65 79 77 6f 72 64 |OFFSETS |{keyword|
|00004d60| 5f 6c 69 73 74 7d 20 7c | 20 50 41 52 53 45 4f 4e |_list} || PARSEON|
|00004d70| 4c 59 20 7c 20 50 52 4f | 43 49 44 20 7c 02 00 40 |LY | PRO|CID |..@|
|00004d80| 18 06 53 48 4f 57 50 4c | 41 4e 20 7c 20 53 54 41 |..SHOWPL|AN | STA|
|00004d90| 54 49 53 54 49 43 53 20 | 49 4f 20 7c 20 53 54 41 |TISTICS |IO | STA|
|00004da0| 54 49 53 54 49 43 53 20 | 54 49 4d 45 20 7d 20 7b |TISTICS |TIME } {|
|00004db0| 4f 4e 20 7c 20 4f 46 46 | 7d 20 7c 02 00 24 18 06 |ON | OFF|} |..$..|
|00004dc0| 52 4f 57 43 4f 55 4e 54 | 20 6e 75 6d 62 65 72 20 |ROWCOUNT| number |
|00004dd0| 7c 20 54 45 58 54 53 49 | 5a 45 20 6e 7d 02 00 01 || TEXTSI|ZE n}...|
|00004de0| 02 00 23 18 06 4f 70 74 | 69 6f 6e 18 0c 44 65 66 |..#..Opt|ion..Def|
|00004df0| 69 6e 69 74 69 6f 6e 02 | 00 23 18 06 19 2d 06 18 |inition.|.#...-..|
|00004e00| 0c 19 2d 0a 02 00 41 18 | 06 41 52 49 54 48 41 42 |..-...A.|.ARITHAB|
|00004e10| 4f 52 54 18 08 41 62 6f | 72 74 73 20 71 75 65 72 |ORT..Abo|rts quer|
|00004e20| 79 20 77 68 65 6e 20 6f | 76 65 72 66 6c 6f 77 20 |y when o|verflow |
|00004e30| 6f 72 20 64 69 76 69 64 | 65 2d 62 79 2d 02 00 2a |or divid|e-by-..*|
|00004e40| 18 18 7a 65 72 6f 20 65 | 72 72 6f 72 20 6f 63 63 |..zero e|rror occ|
|00004e50| 75 72 73 02 00 01 02 00 | 2b 18 15 3c 50 72 65 73 |urs.....|+..<Pres|
|00004e60| 73 20 50 67 44 6e 20 66 | 6f 72 20 6d 6f 72 65 3e |s PgDn f|or more>|
|00004e70| 02 00 01 02 00 41 18 06 | 41 52 49 54 48 49 47 4e |.....A..|ARITHIGN|
|00004e80| 4f 52 45 18 07 52 65 74 | 75 72 6e 73 20 4e 55 4c |ORE..Ret|urns NUL|
|00004e90| 4c 20 77 68 65 6e 20 6f | 76 65 72 66 6c 6f 77 20 |L when o|verflow |
|00004ea0| 6f 72 20 64 69 76 69 64 | 65 2d 62 79 2d 02 00 2a |or divid|e-by-..*|
|00004eb0| 18 18 7a 65 72 6f 20 65 | 72 72 6f 72 20 6f 63 63 |..zero e|rror occ|
|00004ec0| 75 72 73 02 00 3f 18 06 | 42 41 43 4b 47 52 4f 55 |urs..?..|BACKGROU|
|00004ed0| 4e 44 18 08 50 75 74 73 | 20 70 72 6f 63 65 73 73 |ND..Puts| process|
|00004ee0| 65 73 20 67 65 6e 65 72 | 61 74 65 64 20 62 79 20 |es gener|ated by |
|00004ef0| 73 75 62 73 65 71 75 65 | 6e 74 02 00 3c 18 18 73 |subseque|nt..<..s|
|00004f00| 74 61 74 65 6d 65 6e 74 | 73 20 69 6e 20 62 61 63 |tatement|s in bac|
|00004f10| 6b 67 72 6f 75 6e 64 20 | 61 6e 64 20 62 72 65 61 |kground |and brea|
|00004f20| 6b 73 02 00 2f 18 18 77 | 6f 72 6b 73 74 61 74 69 |ks../..w|orkstati|
|00004f30| 6f 6e 20 63 6f 6e 6e 65 | 63 74 69 6f 6e 02 00 39 |on conne|ction..9|
|00004f40| 18 06 4e 4f 43 4f 55 4e | 54 18 0b 54 75 72 6e 73 |..NOCOUN|T..Turns|
|00004f50| 20 6f 66 66 20 6d 65 73 | 73 61 67 65 20 74 68 61 | off mes|sage tha|
|00004f60| 74 20 74 65 6c 6c 73 20 | 68 6f 77 02 00 3f 18 18 |t tells |how..?..|
|00004f70| 6d 61 6e 79 20 72 6f 77 | 73 20 77 65 72 65 20 61 |many row|s were a|
|00004f80| 66 66 65 63 74 65 64 20 | 62 79 20 61 20 73 74 61 |ffected |by a sta|
|00004f90| 74 65 6d 65 6e 74 02 00 | 41 18 06 4e 4f 45 58 45 |tement..|A..NOEXE|
|00004fa0| 43 18 0c 43 6f 6d 70 69 | 6c 65 73 20 65 61 63 68 |C..Compi|les each|
|00004fb0| 20 71 75 65 72 79 20 62 | 75 74 20 64 6f 65 73 20 | query b|ut does |
|00004fc0| 6e 6f 74 20 65 78 65 63 | 75 74 65 02 00 1b 18 18 |not exec|ute.....|
|00004fd0| 69 74 02 00 40 18 06 4f | 46 46 53 45 54 53 18 0b |it..@..O|FFSETS..|
|00004fe0| 52 65 74 75 72 6e 73 20 | 6f 66 66 73 65 74 20 6f |Returns |offset o|
|00004ff0| 66 20 73 70 65 63 69 66 | 69 65 64 20 6b 65 79 77 |f specif|ied keyw|
|00005000| 6f 72 64 73 20 69 6e 02 | 00 27 18 18 53 51 4c 20 |ords in.|.'..SQL |
|00005010| 73 74 61 74 65 6d 65 6e | 74 73 02 00 01 02 00 2b |statemen|ts.....+|
|00005020| 18 15 3c 50 72 65 73 73 | 20 50 67 44 6e 20 66 6f |..<Press| PgDn fo|
|00005030| 72 20 6d 6f 72 65 3e 02 | 00 01 02 00 41 18 06 50 |r more>.|....A..P|
|00005040| 41 52 53 45 4f 4e 4c 59 | 18 09 43 68 65 63 6b 73 |ARSEONLY|..Checks|
|00005050| 20 73 79 6e 74 61 78 20 | 6f 66 20 71 75 65 72 79 | syntax |of query|
|00005060| 20 61 6e 64 20 72 65 74 | 75 72 6e 73 20 65 72 72 | and ret|urns err|
|00005070| 6f 72 02 00 39 18 18 6d | 65 73 73 61 67 65 73 20 |or..9..m|essages |
|00005080| 77 69 74 68 6f 75 74 20 | 65 78 65 63 75 74 69 6e |without |executin|
|00005090| 67 20 71 75 65 72 79 02 | 00 40 18 06 50 52 4f 43 |g query.|.@..PROC|
|000050a0| 49 44 18 0c 52 65 74 75 | 72 6e 73 20 61 20 73 74 |ID..Retu|rns a st|
|000050b0| 6f 72 65 64 20 70 72 6f | 63 65 64 75 72 65 20 49 |ored pro|cedure I|
|000050c0| 44 20 6e 75 6d 62 65 72 | 20 74 6f 02 00 23 18 18 |D number| to..#..|
|000050d0| 44 42 2d 4c 49 42 52 41 | 52 59 02 00 40 18 06 53 |DB-LIBRA|RY..@..S|
|000050e0| 48 4f 57 50 4c 41 4e 18 | 0a 47 65 6e 65 72 61 74 |HOWPLAN.|.Generat|
|000050f0| 65 73 20 64 65 73 63 72 | 69 70 74 69 6f 6e 20 6f |es descr|iption o|
|00005100| 66 20 74 68 65 20 70 72 | 6f 63 65 73 73 69 6e 67 |f the pr|ocessing|
|00005110| 02 00 27 18 18 70 6c 61 | 6e 20 66 6f 72 20 71 75 |..'..pla|n for qu|
|00005120| 65 72 79 02 00 37 18 06 | 53 54 41 54 49 53 54 49 |ery..7..|STATISTI|
|00005130| 43 53 20 49 4f 18 05 44 | 69 73 70 6c 61 79 73 20 |CS IO..D|isplays |
|00005140| 72 65 61 64 2f 77 72 69 | 74 65 20 73 74 61 74 69 |read/wri|te stati|
|00005150| 73 74 69 63 73 02 00 3a | 18 06 53 54 41 54 49 53 |stics..:|..STATIS|
|00005160| 54 49 43 53 20 54 49 4d | 45 18 03 44 69 73 70 6c |TICS TIM|E..Displ|
|00005170| 61 79 73 20 74 69 6d 65 | 20 73 74 61 74 69 73 74 |ays time| statist|
|00005180| 69 63 73 20 66 6f 72 20 | 65 61 63 68 02 00 22 18 |ics for |each..".|
|00005190| 18 73 74 61 74 65 6d 65 | 6e 74 02 00 3f 18 06 52 |.stateme|nt..?..R|
|000051a0| 4f 57 43 4f 55 4e 54 18 | 0a 53 74 6f 70 73 20 70 |OWCOUNT.|.Stops p|
|000051b0| 72 6f 63 65 73 73 69 6e | 67 20 71 75 65 72 79 20 |rocessin|g query |
|000051c0| 61 66 74 65 72 20 73 70 | 65 63 69 66 69 65 64 02 |after sp|ecified.|
|000051d0| 00 34 18 18 6e 75 6d 62 | 65 72 20 6f 66 20 72 6f |.4..numb|er of ro|
|000051e0| 77 73 20 61 72 65 20 72 | 65 74 75 72 6e 65 64 02 |ws are r|eturned.|
|000051f0| 00 01 02 00 01 02 00 2b | 18 15 3c 50 72 65 73 73 |.......+|..<Press|
|00005200| 20 50 67 44 6e 20 66 6f | 72 20 6d 6f 72 65 3e 02 | PgDn fo|r more>.|
|00005210| 00 01 02 00 40 18 06 54 | 45 58 54 53 49 5a 45 18 |....@..T|EXTSIZE.|
|00005220| 0a 53 70 65 63 69 66 69 | 65 73 20 73 69 7a 65 20 |.Specifi|es size |
|00005230| 69 6e 20 62 79 74 65 73 | 20 6f 66 20 74 65 78 74 |in bytes| of text|
|00005240| 20 64 61 74 61 20 74 6f | 02 00 30 18 18 62 65 20 | data to|..0..be |
|00005250| 72 65 74 75 72 6e 65 64 | 20 77 69 74 68 20 53 45 |returned| with SE|
|00005260| 4c 45 43 54 02 00 01 02 | 00 21 45 78 61 6d 70 6c |LECT....|.!Exampl|
|00005270| 65 3a 20 20 73 65 74 20 | 73 74 61 74 69 73 74 69 |e: set |statisti|
|00005280| 63 73 20 74 69 6d 65 20 | 6f 6e 02 00 1a 14 18 0a |cs time |on......|
|00005290| 3c 65 78 65 63 75 74 65 | 3e 02 00 01 02 00 1a 04 |<execute|>.......|
|000052a0| 1a 15 3a 6e 20 41 64 64 | 69 6e 67 20 61 20 4c 6f |..:n Add|ing a Lo|
|000052b0| 67 69 6e 20 49 44 02 00 | 40 4c 6f 67 69 6e 20 69 |gin ID..|@Login i|
|000052c0| 64 65 6e 74 69 66 69 63 | 61 74 69 6f 6e 73 20 28 |dentific|ations (|
|000052d0| 6c 6f 67 69 6e 20 49 44 | 73 29 20 61 72 65 20 61 |login ID|s) are a|
|000052e0| 73 73 69 67 6e 65 64 20 | 74 6f 20 75 73 65 72 73 |ssigned |to users|
|000052f0| 20 74 6f 20 67 69 76 65 | 02 00 39 74 68 65 6d 20 | to give|..9them |
|00005300| 61 63 63 65 73 73 20 74 | 6f 20 61 20 53 51 4c 20 |access t|o a SQL |
|00005310| 53 65 72 76 65 72 2e 20 | 55 73 65 72 6e 61 6d 65 |Server. |Username|
|00005320| 73 20 61 6c 6c 6f 77 20 | 61 63 63 65 73 73 20 74 |s allow |access t|
|00005330| 6f 20 61 02 00 1d 64 61 | 74 61 62 61 73 65 2e 20 |o a...da|tabase. |
|00005340| 54 6f 20 61 64 64 20 61 | 20 6c 6f 67 69 6e 20 49 |To add a| login I|
|00005350| 44 3a 02 00 01 02 00 32 | 31 2e 20 20 46 72 6f 6d |D:.....2|1. From|
|00005360| 20 74 68 65 20 41 64 6d | 69 6e 20 6d 65 6e 75 2c | the Adm|in menu,|
|00005370| 20 63 68 6f 6f 73 65 20 | 4d 61 6e 61 67 65 20 4c | choose |Manage L|
|00005380| 6f 67 69 6e 20 49 44 73 | 2e 02 00 1b 32 2e 20 20 |ogin IDs|....2. |
|00005390| 43 68 6f 6f 73 65 20 74 | 68 65 20 41 64 64 20 62 |Choose t|he Add b|
|000053a0| 75 74 74 6f 6e 2e 02 00 | 41 33 2e 20 20 54 6f 20 |utton...|A3. To |
|000053b0| 63 72 65 61 74 65 20 61 | 20 6c 6f 67 69 6e 20 49 |create a| login I|
|000053c0| 44 2c 20 69 6e 20 74 68 | 65 20 4c 6f 67 69 6e 20 |D, in th|e Login |
|000053d0| 49 44 20 62 6f 78 2c 20 | 74 79 70 65 20 74 68 65 |ID box, |type the|
|000053e0| 20 6c 6f 67 69 6e 20 49 | 44 02 00 41 18 04 6f 72 | login I|D..A..or|
|000053f0| 20 73 65 6c 65 63 74 20 | 6f 6e 65 20 66 72 6f 6d | select |one from|
|00005400| 20 74 68 65 20 6c 69 73 | 74 20 62 6f 78 2e 20 54 | the lis|t box. T|
|00005410| 68 65 20 6c 6f 67 69 6e | 20 49 44 20 6d 75 73 74 |he login| ID must|
|00005420| 20 62 65 20 75 6e 69 71 | 75 65 02 00 1a 13 18 04 | be uniq|ue......|
|00005430| 6f 6e 20 74 68 65 20 73 | 65 72 76 65 72 2e 02 00 |on the s|erver...|
|00005440| 38 34 2e 20 20 54 6f 20 | 61 73 73 69 67 6e 20 61 |84. To |assign a|
|00005450| 20 70 61 73 73 77 6f 72 | 64 2c 20 69 6e 20 74 68 | passwor|d, in th|
|00005460| 65 20 50 61 73 73 77 6f | 72 64 20 62 6f 78 2c 20 |e Passwo|rd box, |
|00005470| 74 79 70 65 20 74 68 65 | 02 00 3c 18 04 70 61 73 |type the|..<..pas|
|00005480| 73 77 6f 72 64 2e 20 49 | 66 20 79 6f 75 20 64 6f |sword. I|f you do|
|00005490| 6e 27 74 20 61 73 73 69 | 67 6e 20 61 20 70 61 73 |n't assi|gn a pas|
|000054a0| 73 77 6f 72 64 2c 20 61 | 20 3c 4d 53 3e 4e 55 4c |sword, a| <MS>NUL|
|000054b0| 4c 3c 44 3e 02 00 3f 18 | 04 70 61 73 73 77 6f 72 |L<D>..?.|.passwor|
|000054c0| 64 20 69 73 20 61 73 73 | 69 67 6e 65 64 20 61 6e |d is ass|igned an|
|000054d0| 64 20 74 68 65 20 75 73 | 65 72 20 64 6f 65 73 20 |d the us|er does |
|000054e0| 6e 6f 74 20 6e 65 65 64 | 20 74 6f 20 65 6e 74 65 |not need| to ente|
|000054f0| 72 20 61 02 00 2b 18 04 | 70 61 73 73 77 6f 72 64 |r a..+..|password|
|00005500| 20 74 6f 20 6c 6f 67 20 | 69 6e 20 74 6f 20 53 51 | to log |in to SQ|
|00005510| 4c 3c 4e 3e 3c 2d 3e 53 | 65 72 76 65 72 2e 02 00 |L<N><->S|erver...|
|00005520| 01 02 00 2b 18 15 3c 50 | 72 65 73 73 20 50 67 44 |...+..<P|ress PgD|
|00005530| 6e 20 66 6f 72 20 6d 6f | 72 65 3e 02 00 01 02 00 |n for mo|re>.....|
|00005540| 34 35 2e 20 20 49 6e 20 | 74 68 65 20 52 65 2d 65 |45. In |the Re-e|
|00005550| 6e 74 65 72 20 50 61 73 | 73 77 6f 72 64 20 62 6f |nter Pas|sword bo|
|00005560| 78 2c 20 74 79 70 65 20 | 74 68 65 20 70 61 73 73 |x, type |the pass|
|00005570| 77 6f 72 64 02 00 0b 18 | 04 61 67 61 69 6e 2e 02 |word....|.again..|
|00005580| 00 39 36 2e 20 20 54 6f | 20 63 72 65 61 74 65 20 |.96. To| create |
|00005590| 61 20 75 73 65 72 6e 61 | 6d 65 2c 20 69 6e 20 74 |a userna|me, in t|
|000055a0| 68 65 20 55 73 65 72 20 | 4e 61 6d 65 20 62 6f 78 |he User |Name box|
|000055b0| 2c 20 74 79 70 65 20 74 | 68 65 02 00 3f 18 05 75 |, type t|he..?..u|
|000055c0| 73 65 72 6e 61 6d 65 2e | 20 49 66 20 79 6f 75 20 |sername.| If you |
|000055d0| 64 6f 6e 27 74 20 61 73 | 73 69 67 6e 20 61 20 75 |don't as|sign a u|
|000055e0| 73 65 72 6e 61 6d 65 2c | 20 74 68 65 20 6c 6f 67 |sername,| the log|
|000055f0| 69 6e 20 49 44 20 69 73 | 02 00 23 18 05 75 73 65 |in ID is|..#..use|
|00005600| 64 20 61 73 20 74 68 65 | 20 64 65 66 61 75 6c 74 |d as the| default|
|00005610| 20 75 73 65 72 6e 61 6d | 65 2e 02 00 41 37 2e 20 | usernam|e...A7. |
|00005620| 20 54 6f 20 73 65 6c 65 | 63 74 20 74 68 65 20 64 | To sele|ct the d|
|00005630| 65 66 61 75 6c 74 20 64 | 61 74 61 62 61 73 65 2c |efault d|atabase,|
|00005640| 20 69 6e 20 74 68 65 20 | 44 65 66 61 75 6c 74 20 | in the |Default |
|00005650| 44 61 74 61 62 61 73 65 | 20 62 6f 78 2c 02 00 1a |Database| box,...|
|00005660| 17 18 04 73 65 6c 65 63 | 74 20 61 20 64 61 74 61 |...selec|t a data|
|00005670| 62 61 73 65 2e 02 00 1a | 1a 38 2e 20 20 43 68 6f |base....|.8. Cho|
|00005680| 6f 73 65 20 74 68 65 20 | 4f 4b 20 62 75 74 74 6f |ose the |OK butto|
|00005690| 6e 2e 02 00 01 02 00 98 | 01 1e 3a 6e 20 43 68 61 |n.......|..:n Cha|
|000056a0| 6e 67 69 6e 67 20 61 20 | 55 73 65 72 27 73 20 50 |nging a |User's P|
|000056b0| 61 73 73 77 6f 72 64 02 | 00 1d 54 6f 20 63 68 61 |assword.|..To cha|
|000056c0| 6e 67 65 20 61 20 75 73 | 65 72 27 73 20 70 61 73 |nge a us|er's pas|
|000056d0| 73 77 6f 72 64 3a 02 00 | 01 02 00 32 31 2e 20 20 |sword:..|...21. |
|000056e0| 46 72 6f 6d 20 74 68 65 | 20 41 64 6d 69 6e 20 6d |From the| Admin m|
|000056f0| 65 6e 75 2c 20 63 68 6f | 6f 73 65 20 4d 61 6e 61 |enu, cho|ose Mana|
|00005700| 67 65 20 4c 6f 67 69 6e | 20 49 44 73 2e 02 00 3c |ge Login| IDs...<|
|00005710| 32 2e 20 20 46 72 6f 6d | 20 74 68 65 20 4c 6f 67 |2. From| the Log|
|00005720| 69 6e 20 49 44 20 62 6f | 78 2c 20 73 65 6c 65 63 |in ID bo|x, selec|
|00005730| 74 20 74 68 65 20 6c 6f | 67 69 6e 20 49 44 20 66 |t the lo|gin ID f|
|00005740| 6f 72 20 74 68 65 20 75 | 73 65 72 02 00 27 18 04 |or the u|ser..'..|
|00005750| 77 68 6f 73 65 20 70 61 | 73 73 77 6f 72 64 20 79 |whose pa|ssword y|
|00005760| 6f 75 20 77 61 6e 74 20 | 74 6f 20 63 68 61 6e 67 |ou want |to chang|
|00005770| 65 2e 02 00 27 33 2e 20 | 20 43 68 6f 6f 73 65 20 |e...'3. | Choose |
|00005780| 74 68 65 20 43 68 61 6e | 67 65 20 50 61 73 73 77 |the Chan|ge Passw|
|00005790| 6f 72 64 20 62 75 74 74 | 6f 6e 2e 02 00 34 34 2e |ord butt|on...44.|
|000057a0| 20 20 49 6e 20 74 68 65 | 20 4e 65 77 20 50 61 73 | In the| New Pas|
|000057b0| 73 77 6f 72 64 20 62 6f | 78 2c 20 74 79 70 65 20 |sword bo|x, type |
|000057c0| 74 68 65 20 6e 65 77 20 | 70 61 73 73 77 6f 72 64 |the new |password|
|000057d0| 2e 02 00 3b 35 2e 20 20 | 49 6e 20 74 68 65 20 52 |...;5. |In the R|
|000057e0| 65 2d 65 6e 74 65 72 20 | 50 61 73 73 77 6f 72 64 |e-enter |Password|
|000057f0| 20 62 6f 78 2c 20 74 79 | 70 65 20 74 68 65 20 70 | box, ty|pe the p|
|00005800| 61 73 73 77 6f 72 64 20 | 61 67 61 69 6e 2e 02 00 |assword |again...|
|00005810| 1a 1a 36 2e 20 20 43 68 | 6f 6f 73 65 20 74 68 65 |..6. Ch|oose the|
|00005820| 20 4f 4b 20 62 75 74 74 | 6f 6e 2e 02 00 01 02 00 | OK butt|on......|
|00005830| 8d 01 26 3a 6e 20 43 68 | 61 6e 67 69 6e 67 20 61 |..&:n Ch|anging a|
|00005840| 20 55 73 65 72 27 73 20 | 44 65 66 61 75 6c 74 20 | User's |Default |
|00005850| 44 61 74 61 62 61 73 65 | 02 00 25 54 6f 20 63 68 |Database|..%To ch|
|00005860| 61 6e 67 65 20 61 20 75 | 73 65 72 27 73 20 64 65 |ange a u|ser's de|
|00005870| 66 61 75 6c 74 20 64 61 | 74 61 62 61 73 65 3a 02 |fault da|tabase:.|
|00005880| 00 01 02 00 32 31 2e 20 | 20 46 72 6f 6d 20 74 68 |....21. | From th|
|00005890| 65 20 41 64 6d 69 6e 20 | 6d 65 6e 75 2c 20 63 68 |e Admin |menu, ch|
|000058a0| 6f 6f 73 65 20 4d 61 6e | 61 67 65 20 4c 6f 67 69 |oose Man|age Logi|
|000058b0| 6e 20 49 44 73 2e 02 00 | 3c 32 2e 20 20 46 72 6f |n IDs...|<2. Fro|
|000058c0| 6d 20 74 68 65 20 4c 6f | 67 69 6e 20 49 44 20 62 |m the Lo|gin ID b|
|000058d0| 6f 78 2c 20 73 65 6c 65 | 63 74 20 74 68 65 20 6c |ox, sele|ct the l|
|000058e0| 6f 67 69 6e 20 49 44 20 | 66 6f 72 20 74 68 65 20 |ogin ID |for the |
|000058f0| 75 73 65 72 02 00 2f 18 | 04 77 68 6f 73 65 20 64 |user../.|.whose d|
|00005900| 65 66 61 75 6c 74 20 64 | 61 74 61 62 61 73 65 20 |efault d|atabase |
|00005910| 79 6f 75 20 77 61 6e 74 | 20 74 6f 20 63 68 61 6e |you want| to chan|
|00005920| 67 65 2e 02 00 29 33 2e | 20 20 43 68 6f 6f 73 65 |ge...)3.| Choose|
|00005930| 20 74 68 65 20 43 68 61 | 6e 67 65 20 44 65 66 61 | the Cha|nge Defa|
|00005940| 75 6c 74 20 44 42 20 62 | 75 74 74 6f 6e 2e 02 00 |ult DB b|utton...|
|00005950| 3c 34 2e 20 20 46 72 6f | 6d 20 74 68 65 20 4e 65 |<4. Fro|m the Ne|
|00005960| 77 20 44 65 66 61 75 6c | 74 20 44 61 74 61 62 61 |w Defaul|t Databa|
|00005970| 73 65 20 62 6f 78 2c 20 | 73 65 6c 65 63 74 20 61 |se box, |select a|
|00005980| 20 6e 65 77 20 64 65 66 | 61 75 6c 74 02 00 0e 18 | new def|ault....|
|00005990| 04 64 61 74 61 62 61 73 | 65 2e 02 00 1a 1a 35 2e |.databas|e.....5.|
|000059a0| 20 20 43 68 6f 6f 73 65 | 20 74 68 65 20 4f 4b 20 | Choose| the OK |
|000059b0| 62 75 74 74 6f 6e 2e 02 | 00 01 02 00 13 02 25 3a |button..|......%:|
|000059c0| 6e 20 44 65 6c 65 74 69 | 6e 67 20 61 20 4c 6f 67 |n Deleti|ng a Log|
|000059d0| 69 6e 20 49 44 20 66 72 | 6f 6d 20 61 20 53 65 72 |in ID fr|om a Ser|
|000059e0| 76 65 72 02 00 36 42 65 | 66 6f 72 65 20 79 6f 75 |ver..6Be|fore you|
|000059f0| 20 63 61 6e 20 64 65 6c | 65 74 65 20 61 20 6c 6f | can del|ete a lo|
|00005a00| 67 69 6e 20 49 44 2c 20 | 79 6f 75 20 6d 75 73 74 |gin ID, |you must|
|00005a10| 20 64 65 6c 65 74 65 20 | 74 68 65 02 00 3a 63 6f | delete |the..:co|
|00005a20| 72 72 65 73 70 6f 6e 64 | 69 6e 67 20 75 73 65 72 |rrespond|ing user|
|00005a30| 6e 61 6d 65 2e 20 59 6f | 75 20 63 61 6e 6e 6f 74 |name. Yo|u cannot|
|00005a40| 20 64 65 6c 65 74 65 20 | 61 20 75 73 65 72 20 77 | delete |a user w|
|00005a50| 68 6f 20 6f 77 6e 73 02 | 00 3e 64 61 74 61 62 61 |ho owns.|.>databa|
|00005a60| 73 65 20 6f 62 6a 65 63 | 74 73 2e 20 49 66 20 74 |se objec|ts. If t|
|00005a70| 68 65 20 75 73 65 72 20 | 6f 77 6e 73 20 64 61 74 |he user |owns dat|
|00005a80| 61 62 61 73 65 20 6f 62 | 6a 65 63 74 73 2c 20 79 |abase ob|jects, y|
|00005a90| 6f 75 20 6d 75 73 74 02 | 00 3f 64 72 6f 70 20 74 |ou must.|.?drop t|
|00005aa0| 68 65 20 6f 62 6a 65 63 | 74 73 20 6f 72 20 63 68 |he objec|ts or ch|
|00005ab0| 61 6e 67 65 20 6f 77 6e | 65 72 73 68 69 70 20 6f |ange own|ership o|
|00005ac0| 66 20 74 68 65 20 6f 62 | 6a 65 63 74 73 20 62 65 |f the ob|jects be|
|00005ad0| 66 6f 72 65 20 79 6f 75 | 02 00 29 63 61 6e 20 64 |fore you|..)can d|
|00005ae0| 72 6f 70 20 74 68 65 20 | 75 73 65 72 2e 20 54 6f |rop the |user. To|
|00005af0| 20 64 65 6c 65 74 65 20 | 61 20 6c 6f 67 69 6e 20 | delete |a login |
|00005b00| 49 44 3a 02 00 01 02 00 | 32 31 2e 20 20 46 72 6f |ID:.....|21. Fro|
|00005b10| 6d 20 74 68 65 20 41 64 | 6d 69 6e 20 6d 65 6e 75 |m the Ad|min menu|
|00005b20| 2c 20 63 68 6f 6f 73 65 | 20 4d 61 6e 61 67 65 20 |, choose| Manage |
|00005b30| 4c 6f 67 69 6e 20 49 44 | 73 2e 02 00 40 32 2e 20 |Login ID|s...@2. |
|00005b40| 20 46 72 6f 6d 20 74 68 | 65 20 4c 6f 67 69 6e 20 | From th|e Login |
|00005b50| 49 44 20 62 6f 78 2c 20 | 73 65 6c 65 63 74 20 74 |ID box, |select t|
|00005b60| 68 65 20 6c 6f 67 69 6e | 20 49 44 20 66 6f 72 20 |he login| ID for |
|00005b70| 74 68 65 20 75 73 65 72 | 20 79 6f 75 02 00 1a 12 |the user| you....|
|00005b80| 18 04 77 61 6e 74 20 74 | 6f 20 64 72 6f 70 2e 02 |..want t|o drop..|
|00005b90| 00 1e 33 2e 20 20 43 68 | 6f 6f 73 65 20 74 68 65 |..3. Ch|oose the|
|00005ba0| 20 44 65 6c 65 74 65 20 | 62 75 74 74 6f 6e 2e 02 | Delete |button..|
|00005bb0| 00 1a 1a 34 2e 20 20 43 | 68 6f 6f 73 65 20 74 68 |...4. C|hoose th|
|00005bc0| 65 20 4f 4b 20 62 75 74 | 74 6f 6e 2e 02 00 01 02 |e OK but|ton.....|
|00005bd0| 00 35 02 1f 3a 6e 20 41 | 64 64 69 6e 67 20 61 20 |.5..:n A|dding a |
|00005be0| 55 73 65 72 20 74 6f 20 | 61 20 44 61 74 61 62 61 |User to |a Databa|
|00005bf0| 73 65 02 00 21 54 6f 20 | 61 64 64 20 61 20 75 73 |se..!To |add a us|
|00005c00| 65 72 6e 61 6d 65 20 74 | 6f 20 61 20 64 61 74 61 |ername t|o a data|
|00005c10| 62 61 73 65 3a 02 00 01 | 02 00 32 31 2e 20 20 46 |base:...|..21. F|
|00005c20| 72 6f 6d 20 74 68 65 20 | 41 64 6d 69 6e 20 6d 65 |rom the |Admin me|
|00005c30| 6e 75 2c 20 63 68 6f 6f | 73 65 20 4d 61 6e 61 67 |nu, choo|se Manag|
|00005c40| 65 20 55 73 65 72 6e 61 | 6d 65 73 2e 02 00 40 32 |e Userna|mes...@2|
|00005c50| 2e 20 20 46 72 6f 6d 20 | 74 68 65 20 44 61 74 61 |. From |the Data|
|00005c60| 62 61 73 65 20 62 6f 78 | 2c 20 73 65 6c 65 63 74 |base box|, select|
|00005c70| 20 74 68 65 20 64 61 74 | 61 62 61 73 65 20 74 68 | the dat|abase th|
|00005c80| 61 74 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 02 00 |at you w|ant to..|
|00005c90| 1a 15 18 04 61 64 64 20 | 74 68 65 20 75 73 65 72 |....add |the user|
|00005ca0| 20 74 6f 2e 02 00 1a 1a | 33 2e 20 20 43 68 6f 6f | to.....|3. Choo|
|00005cb0| 73 65 20 74 68 65 20 4f | 4b 20 62 75 74 74 6f 6e |se the O|K button|
|00005cc0| 2e 02 00 1b 34 2e 20 20 | 43 68 6f 6f 73 65 20 74 |....4. |Choose t|
|00005cd0| 68 65 20 41 64 64 20 62 | 75 74 74 6f 6e 2e 02 00 |he Add b|utton...|
|00005ce0| 30 35 2e 20 20 46 72 6f | 6d 20 74 68 65 20 4c 6f |05. Fro|m the Lo|
|00005cf0| 67 69 6e 20 49 44 20 62 | 6f 78 2c 20 73 65 6c 65 |gin ID b|ox, sele|
|00005d00| 63 74 20 74 68 65 20 6c | 6f 67 69 6e 20 49 44 2e |ct the l|ogin ID.|
|00005d10| 02 00 43 18 04 54 6f 20 | 61 73 73 69 67 6e 20 61 |..C..To |assign a|
|00005d20| 20 75 73 65 72 6e 61 6d | 65 20 74 68 61 74 20 69 | usernam|e that i|
|00005d30| 73 20 64 69 66 66 65 72 | 65 6e 74 20 66 72 6f 6d |s differ|ent from|
|00005d40| 20 74 68 65 20 6c 6f 67 | 69 6e 20 49 44 2c 20 74 | the log|in ID, t|
|00005d50| 79 70 65 02 00 32 18 04 | 74 68 65 20 75 73 65 72 |ype..2..|the user|
|00005d60| 6e 61 6d 65 20 69 6e 20 | 74 68 65 20 55 73 65 72 |name in |the User|
|00005d70| 6e 61 6d 65 20 69 6e 20 | 44 61 74 61 62 61 73 65 |name in |Database|
|00005d80| 20 62 6f 78 2e 02 00 3e | 36 2e 20 20 54 6f 20 61 | box...>|6. To a|
|00005d90| 73 73 69 67 6e 20 74 68 | 65 20 75 73 65 72 20 74 |ssign th|e user t|
|00005da0| 6f 20 61 6e 20 65 78 69 | 73 74 69 6e 67 20 67 72 |o an exi|sting gr|
|00005db0| 6f 75 70 2c 20 73 65 6c | 65 63 74 20 74 68 65 20 |oup, sel|ect the |
|00005dc0| 67 72 6f 75 70 02 00 1c | 18 04 66 72 6f 6d 20 74 |group...|..from t|
|00005dd0| 68 65 20 47 72 6f 75 70 | 6e 61 6d 65 20 62 6f 78 |he Group|name box|
|00005de0| 2e 02 00 1a 1a 37 2e 20 | 20 43 68 6f 6f 73 65 20 |.....7. | Choose |
|00005df0| 74 68 65 20 4f 4b 20 62 | 75 74 74 6f 6e 2e 02 00 |the OK b|utton...|
|00005e00| 01 02 00 32 02 1a 12 3a | 6e 20 41 64 64 69 6e 67 |...2...:|n Adding|
|00005e10| 20 61 20 47 72 6f 75 70 | 02 00 34 47 72 6f 75 70 | a Group|..4Group|
|00005e20| 73 20 70 72 6f 76 69 64 | 65 20 61 20 63 6f 6e 76 |s provid|e a conv|
|00005e30| 65 6e 69 65 6e 74 20 77 | 61 79 20 74 6f 20 67 72 |enient w|ay to gr|
|00005e40| 61 6e 74 20 61 6e 64 20 | 72 65 76 6f 6b 65 02 00 |ant and |revoke..|
|00005e50| 3f 70 65 72 6d 69 73 73 | 69 6f 6e 73 20 74 6f 20 |?permiss|ions to |
|00005e60| 6d 6f 72 65 20 74 68 61 | 6e 20 6f 6e 65 20 75 73 |more tha|n one us|
|00005e70| 65 72 2e 20 54 68 65 20 | 70 75 62 6c 69 63 20 67 |er. The |public g|
|00005e80| 72 6f 75 70 20 69 73 20 | 63 72 65 61 74 65 64 02 |roup is |created.|
|00005e90| 00 40 65 61 63 68 20 74 | 69 6d 65 20 61 20 64 61 |.@each t|ime a da|
|00005ea0| 74 61 62 61 73 65 20 69 | 73 20 63 72 65 61 74 65 |tabase i|s create|
|00005eb0| 64 2e 20 41 6c 6c 20 75 | 73 65 72 73 20 62 65 6c |d. All u|sers bel|
|00005ec0| 6f 6e 67 20 74 6f 20 74 | 68 65 20 70 75 62 6c 69 |ong to t|he publi|
|00005ed0| 63 02 00 40 67 72 6f 75 | 70 2e 20 49 6e 20 61 64 |c..@grou|p. In ad|
|00005ee0| 64 69 74 69 6f 6e 2c 20 | 65 61 63 68 20 75 73 65 |dition, |each use|
|00005ef0| 72 20 63 61 6e 20 62 65 | 20 61 73 73 69 67 6e 65 |r can be| assigne|
|00005f00| 64 20 74 6f 20 6f 6e 65 | 20 61 64 64 69 74 69 6f |d to one| additio|
|00005f10| 6e 61 6c 02 00 1a 17 67 | 72 6f 75 70 2e 20 54 6f |nal....g|roup. To|
|00005f20| 20 61 64 64 20 61 20 67 | 72 6f 75 70 3a 02 00 01 | add a g|roup:...|
|00005f30| 02 00 33 31 2e 20 20 46 | 72 6f 6d 20 74 68 65 20 |..31. F|rom the |
|00005f40| 41 64 6d 69 6e 20 6d 65 | 6e 75 2c 20 63 68 6f 6f |Admin me|nu, choo|
|00005f50| 73 65 20 4d 61 6e 61 67 | 65 20 47 72 6f 75 70 6e |se Manag|e Groupn|
|00005f60| 61 6d 65 73 2e 02 00 30 | 32 2e 20 20 46 72 6f 6d |ames...0|2. From|
|00005f70| 20 74 68 65 20 44 61 74 | 61 62 61 73 65 20 62 6f | the Dat|abase bo|
|00005f80| 78 2c 20 73 65 6c 65 63 | 74 20 74 68 65 20 64 61 |x, selec|t the da|
|00005f90| 74 61 62 61 73 65 2e 02 | 00 1a 1a 33 2e 20 20 43 |tabase..|...3. C|
|00005fa0| 68 6f 6f 73 65 20 74 68 | 65 20 4f 4b 20 62 75 74 |hoose th|e OK but|
|00005fb0| 74 6f 6e 2e 02 00 1b 34 | 2e 20 20 43 68 6f 6f 73 |ton....4|. Choos|
|00005fc0| 65 20 74 68 65 20 41 64 | 64 20 62 75 74 74 6f 6e |e the Ad|d button|
|00005fd0| 2e 02 00 39 35 2e 20 20 | 49 6e 20 74 68 65 20 41 |...95. |In the A|
|00005fe0| 64 64 20 61 20 47 72 6f | 75 70 6e 61 6d 65 20 62 |dd a Gro|upname b|
|00005ff0| 6f 78 2c 20 74 79 70 65 | 20 74 68 65 20 6e 61 6d |ox, type| the nam|
|00006000| 65 20 6f 66 20 74 68 65 | 20 6e 65 77 02 00 0b 18 |e of the| new....|
|00006010| 04 67 72 6f 75 70 2e 02 | 00 1a 1a 36 2e 20 20 43 |.group..|...6. C|
|00006020| 68 6f 6f 73 65 20 74 68 | 65 20 4f 4b 20 62 75 74 |hoose th|e OK but|
|00006030| 74 6f 6e 2e 02 00 01 02 | 00 9c 01 1c 3a 6e 20 41 |ton.....|....:n A|
|00006040| 64 64 69 6e 67 20 61 20 | 55 73 65 72 20 74 6f 20 |dding a |User to |
|00006050| 61 20 47 72 6f 75 70 02 | 00 1a 1a 54 6f 20 61 64 |a Group.|...To ad|
|00006060| 64 20 61 20 75 73 65 72 | 20 74 6f 20 61 20 67 72 |d a user| to a gr|
|00006070| 6f 75 70 3a 02 00 01 02 | 00 32 31 2e 20 20 46 72 |oup:....|.21. Fr|
|00006080| 6f 6d 20 74 68 65 20 41 | 64 6d 69 6e 20 6d 65 6e |om the A|dmin men|
|00006090| 75 2c 20 63 68 6f 6f 73 | 65 20 4d 61 6e 61 67 65 |u, choos|e Manage|
|000060a0| 20 55 73 65 72 6e 61 6d | 65 73 2e 02 00 30 32 2e | Usernam|es...02.|
|000060b0| 20 20 46 72 6f 6d 20 74 | 68 65 20 44 61 74 61 62 | From t|he Datab|
|000060c0| 61 73 65 20 62 6f 78 2c | 20 73 65 6c 65 63 74 20 |ase box,| select |
|000060d0| 74 68 65 20 64 61 74 61 | 62 61 73 65 2e 02 00 1a |the data|base....|
|000060e0| 1a 33 2e 20 20 43 68 6f | 6f 73 65 20 74 68 65 20 |.3. Cho|ose the |
|000060f0| 4f 4b 20 62 75 74 74 6f | 6e 2e 02 00 1b 34 2e 20 |OK butto|n....4. |
|00006100| 20 43 68 6f 6f 73 65 20 | 74 68 65 20 41 64 64 20 | Choose |the Add |
|00006110| 62 75 74 74 6f 6e 2e 02 | 00 30 35 2e 20 20 46 72 |button..|.05. Fr|
|00006120| 6f 6d 20 74 68 65 20 4c | 6f 67 69 6e 20 49 44 20 |om the L|ogin ID |
|00006130| 62 6f 78 2c 20 73 65 6c | 65 63 74 20 74 68 65 20 |box, sel|ect the |
|00006140| 6c 6f 67 69 6e 20 49 44 | 2e 02 00 3d 18 04 49 66 |login ID|...=..If|
|00006150| 20 74 68 65 20 75 73 65 | 72 6e 61 6d 65 20 69 73 | the use|rname is|
|00006160| 20 64 69 66 66 65 72 65 | 6e 74 20 66 72 6f 6d 20 | differe|nt from |
|00006170| 74 68 65 20 6c 6f 67 69 | 6e 20 49 44 2c 20 74 79 |the logi|n ID, ty|
|00006180| 70 65 20 74 68 65 02 00 | 2e 18 04 75 73 65 72 6e |pe the..|...usern|
|00006190| 61 6d 65 20 69 6e 20 74 | 68 65 20 55 73 65 72 6e |ame in t|he Usern|
|000061a0| 61 6d 65 20 69 6e 20 44 | 61 74 61 62 61 73 65 20 |ame in D|atabase |
|000061b0| 62 6f 78 2e 02 00 1a 1a | 36 2e 20 20 43 68 6f 6f |box.....|6. Choo|
|000061c0| 73 65 20 74 68 65 20 4f | 4b 20 62 75 74 74 6f 6e |se the O|K button|
|000061d0| 2e 02 00 01 02 00 67 01 | 1b 3a 6e 20 43 68 61 6e |......g.|.:n Chan|
|000061e0| 67 69 6e 67 20 61 20 55 | 73 65 72 27 73 20 47 72 |ging a U|ser's Gr|
|000061f0| 6f 75 70 02 00 1a 1a 54 | 6f 20 63 68 61 6e 67 65 |oup....T|o change|
|00006200| 20 61 20 75 73 65 72 27 | 73 20 67 72 6f 75 70 3a | a user'|s group:|
|00006210| 02 00 01 02 00 32 31 2e | 20 20 46 72 6f 6d 20 74 |.....21.| From t|
|00006220| 68 65 20 41 64 6d 69 6e | 20 6d 65 6e 75 2c 20 63 |he Admin| menu, c|
|00006230| 68 6f 6f 73 65 20 4d 61 | 6e 61 67 65 20 55 73 65 |hoose Ma|nage Use|
|00006240| 72 6e 61 6d 65 73 2e 02 | 00 30 32 2e 20 20 46 72 |rnames..|.02. Fr|
|00006250| 6f 6d 20 74 68 65 20 44 | 61 74 61 62 61 73 65 20 |om the D|atabase |
|00006260| 62 6f 78 2c 20 73 65 6c | 65 63 74 20 74 68 65 20 |box, sel|ect the |
|00006270| 64 61 74 61 62 61 73 65 | 2e 02 00 1a 1a 33 2e 20 |database|.....3. |
|00006280| 20 43 68 6f 6f 73 65 20 | 74 68 65 20 4f 4b 20 62 | Choose |the OK b|
|00006290| 75 74 74 6f 6e 2e 02 00 | 30 34 2e 20 20 46 72 6f |utton...|04. Fro|
|000062a0| 6d 20 74 68 65 20 55 73 | 65 72 6e 61 6d 65 20 62 |m the Us|ername b|
|000062b0| 6f 78 2c 20 73 65 6c 65 | 63 74 20 74 68 65 20 75 |ox, sele|ct the u|
|000062c0| 73 65 72 6e 61 6d 65 2e | 02 00 24 35 2e 20 20 43 |sername.|..$5. C|
|000062d0| 68 6f 6f 73 65 20 74 68 | 65 20 43 68 61 6e 67 65 |hoose th|e Change|
|000062e0| 20 47 72 6f 75 70 20 62 | 75 74 74 6f 6e 2e 02 00 | Group b|utton...|
|000062f0| 30 36 2e 20 20 46 72 6f | 6d 20 74 68 65 20 4e 65 |06. Fro|m the Ne|
|00006300| 77 20 47 72 6f 75 70 20 | 62 6f 78 2c 20 73 65 6c |w Group |box, sel|
|00006310| 65 63 74 20 61 20 6e 65 | 77 20 67 72 6f 75 70 2e |ect a ne|w group.|
|00006320| 02 00 1a 1a 37 2e 20 20 | 43 68 6f 6f 73 65 20 74 |....7. |Choose t|
|00006330| 68 65 20 4f 4b 20 62 75 | 74 74 6f 6e 2e 02 00 01 |he OK bu|tton....|
|00006340| 02 00 31 01 23 3a 6e 20 | 44 72 6f 70 70 69 6e 67 |..1.#:n |Dropping|
|00006350| 20 61 20 55 73 65 72 20 | 66 72 6f 6d 20 61 20 44 | a User |from a D|
|00006360| 61 74 61 62 61 73 65 02 | 00 26 54 6f 20 64 65 6c |atabase.|.&To del|
|00006370| 65 74 65 20 61 20 75 73 | 65 72 6e 61 6d 65 20 66 |ete a us|ername f|
|00006380| 72 6f 6d 20 61 20 64 61 | 74 61 62 61 73 65 3a 02 |rom a da|tabase:.|
|00006390| 00 01 02 00 32 31 2e 20 | 20 46 72 6f 6d 20 74 68 |....21. | From th|
|000063a0| 65 20 41 64 6d 69 6e 20 | 6d 65 6e 75 2c 20 63 68 |e Admin |menu, ch|
|000063b0| 6f 6f 73 65 20 4d 61 6e | 61 67 65 20 55 73 65 72 |oose Man|age User|
|000063c0| 6e 61 6d 65 73 2e 02 00 | 30 32 2e 20 20 46 72 6f |names...|02. Fro|
|000063d0| 6d 20 74 68 65 20 44 61 | 74 61 62 61 73 65 20 62 |m the Da|tabase b|
|000063e0| 6f 78 2c 20 73 65 6c 65 | 63 74 20 74 68 65 20 64 |ox, sele|ct the d|
|000063f0| 61 74 61 62 61 73 65 2e | 02 00 1a 1a 33 2e 20 20 |atabase.|....3. |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
