《SQL Server 7参考手册》求取 ⇩

第一部分 欢迎使用MicrosoftSQL Server73

1．1 Microsoft SQL Server的发展历史3

1．2 Microsoft SQL Server的将来4

1．3体系结构的改进5

1．4 Microsoft Transaction Server的到来7

1．5Enterprise一瞥8

第2章 容量的改进10

2．1打破内存障碍10

2．2太字节的存储容量12

2．3多个CPU16

2．4Char/Binary和Varchar/VarBinary的最大长度17

第3章 Microsoft管理控制台18

3．1增加Microsoft Management Console Snap-Ins18

3．2服务器的Enterprise Manager功能22

第4章 SQL Server Agent38

4．1定义操作员39

4．2创建作业41

4．3创建警告44

4．4多任务和多方案作业52

第5章 与Windows NT安全性的集成53

5．1Security Manager的消失53

5．2身份验证53

5．3许可的有效性57

5．4授予权限65

5．5实现安全性的若干建议72

5．6所有权链72

5．7xp-cmdshell72

第6章 Transact-SQL增强工具74

6．1增强的存储过程74

6．2新系统扩展存储过程79

6．3触发程序80

6．4新数据类型83

6．5数据存储增强功能83

6．6新的属性功能84

6．7新的安全性功能84

6．8其他新功能84

6．9查询的增强功能85

6．10新的优化程序提示86

6．11事务处理的增强功能86

6．12系统表的增强功能87

第7章 新工具和增强工具88

7．1SQL Server查询分析工具88

7．2数据转换服务工具90

7．3SQL Server Profiler93

7．4数据库维护计划向导95

7．5Web辅助向导97

7．6可视数据库工具（Database Tools）99

7．7Replication Monitor（复制监视工具）101

第8章 实用程序的变化103

8．1BCP103

8．2备份（Backup）107

8．3恢复（Restore）107

8．4数据库一致性检查程序（Database Consistency Checker）108

8．5OSQL和ISQL112

8．6SQLMAINT112

第9章 SQL Server7的复制增强116

9．1多点更新复制（Multi-site Update Replication）116

9．2合并复制（Merge Replication）117

9．3快照和数据转换服务120

9．4分区事务复制120

9．5更新订阅器121

9．6推、拉订阅122

9．7因特网复制增强123

9．8匿名拉回订阅123

9．9数据加密124

9．10在因特网上的保密：微软代理服务器124

9．11多机种环境数据复制服务126

9．12创建复制脚本126

第10章 简化数据库管理员的任务127

10．1自动和动态配置127

10．2动态结构管理131

第二部分 安装135

第11章 安装SQL Server135

11．1安装前的准备136

11．2安装选项和要求137

11．3缺省域138

11．4服务器标准145

11．5删除SQL Server146

11．6使用自动化安装的维护安装标准146

11．7远程安装146

第12章安装SQL Mail147

12．1WindowsNT消息服务147

12．2 SQL Mail的安装147

12．3SQL Mail先决条件147

12．4安装Microsoft Exchange邮件客户149

12．5解决SQL Mail启动失败的技巧150

12．6SQL Mail扩展存储过程150

12．7SQL Mail和SQL Server Agent151

第13章 升级SQL Server152

13．1何时升级152

13．2升级计划153

13．3升级之前153

13．4版本升级实用程序154

13．5复制和升级158

13．6升级后的工作159

第三部分 管理163

第14章 数据库管理163

14．1管理工具集163

14．2系统存储过程163

14．3系统表164

14．4SQL错误和错误日志166

14．5驱动器管理170

14．6移动数据库171

14．7重建SQL Server172

14．8管理关键任务的应用程序172

14．9管理特大型数据库173

14．10启动和终止SQL Server173

14．11归档处理175

第15章 数据库的预防性维护177

15．1更新统计177

15．2数据库一致性检查器178

15．3可疑的数据库181

15．4遵守标准182

15．5备份方法183

第16章 链接服务器和远程服务器189

16．1Microsoft分布式事务协调器189

16．2两阶段提交190

16．3分布式事务192

