sqlserver.ini

本人使用SQL SERVER 数据库3年

[---------------------------- table of contents ------------------]

[Contents]
Welcome=1
	Intro=2
	DemoOverview=2
	Setup=2
		Connect1=3
		CreateDB1=3
		PopulateDB1=3
		PopulateDB2=3
		RunLE=3
ManageDB=1
	RtmOverview=2
		RtmDoit=3
	Analyze=2
		Analyze2=3
	Solve=2
		SolveSetup=3
		Detective=3
		Culprit=3
		NoLogExplorer=3
	Audit=2
		AuditChanges=3
		AuditSchema=3
		AuditUsers=3
		AuditExport=3
RecoverRepair=1
	RestoreRow=2
		ViewChanges=3
		ApplyChanges=3
	UndoTransTop=2
		RunTrans=3
		UndoTrans=3
		UndoTransRecover=3
	RecoverTableTop=2
		DropTable=3
		RecoverDroppedTable=3
WrappingUp=1
	FAQ=2
	Cleanup=2
	Questions=2



[------------------- General ----------------------]

[General]
TestDB=LumigentDemoDB
NumSections=31
MaxTabColumns=15;
MaxColumnLen=256
CreateSchemaScript=SqlServer\scripts\CreateSchema.txt
RemoveSchemaScript=SqlServer\scripts\RemoveSchema.txt
Helpfile=SqlServer\pages\Helpfile.htm

[------------------- Test database definitions --------------------]

[Employees]
Columns=4
ColumnNames=EmpID|Last|Firs|PayRate

[Customers]
Columns=8
ColumnNames=CustID|Last|First|Address|City|Region|PostalCode|Country

[Service]
Columns=6
ColumnNames=ServID|CustID|EmpID|ServPrice|ServName|ServDate


[------------------- Page Definitions --------------------]

[Welcome]
Name=Welcome
MainText=SqlServer\pages\Welcome.htm
Highlights=SqlServer\pages\xWelcome.htm


[Intro]
Name=Introduction
MainText=SqlServer\pages\Introduction.htm
Highlights=SqlServer\pages\xIntroduction.htm

[DemoOverview]
Name=Guided Tour Overview
MainText=SqlServer\pages\DemoOverview.htm
Highlights=SqlServer\pages\xDemoOverview.htm
Depends=Introduction

[Setup]
Name=Setup/Initialize
MainText=SqlServer\pages\Setup.htm
Highlights=SqlServer\pages\xSetup.htm
Depends=DemoOverview

[Connect1]
Name=Connect Server
MainText=SqlServer\pages\ConnectPre.htm
Highlights=SqlServer\pages\xConnectPre.htm
Connect=yes
Depends=Setup

[CreateDB1]
Name=Create Demo Database
MainText=SqlServer\pages\CreateSchemaPre.htm
Highlights=SqlServer\pages\xCreateSchemaPre.htm
BuildSchema=yes
Depends=Connect1

[PopulateDB1]
Name=Populate Demo Database
MainText=SqlServer\pages\PopulateTable.htm
Highlights=SqlServer\pages\xPopulateTable.htm
Script=SqlServer\scripts\PopulateTable.txt
Depends=CreateDB1

[PopulateDB2]
Name=View Sample Data
MainText=SqlServer\pages\PopulateTablePost.htm
Highlights=SqlServer\pages\xPopulateTablePost.htm
Query=Customers
Depends=PopulateDB1

[RunLE]
Name=Run Log Explorer
MainText=SqlServer\pages\RunLogExplorer.htm
Highlights=SqlServer\pages\xRunLogExplorer.htm
Query=Customers
Depends=PopulateDB2

[ManageDB]
Name=Manage Your Databases
MainText=SqlServer\pages\Manage.htm
Highlights=SqlServer\pages\xManage.htm
Depends=RunLE

[RtmOverview]
Name=Monitor Transactions in Real Time
MainText=SqlServer\pages\RealTimeMonitor.htm 
Highlights=SqlServer\pages\xRealTimeMonitor.htm 
Depends=ManageDB

[RtmDoit]
Name=Real Time Monitor Example 
MainText=SqlServer\pages\RealTimeMonitorExample.htm 
Highlights=SqlServer\pages\xRealTimeMonitorExample.htm 
Script=SqlServer\scripts\RTMLoop.txt
Query=Customers
Depends=RtmOverview
Redo=1

[Analyze]
Name=Analyze Performance
Query=Customers
MainText=SqlServer\pages\AnalyzeBehavior.htm
Highlights=SqlServer\pages\xAnalyzeBehavior.htm
Depends=RtmDoIt

[Analyze2]
Name=View Performance Information
Query=Customers
MainText=SqlServer\pages\Analyze2.htm
Highlights=SqlServer\pages\xAnalyze2.htm
Depends=Analyze

[Solve]
Name=Solve Problems
MainText=SqlServer\pages\Solve.htm
Highlights=SqlServer\pages\xSolve.htm
Depends=Analyze2