16．4链接服务器193

16．5如何定义远程服务器193

16．6使用远程登录访问远程服务器194

第17章 监测服务器性能的工具196

17．1SQL Server Ptofiler196

17．2SQL Server性能监视器202

第四部分 开发——编程语言209

第18章 开发话题209

18．1数据库图表209

18．2数据完整性209

18．3设计数据库211

18．4如何创建数据库215

18．5特大型数据库（VLDB）216

18．6编码技巧216

18．7索引217

18．8分区218

18．9并发性218

第19章 Transact-SQL的使用220

19．1编写查询语句220

19．2编写存储过程221

19．3编写触发器223

19．4快捷、大型的输入/输出224

19．5多索引查询225

19．6查询处理器225

19．7SHOWPLAN225

19．8表格连接226

19．9Tempdb228

19．10游标228

19．11重新编译存储过程229

19．12异构型分布式查询230

第20章 数据仓库和数据市场231

20．1星型模式231

20．2数据市场232

20．3Microsoft OLAP Server233

第21章 Transact-SQL编程语言参考237

加号（+）和字符串连接（+）237

第五部分 参考素材237

减号（－）238

乘号（*）238

除号（/）239

模及通配符（％）239

按位与操作（＆）240

按位或操作（?）240

按位异或操作（＾）241

按位非操作（～）241

等于（＝）242

大于（＞）242

小于（＜）242

大于或等于（＞＝）243

小于或等于（＜＝）243

不等于（＜＞）243

不等于（！＝）244

不小于（！＜）244

不大于（(＞）245

注释（--）245

注释（((?((）245

匹配的通配符（((）246

不匹配的通配符（(((）247

一个字符匹配的通配符（(）247

@@connections248

@@cpu(busy248

@@cursor(rows248

@@datefirst249

@@dbts249

@@error249

@@fetch(status249

@@io(busy250

@@idle250

@@identity250

@@LANGID251

@@language251

@@lock(timeout251

@@max(connections251

@@max(precision251

@@nestlevel252

@@options252

@@pack(received252

@@pack(sent252

@@packet(errors252

@@procid252

@@spid253

@@timeticks253

@@textsize253

@@servername253

@@servicename253

@@rowcount253

@@remserver253

@@total(errors254

@@total(read254

@@total(write254

@@trancount254

@@version254

ABS254

ACOS255

ALL255

ALTER DATABASE255

ALTER PROCEDURE257

ALTER TABLE258

ALTER TRIGGER263

AND265

ALTER VIEW265

ANY266

APP(NAME266

ASCII267

ASIN267

ATAN267

ATN2268

AVG268

BACKUP269

BEGIN?END274

BEGIN DISTRIBUTED TRANSACTION274

BEGIN TRANSACTION275

BETWEEN275

BREAK276

BULK INSERT276

bit276

binary276

CASE278

CAST279

CEILILING280

字符数据类型280

CHAR字符串函数280

CHARINDEX字符串函数281

CHECKPOINT281

CLOSE282

COALESCE282

COL(LENGTH282

COL(NAME283

COLUMNPROPERTY283

COMMIT［WORK］284

CONTAINS284

COMMIT TRANS［ACTION］284

CONTAINSTABLE287

CONTINUE288

CONVERT288

COS290

COT290

COUNT290

CREATE DATABASE290

CREATE DEFAULT293

CREATE INDEX293

CREATE PROCEDURE296

CREATE RULE297

CREATE SCHEMA298

CREATE TABLE299

CREATE TRIGGER302

CREATE VIEW304

CURRENT(TIMESTAMP304

CURRENT(USER305

游标数据类型305

CURSOR(STATUS305

cursors306

DATABASEPROPERTY306

数据类型307

DATALENGTH309

DATEADD310

日期函数310

DATEDIFF311

DATENAME311

DATEPART311

DB(NAME312

DB(ID312

DAY312

DBCC CHECKALLOC313

DBCC CHECKCATALOG313

DBCC CHECKDB314

DBCC CHECKFILEGROUP314

DBCC CHECKIDENT315

DBCC CHECKTABLE315

DBCC DBREPAIR316

DBCC DBREINDEX316

DBCC dllname（FREE）317

DBCC HELP317

DBCC INPUTBUFFER317

DBCC MEMUSAGE317

DBCC OPENTRAN318

DBCC OUTPUTBUFFER318

DBCC NEWALLOC318

DBCC PERFMON319

DBCC PINTABLE319

DBCC PROCCACHE319

DBCC ROWLOCK319

DBCC SHOWCONTIG319

DBCC SHOW(STATISTICS320

DBCC SHRINKDATABASE320

DBCC SHRINKFILE320

DBCC TEXTALL321

DBCC SQLPERF321

DBCC TEXTALL321

DBCC TEXTALLOC321

DBCC UPDATEUSAGE322

DBCC UNPINTABLE322

DBCC TRACESTATUS322

DBCC TRACEOFF322

DBCC TRACEON322

DBCC USEROPTIONS323

DEALLOCATE323

十进制数据类型323

DECLARE@local(variable324

DECLARE CURSOR324

DEGREES326

DEGLETE326

DENY328

DIFFERENCE329

DROP DATABASE329

DROP INDEX330

DROP PROCEDURE330

DROP DEFAULT330

DROP RULE331

DROP STATISTICS331

DROP TABLE331

DROP TRIGGER331

DROP VIEW332

DUMP332

ELSE（IF?ELSE）332

END（BEGIN?END）333

EXECUTE333

(NOT (EXISTS334

EXP335

FETCH335

FILE(ID335

FILEPROPERTY336

FILEGROUPPROPERTY336

FILEGROUP(NAME336

FILE(NAME336

FILEGROUP(ID336

浮点数和实数337

FLOOR337

FORMATMESSAGE337

FREETEXT337

FREETEXTTABLE338

FROM338

FULLTEXTCATALOGPROPERTY340

FULLTEXTSERVICEPROPERTY341

GETANSINULL341

GETDATE341

GROUPING342

HOST(ID342

HAVING342

GRANT342

GROUP BY342

GOTO342

GO342

HOST (NAME343

IDENT(INCR343

IDENT(SEED343

IDENTITY343

IF?ELSE343

IN343

INDEXPROPERTY344

INDEX(COL344

INSERT345

int,smallint,tinyint346

ISDATE347

IS［NOT］NULL347

IS(MEMBER347

IS(SRVROLEMEMBER347

ISNULL348

ISNUMERIC348

KILL348

LEFT348

LEN349

LIKE349

LOAD349

LOG349

LOG10349

LOWER350

LTRIM350

MAX350

MIN350

NEWID351

nchar和nvarchar351

NOT351

money和samllmoney351

NCHAR351

MONTH351

ntext,text和image352

NULLIF352

numeric352

OBJECT(ID352

OBJECT(NAME352

OBJECTPROPERTY352

OPEN353

OPENQUERY353

OPENROWSET354

PATINDEX355

PARSENAME355

OR355

ORDER BY355

PERMISSIONS356

PI357

POWER357

PRINT357

QUOTENAME357

RADIANS358

RAISERROR358

RAND360

READTEXT360

实型360

RECONFIGURE360

REPLACE361

RESTORE362

REPLICATE362

RESTORE FILELISTONLY367

RESTORE HEADERONLY368

RESTORE LABELONLY368

RESTORE VERIFYONLY368

RETURN369

REVERSE370

REVOKE370

REGHT370

ROLLBACK TRANSACTION370

ROLLBACK WORK371

ROUND371

RTRIM371

SAVE TRANSACTION372

SELECT372

SET@local(variable380

SESSION(USER380

SET381

SET ANSI(DEFAULTS381

SET ANSI(NULL(DFLT(OFF381

SET ANSI(NULL(DFLT(ON382

SET ANSI(NULLS382

SET ANSI(PADDING382

SET ANSI(WARNINGS382

SET ARITHABORT383

SET ARITHIGNORE383

SET CONCAT(NULL(YIELDS(NULL383

SET CURSOR(CLOSE(ON(COMMIT383

SET DATEFIRST383

SET DATEF ORMAT383

SET FMTONLY384

SET FORCEPLAN384

SET DISABLE(DEF(CNST(CHK384

SET FIPS(FLAGGER384

SET DEADLOCK(PRIORITY384

SET IDENTITY(INSERT385

SET IMPLICIT(TRANSACTIONS385

SET LANGUAGE385

SET LOCK(TIMEOUT385

SET NOCOUNT385

SET NOEXEC386

SET NUMERIC(ROUNDABORT386

SET OFFSETS386

SET PARSEONLY386

SET PROCID386

SET QUERY(GOVERNOR(COST(LIMIT386

SET SHOWPLAN(TEXT387

SET SHOWPLAN(ALL387

SET REMOTE(PROC(TRANSACTIONS387

SET QUOTED(IDENTIFIER387

SET ROWCOUNT387

SET STATISTICS IO388

SET STATISTICS PROFILE388

SET STATISTICS TIME388

SET TEXTSIZE388

SET TRANSCATION ISOLATION LEVEL388

SET XACT(ABORT389

SETUSER389

smalldatetime390

smallmoney390

smallint390

SOME?ANY390

SIN390

SIGN390

SHUTDOWN390

SOUNDEX391

SPACE391

SQUARE391

STDEVP392

STDEV392

STATS(DATE392

SQRT392

STR393

STUFF393

SUBSTRING393

SUM394

SUSER(ID394

SUSER(NAME394

TEXTPTR395

TAN395

text395

SYSTEM(USER395

SUSER(SNAME395

SUSER(SID395

TEXTVALID396

timestamp396

tinyint396

TRIGGER(NESTLEVEL396

TRUNCATE TABLE396

TYPEPROPERTY396

UNICODE397

UNION397

uniqueidentifier398

UPDATE398

UPDATE STATISTICS401

UPDATETEXT402

UPPER403

USE404

USER404

USER(ID404

USER(NAME404

VAR404

varbinary404

varchar404

VARP405

WAITFOR405

WHERE405

WHILE405

WRITETEXT406

YEAR407

22．1系统表408

第22章 系统表408

22．1．2backupmediafamily409

22．1．1 backupfile409

22．1．3backupmediaset410

22．1．4backupset410

22．1．5MSagent(parameters410

22．1．6MSagent(profiles411

22．1．7MSarticles411

22．1．8MSdistpublishers411

22．1．9MSdistributiondbs411

22．1．10MSdistrbution(agents411

22．1．13MSlogreader(agents412

22．1．14MSlogreader(history412

22．1．12MSdistributor412

22．1．11MSdistribution(history412

22．1．15MSmerge(contents413

22．1．16MSmerge(delete(conflicts413

22．1．17MSmerge(genhistory413

22．1．18MSmerge(history413

22．1．19MSmerge(replinfo414

22．1．20MSmerge(subscriptions414

22．1．21MSmerge(tombstone414

22．1．22MSpublication(access414

22．1．23MSpublications415

22．1．24MSpublisher(databases415

22．1．25MSreplication(objects415

22．1．26MSreplication(subscriptions415

22．1．27MSrepl(commands415

22．1．31MSrepl(version416

22．1．30MSrepl(transaction416

22．1．32MSsnapshot(agents416

22．1．28MSrepl(errors416

22．1．29MSrepl(originators416

22．1．33MSsnapshot(history417

22．1．34MSsubscriber(info417

22．1．35MSsubscriber(schedule417

22．1．36MSsubscriptions417

22．1．37MSsubscription(properties418

22．1．38restorefile418

22．1．39restorefilegroup418

22．1．40restorehistory418

22．1．41sysalerts419

22．1．42sysallocations419

22．1．43sysaltfiles419

22．1．44sysarticles419

22．1．47syscharsets420

22．1．48syscolumns420

22．1．46syscategories420

22．1．45sysarticleupdates420

22．1．49syscomments421

22．1．50sysconfigures421

22．1．51sysconstraints421

22．1．52syscurconfigs421

22．1．53sysdatabases422

22．1．54sysdepends422

22．1．55sysdevices422

22．1．56sysdownloadlist422

22．1．57sysfiles423

22．1．58sysfilegroups423

22．1．59sysforeignkeys423

22．1．60sysfulltextcatalogs423

22．1．61sysindexes423

22．1．64sysjobschedules424

22．1．62sysindexkeys424

22．1．63sysjobhistory424

22．1．65sysjobs425

22．1．66sysjobservers425

22．1．67sysjobsteps425

22．1．68syslanguages426

22．1．69sysylockinfo426

22．1．70syslogins426

22．1．71sysmembers427

22．1．72sysmergearticles427

22．1．73sysmergepublications427

22．1．74sysmergeschemachange427

22．1．77sysmessages428

22．1．78sysnotifications428

22．1．79sysobjects428

22．1．75sysmergesubscriptions428

22．1．76sysmergesubsetfilters428

22．1．80sysoledbusers429

22．1．81sysoperators429

22．1．82sysperfinfo429

22．1．85sysprotects430

22．1．86syspublications430

22．1．84sysprocesses430

22．1．83syspermissions430

22．1．87sysreferences431

22．1．88sysremotelogins431

22．1．89sysreplicationalerts432

22．1．90sysservers432

22．1．91syssubscriptions432

22．1．92systargetservergroupmembers432

22．1．93systargetservergroups432

22．1．97sysusers433

22．1．96systypes433

22．1．94systargetservers433

22．1．95systaskids433

22．2信息模式视图434

22．2．1CHECK(CONSTRAINTS434

22．2．2COLUMN(DOMAIN(USAGE434

22．2．3COLUMN(PRIVILEGES434

22．2．4COLUMNS435

22．2．5CONSTRAINT(COLUMN(USAGE435

22．2．6CONSTRAINT(TABLE(USAGE435

22．2．7DOMAIN(CONSTRAINTS436

22．2．8DOMAINS436

22．2．11SCHEMATA437

22．2．12TABLE(CONSTRAINTS437

22．2．10REFERENTIAL(CONSTRAINTS437

22．2．9KEY(COLUMN(USAGE437

22．2．13TABLE(PRIVILEGES438

22．2．14TABLES438

22．2．15VIEW(COLUMN(USAGE438

22．2．16VIEW(TABLE(USAGE439

22．2．17VIEWS439

sp(add(agent(parameter440

22．3系统存储过程440

sp(add(agent(profile441

sp(add(alert441

sp(adddlias442

sp(addapprole442

sp(addarticle443

sp(adddistpublisher445

sp(adddistributiondb446

sp(addextendedproc448

sp(addgroup448

sp(adddistributor448

sp(add(category449

sp(add(job449

sp(add(jobschedule450

sp(add(jobserver452

sp(add(jobstep452

sp(addlinkedserver454

sp(addlinkedsrvlogin456

sp(addlogin457

sp(addmergearticle457

sp(addmergefilter459

sp(addmergepublication460

sp(addmergepullsubscription461

sp(addmergepullsubscription(agent461

sp(addmergesubscription464

sp(addmessage466

sp(add(notification467

sp(add(operator467

sp(addpublication468

sp(addpublication(snapshot470

sp(addpublisher70471

sp(addpullsubscription472

sp(addpullsubscription(agent472

sp(addremotelogin475

sp(addrole475

sp(addrolemember475

sp(addserver476

sp(addsrvrolemember476

sp(addsubscriber476

sp(addsubscriber(schedule478

sp(addsubscription479

sp(addtype482

sp(addtask482

sp(addsynctriggers482

sp(add(targetservergroup483

sp(addumpdevice483

sp(add(targetsvrgrp(member484

sp(aduser484

sp(altermessage484

sp(apply(job(to(targets485

sp(approlepassword485

sp(article(validation486

sp(articlecolumn486

sp(articlefilter487

sp(articlesynctranprocs487

sp(attach(db488

sp(attach(single(file(db488

sp(articleview488

sp(autostats489

sp(bindefault489

sp(bindrule489

sp(bindsession490

sp(browsereplcmds490

sp(catalogs491

sp(certify(removable491

sp(change(agent(parameter491

sp(change(agent(profile492

sp(changearticle492

sp(changedbowner493

sp(changedistpublisher494

sp(changedistributiondb494

sp(changegroup495

sp(changemergearticle495

sp(changedistributor (property495

sp(changedistributor(password495

sp(changemergefilter497

sp(changemergepublication497

sp(changemergepullsubscription498

sp(changemergesubscription499

sp(changeobjectowner500

sp(changepublication500

sp(changesubscriber501

sp(changesubscriber(schedule503

sp(changesubstatus504

sp(shange(subscription(properties506

sp(change(users(login507

sp(column(privileges507

sp(columns508

sp(columns (ex508

sp(column(privileges(ex508

sp(configure509

sp(createstats509

sp(create(removable510

sp(cursor(list511

sp(cycle(errorlog511

sp(databases511

sp(datatype(info511

sp(dboption512

sp(dbremove512

sp(dbcmptlevel512

sp(dbfixedrolepermission512

sp(desauldb513

sp(defaultlanguage513

sp(delete(alert513

sp(delete(category513

sp(delete(jobserver514

sp(delete(job514

sp(delte(jobschedule514

sp(delete(jobstep515

sp(delete(notification515

sp(delete(operator515

sp(delete(targetserver516

sp(delete(targetservergroup516

sp(delete(targetsvrgrp(member516

sp(deletemergeconflictrow516

sp(denylogin517

sp(depends517

sp(describe(cursor517

sp(describe(cursor(columns518

sp(describe(cursor(tables518

sp(drop(agent(profile519

sp(drop(agent(parameter519

sp(distcounters519

sp(detach(db519

sp(dropalias520

sp(dropapprole520

sp(droparticle520

sp(dropdevice520

sp(dropdistpublisher521

sp(dropdistributiondb521

sp_dropdistributor521

sp(dropextendedproc521

sp(dropgroup521

sp(droplinkedsrvlogin522

sp(droplogin522

sp(dropmergerarticle522

sp(dropmergefilter522

sp(dropmergesubscription523

sp(dropmergepullsubscription523

sp(dropmergepublication523

sp(dropmessage524

sp(droppublication524

sp(droppullsubscription524

sp(dropremotelogin525

sp(droprole525

sp(droprolemember525

sp(dropserver526

sp(dropsrvrolemember526

sp(dropsubscriber526

sp(dropsubscription527

sp(droptask527

sp(dropwebtask528

sp(dsninfo528

sp(dropuser528

sp(droptype528

sp(enumcodepages529

sp(enumcustomresolvers529

sp(enumdsn529

sp(enumfullsubscribers529

sp(exeeutesql529

sp(foreignkeys530

sp(fkeys530

sp(fulltext(catalog531

sp(fulltext(column532

sp(fulltext(database532

sp(fulltext(service532

sp(fulltext(table533

sp(generatefilters533

sp(grant(publication(access534

sp(get(distributor534

sp(getmergedeletetype534

sp(getbindtoken534

sp(grantdbaccess535

sp(grantlogin535

sp(help535

sp(help(agent(default536

sp(help(agent(parameter536

sp(help(agent(profile536

sp(help(alert536

sp(helparticle537

sp(helparticlecolumns537

sp(help(category537

sp(helpdbfixedrole538

sp(helpdistpublisher538

sp(helpdevice538

sp(helpdb538

sp(helpconstraint538

sp(helpdistributiondb539

sp(helpdistributor539

sp(help(downloadlist539

sp(helpextendedproc540

sp(helpfile540

sp(helpfilegroup540

sp(help(fulltext(catalogs540

sp(help(fulltext(catalogs(cursor541

sp(help(fulltext(columns541

sp(help(fulltext(tables541

sp(help(fulltext(tables(cursor542

sp(help(fulltext(columns(cursor542

sp(helpgroup542

sp(help(job543

sp(helpistory543

sp(help(jobhistory544

sp(help(jobschedule545

sp(help(jobserver545

sp(help(jobstep546

sp(helpindex546

sp(helplanguage546

sp(heplinkedsrvlogin547

sp(helplogins547

sp(helpmergearticle547

sp(helpmergearticleconflicts547

sp(helpmergeconflictrows547

sp(helpmergedeleteconflictrows548

sp(helpmergefilter548

sp(helpmergepublication548

sp(helpmergesubscription549

sp(helpmergepullsubscription549

sp(help(notification550

sp(helpntgroup550

sp(help(operator551

sp(helppublication551

sp(help(publication(access551

sp(helppublication(snapshot551

sp(helppullsubscription552

sp(helpremotelogin552

sp(helpreplicationdb552

sp(helprelicationdboption553

sp(helpreplicationoption553

sp(helprole553

sp(helprolemember553

sp(helprotect553

sp(helpsort554

sp(helpserver554

sp(helpsrvrole555

sp(helpsrvrolemember555

sp(helpsubscriber555

sp(helpsubscriberinfo555

sp(helpsubscription555

sp(helpsubscription(properties556

sp(help(targetserver556

sp(help(targetservergroup557

sp(helptask557

sp(helptext557

sp(helptrigger557

sp(indexes558

sp(indexoption558

sp(lock559

sp(linkedservers559

sp(link(publication559

sp(makewebtask560

sp(manage(jobs(by(login563

sp(mergedummyupdate564

sp(mergesubscription(cleanup564

sp(monitor564

sp(msx(defect564

sp(msx(enlist565

sp(OACreate565

sp(OADestroy566

sp(OAGetErrorInfo566

sp(OAGetProperty567

sp(OAMethod567

sp(primarykeys568

sp(pkeys568

sp(password568

sp(OAStop568

sp(post(msx(operation569

sp(processmail569

sp(procoption570

sp(publication(validation570

sp(purgehistory571

sp(purge(jobhistory571

sp(reassigntask571

sp(recompile571

sp(refreshsubscriptions571

sp(refreshview572

sp(reinitmergepullsubscription572

sp(reinitmergesubscription572

sp(reinitpullsubscription572

sp(remoteoption573

sp(reinitsubscription573

sp(removedbreplication574

sp(remove(job(from(targets574

sp(rename574

sp(renamedb575

sp(replcmds575

sp(replcounters575

sp(repldone576

sp_replflush576

sp(replicationdboption576

sp(replicationoption577

sp(replication(agent(checkup577

sp(revokedbaccess578

sp(resync(targetserver578

sp(revoke(publication(access578

sp(repltrans578

sp(replshowcmds578

sp(revokelogin579

sp(runwebtask579

sp(script(synctran(commands579

sp(scriptdelproc579

sp(scriptinsproc580

sp(scriptuqdproc580

sp(server(info580

sp(serveroption580

sp(setapprole581

sp(setnetname581

sp(spaceused581

sp(sproc(columns582

sp(special(columns582

sp(srvrolepermission583

sp(start(job583

sp(statistics583

sp(stop(job584

sp(stored(procedures584

sp(subscription(cleanup585

sp(table(privileges585

sp(table(privileges(ex585

sp(table(validation586

sp(tableoption586

sp(tables587

sp(tables(ex587

sp(unbindefault588

sp(unbindrule588

sp(update(alert588

sp(update(job590

sp(updatecategory590

sp(update(jobschedule592

sp(update(jobstep593

sp(update(notification595

sp(update(operator595

sp(updatestats597

sp(update(targetservergroup597

sp(updatetask597

sp(validname597

sp(validatelogins597

sp(who598

xp(cmdshell598

xp(deletemail598

xp(enumgroups598

xp(findnextmsg598

xp(logevent599

xp(grantlogin599

xp(loginconfig600

xp(logininfo600

xp(msver600

xp(readmail600

xp(revokelogin602

xp(sendmail602

xp(snmp(getstate603

xp(snmp(raisetrap604

xp(sprintf604

xp(sqlinventory605

xp(sqlmaint605

xp(sscanf605

xp(startmail606

xp(stopmail606

附录A 安装前要准备的检测表607