[SolveSetup]
Name=Define the Problem
MainText=SqlServer\pages\SolveSetup.htm
Highlights=SqlServer\pages\xSolveSetup.htm
Depends=Solve
Script=SqlServer\scripts\AuditApp.txt
Query=Service

[Detective]
Name=Doing the Detective Work
MainText=SqlServer\pages\FindProblem.htm
Highlights=SqlServer\pages\xFindProblem.htm
Depends=SolveSetup
Query=Service

[Culprit]
Name=Identifying the Culprit
MainText=SqlServer\pages\FindProblem2.htm
Highlights=SqlServer\pages\xFindProblem2.htm
Depends=Detective
Query=Service

[NoLogExplorer]
Name=Solving Without Log Explorer?
MainText=SqlServer\pages\NoLogExplorer.htm
Highlights=SqlServer\pages\xNoLogExplorer.htm
Depends=Culprit
Query=Service

[Audit]
Name=Audit Your Database
MainText=SqlServer\pages\Audit.htm
Highlights=SqlServer\pages\xAudit.htm
Depends=NoLogExplorer

[AuditChanges]
Name=Audit Data Changes
MainText=SqlServer\pages\AuditChanges.htm
Highlights=SqlServer\pages\xAuditChanges.htm
Depends=Audit

[AuditSchema]
Name=Audit Schema & Permission Changes
MainText=SqlServer\pages\AuditSchema.htm
Highlights=SqlServer\pages\xAuditSchema.htm
Depends=AuditChanges


[AuditUsers]
Name=Audit User Activity
MainText=SqlServer\pages\AuditUsers.htm
Highlights=SqlServer\pages\xAuditUsers.htm
Depends=AuditSchema

[AuditExport]
Name=Export and Report
MainText=SqlServer\pages\AuditExport.htm
Highlights=SqlServer\pages\xAuditExport.htm
Depends=AuditUsers

[RecoverRepair]
Name=Recovery and Repair
MainText=SqlServer\pages\RecoverRepair.htm
Highlights=SqlServer\pages\xRecoverRepair.htm
Depends=RunLE

[RestoreRow]
Name=Restore Row
MainText=SqlServer\pages\RestoreRow.htm
Highlights=SqlServer\pages\xRestoreRow.htm
Depends=RecoverRepair
Script=SqlServer\scripts\CreateUpdate.txt
Query=Customers

[ViewChanges]
Name=View Changes and Restore Row
MainText=SqlServer\pages\ViewAndRestore.htm
Highlights=SqlServer\pages\xViewAndRestore.htm
Query=Customers
Depends=RestoreRow

[ApplyChanges]
Name=Apply Changes and View Results
MainText=SqlServer\pages\ApplyAndView.htm
Highlights=SqlServer\pages\xApplyAndView.htm
Query=Customers
Depends=ViewChanges

[UndoTransTop]
Name=Undo Transaction
MainText=SqlServer\pages\UndoTransaction.htm
Highlights=SqlServer\pages\xUndoTransaction.htm
Depends=RecoverRepair

[RunTrans]
Name=Run Complex Transaction
MainText=SqlServer\pages\ComplexTrans.htm
Highlights=SqlServer\pages\xComplexTrans.htm
Script=SqlServer\scripts\ComplexTrans.txt
Depends=UndoTransTop

[UndoTrans]
Name=Undo Bad Transaction
MainText=SqlServer\pages\UndoTransLE.htm
Highlights=SqlServer\pages\xUndoTransLE.htm
Depends=RunTrans
Query=Customers

[UndoTransRecover]
Name=Apply Recovery and View Results
MainText=SqlServer\pages\ApplyUndoTrans.htm
Highlights=SqlServer\pages\xApplyUndoTrans.htm
Depends=UndoTrans
Query=Customers

[RecoverTableTop]
Name=Recover Dropped Table
MainText=SqlServer\pages\RecoverTableTop.htm
Highlights=SqlServer\pages\xRecoverTableTop.htm
Depends=RecoverRepair

[DropTable]
Name=Drop Table
MainText=SqlServer\pages\DropTableDoit.htm
Highlights=SqlServer\pages\xDropTableDoit.htm
Depends=CreateBackup
Script=SqlServer\scripts\DropCustomerTable.txt

[RecoverDroppedTable]
Name=Recover Table
MainText=SqlServer\pages\RecoverDroppedTable.htm
Highlights=SqlServer\pages\xRecoverDroppedTable.htm
Depends=DropTable

[WrappingUp]
Name=Wrapping Up
MainText=SqlServer\pages\wrapup.htm
Highlights=SqlServer\pages\xwrapup.htm
Depends=RecoverDroppedTable

[FAQ]
Name=Frequently Asked Questions
MainText=SqlServer\pages\faq.htm
Highlights=SqlServer\pages\xfaq.htm
Depends=WrappingUp

[Cleanup]
Name=Cleanup and More Information
MainText=SqlServer\pages\Cleanup.htm 
Highlights=SqlServer\pages\xCleanup.htm 
Redo=1

[Questions]
Name=Thank You!
MainText=SqlServer\pages\thanks.htm
Highlights=SqlServer\pages\xthanks.htm