T-SQL存储过程和表引用PDF电子书下载

第1章 Transact-SQL概述 1

第2章 Transact-SQL的新特性和增强功能 6

第3章 信息架构视图 10

3.1 信息架构视图概述 10

3.2 信息架构视图的引用 11

3.2.1 CHECK_CONSTRAINTS 11

3.2.2 COLUMN_DOMAIN_USAGE 11

3.2.3 COLUMN_PRIVILEGES 12

3.2.4 COLUMNS 12

3.2.6 CONSTRAINT_TABLE_USAGE 14

3.2.5 CONSTRAINT_COLUMN_USAGE 14

3.2.7 DOMAIN_CONSTRAINTS 15

3.2.8 DOMAINS 16

3.2.9 KEY_COLUMN_USAGE 17

3.2.10 PARAMETERS 17

3.2.11 REFERENTIAL_CONSTRAINTS 19

3.2.12 ROUTINES 20

3.2.13 ROUTINE_COLUMNS 23

3.2.15 TABLE_CONSTRAINTS 25

3.2.14 SCHEMATA 25

3.2.16 TABLE_PRIVILEGES 26

3.2.17 TABLES 26

3.2.18 VIEW_COLUMN_USAGE 27

3.2.19 VIEW_TABLE_USAGE 27

3.2.20 VIEWS 28

第4章 T-SQL存储过程 29

4.1 存储过程概述 29

4.2.1 sp_ActiveDirectory_Obj 38

4.2 存储过程引用 38

4.2.2 sp_ActiveDirectory_SCP 40

4.2.3 sp_add_alert 41

4.2.4 sp_addalias 44

4.2.5 sp_addapprole 46

4.2.6 sp_add_data_file_recover_suspect_db 47

4.2.7 sp_addextendedproc 49

4.2.8 sp_addextendedproperty 50

4.2.10 sp_add_category 52

4.2.9 sp_addgroup 52

4.2.11 sp_add_job 54

4.2.12 sp_add_jobschedule 57

4.2.13 sp_add_jobserver 60

4.2.14 sp_add_jobstep 61

4.2.15 sp_addlinkedserver 65

4.2.16 sp_addlinkedsrvlogin 74

4.2.17 sp_add_log_file_recover_suspect_db 77

4.2.18 sp_addlogin 78

4.2.19 sp_add_log_shipping_database 81

4.2.20 sp_add_log_shipping_plan 82

4.2.21 sp_add_log_shipping_plan_database 83

4.2.22 sp_add_log_shipping_primary 85

4.2.23 sp_add_log_shipping_secondary 86

4.2.24 sp_add_maintenance_plan 88

4.2.25 sp_add_maintenance_plan_db 89

4.2.26 sp_add_maintenance_plan_job 90

4.2.27 sp_addmessage 90

4.2.28 sp_add_notification 93

4.2.29 sp_add_operator 94

4.2.30 sp_addremotelogin 97

4.2.31 sp_addrole 98

4.2.32 sp_addrolemember 100

4.2.33 sp_addserver 101

4.2.34 sp_addsrvrolemember 102

4.2.35 sp_addtask 104

4.2.36 sp_addtype 104

4.2.38 sp_addumpdevice 107

4.2.37 sp_add_targetservergroup 107

4.2.39 sp_add_targetsvrgrp_member 110

4.2.40 sp_adduser 111

4.2.41 sp_altermessage 112

4.2.42 sp_apply_job_to_targets 113

4.2.43 sp_approlepassword 115

4.2.44 sp_attach_db 116

4.2.45 sp_attach_single_file_db 117

4.2.46 sp_autostats 118

4.2.47 p_bindefault 119

4.2.48 sp_bindrule 121

4.2.49 sp_bindsession 123

4.2.50 sp_can_tlog_be_applied 125

4.2.51 sp_catalogs 125

4.2.52 sp_certify_removable 126

4.2.53 sp_change_monitor_role 127

4.2.54 sp_change_primary_role 128

4.2.55 sp_change_secondary_role 130

4.2.56 sp_change_users_login 132

4.2.57 sp_changedbowner 134

4.2.58 sp_changegroup 135

4.2.59 sp_changeobjectowner 136

4.2.60 sp_column_privileges 137

4.2.61 sp_column_privileges_ex 139

4.2.62 sp_columns 141

4.2.63 sp_columns_ex 144

4.2.64 sp_configure 146

4.2.65 sp_create_log_shipping_monitor_account 148

4.2.66 sp_create_removable 149

4.2.67 sp_createstats 150

4.2.68 sp_cursor_list 151

4.2.69 sp_cycle_errorlog 155

4.2.70 sp_databases 155

4.2.71 sp_datatype_info 156

4.2.72 sp_dbcmptlevel 159

4.2.73 sp_dbfixedrolepermission 162

4.2.74 sp_dboption 164

4.2.75 sp_dbremove 167

4.2.76 sp_defaultdb 168

4.2.77 sp_defaultlanguage 169

4.2.78 sp_define_log_shipping_monitor 170

4.2.79 sp_delete_alert 171

4.2.80 sp_delete_backuphistory 172

4.2.81 sp_delete_category 173

4.2.82 sp_delete_database_backuphistory 174

4.2.83 sp_delete_job 174

4.2.84 sp_delete_jobschedule 175

4.2.85 sp_delete_jobserver 176

4.2.86 sp_delete_jobstep 177

4.2.87 sp_delete_log_shipping_database 179

4.2.88 sp_delete_log_shipping_monitor_info 179

4.2.89 sp_delete_log_shipping_plan 180

4.2.90 sp_delete_log_shipping_plan_database 181

4.2.91 sp_delete_log_shipping_primary 182

4.2.92 sp_delete_log_shipping_secondary 183

4.2.93 sp_delete_maintenance_plan 183

4.2.94 sp_delete_maintenance_plan_db 184

4.2.95 sp_dele5te_maintenance_plan_job 185

4.2.96 sp_delete_notification 186

4.2.97 sp_delete_operator 187

4.2.98 sp_delete_targetserver 187

4.2.99 sp_delete_targetservergroup 188

4.2.100 sp_delete_targetsvrgrp_member 189

4.2.101 sp_denylogin 190

4.2.102 sp_depends 191

4.2.103 sp_describe_cursor 192

4.2.104 sp_describe_cursor_columns 196

4.2.105 sp_describe_cursor_tables 199

4.2.106 sp_detach_db 201

4.2.107 sp_dropalias 202

4.2.108 sp_dropapprole 203

4.2.109 sp_dropdevice 204

4.2.110 sp_dropextendedproc 205

4.2.111 sp_dropextendedproperty 206

4.2.112 sp_dropgroup 207

4.2.113 sp_droplinkedsrvlogin 208

4.2.114 sp_droplogin 210

4.2.115 sp_dropmessage 211

4.2.116 sp_dropremotelogin 212

4.2.117 sp_droprole 213

4.2.118 sp_droprolemember 214

4.2.119 sp_dropserver 215

4.2.120 sp_dropsrvrolemember 216

4.2.121 sp_droptask 218

4.2.122 sp_droptype 218

4.2.123 sp_dropuser 219

4.2.124 sp_dropwebtask 220

4.2.125 sp_enumcodepages 221

4.2.126 sp_executesql 222

4.2.127 sp_fkeys 225

4.2.128 sp_foreignkeys 228

4.2.129 sp_fulltext_catalog 230

4.2.130 sp_fulltext_column 233

4.2.131 sp_fulltext_database 235

4.2.132 sp_fulltext_service 237

4.2.133 sp_fulltext_table 238

4.2.134 sp_getapplock 241

4.2.135 sp_getbindtoken 243

4.2.136 sp_get_log_shipping_monitor_info 245

4.2.137 sp_grantdbaccess 248

4.2.138 sp_grantlogin 249

4.2.139 sp_help 250

4.2.140 sp_help_alert 253

4.2.141 sp_help_category 256

4.2.142 sp_helpconstraint 257

4.2.143 sp_helpdb 258

4.2.144 sp_helpdbfixedrole 260

4.2.145 sp_helpdevice 262

4.2.146 sp_help_downloadlist 263

4.2.147 sp_helpextendedproc 265

4.2.148 sp_helpfile 266

4.2.149 sp_helpfilegroup 268

4.2.150 sp_help_fulltext_catalogs 268

4.2.151 sp_help_fulltext_catalogs_cursor 270

4.2.152 sp_help_fulltext_columns 271

4.2.153 sp_help_fulltext_columns_cursor 272

4.2.154 sp_help_fulltext_tables 274

4.2.155 sp_help_fulltext_tables_cursor 275

4.2.156 sp_helpgroup 277

4.2.157 sp_helphistory 278

4.2.158 sp_help_job 278

4.2.159 sp_help_jobhistory 285

4.2.160 sp_help_jobschedule 288

4.2.161 sp_help_jobserver 290

4.2.162 sp_help_jobstep 292

4.2.163 sp_helpindex 294

4.2.164 sp_helplanguage 295

4.2.165 sp_helplinkedsrvlogin 296

4.2.166 sp_helplogins 298

4.2.167 sp_help_maintenance_plan 300

4.2.168 sp_help_notification 301

4.2.169 sp_helpntgroup 304

4.2.170 sp_help_operator 305

4.2.171 sp_helpremotelogin 307

4.2.172 sp_helprole 308

4.2.173 sp_helprolemember 309

4.2.174 sp_helprotect 310

4.2.175 sp_helpserver 313

4.2.176 sp_helpsort 315

4.2.177 sp_helpsrvrole 316

4.2.178 sp_helpsrvrolemember 317

4.2.179 sp_helpstats 318

4.2.180 sp_help_targetserver 319

4.2.181 sp_help_targetservergroup 321

4.2.182 sp_helptask 321

4.2.183 sp_helptext 322

4.2.184 sp_helptrigger 323

4.2.185 sp_helpuser 324

4.2.186 sp_indexes 326

4.2.187 sp_indexoption 328

4.2.188 sp_invalidate_textptr 329

4.2.189 sp_linkedservers 330

4.2.190 sp_lock 331

4.2.191 sp_makewebtask 333

4.2.192 sp_manage_jobs_by_login 351

4.2.193 sp_monitor 352

4.2.194 sp_MShasdbaccess 353

4.2.195 sp_msx_defect 353

4.2.196 sp_msx_enlist 354

4.2.197 sp_OACreate 355

4.2.198 sp_OADestroy 357

4.2.199 sp_OAGetErrorInfo 358

4.2.200 sp_OAGetProperty 361

4.2.201 sp_OAMethod 363

4.2.202 sp_OASetProperty 366

4.2.203 sp_OAStop 367

4.2.204 sp_password 368

4.2.205 sp_pkeys 369

4.2.206 sp_primarykeys 370

4.2.207 sp_post_msx_operation 372

4.2.208 sp_processmail 373

4.2.209 sp_procoption 375

4.2.210 sp_purgehistory 376

4.2.211 sp_purge_jobhistory 376

4.2.212 sp_reassigntask 377

4.2.213 sp_recompile 378

4.2.214 sp_refreshview 379

4.2.215 sp_releaseapplock 379

4.2.216 sp_remoteoption 380

4.2.217 sp_remove_job_from_targets 382

4.2.218 sp_remove_log_shipping_monitor 383

4.2.219 sp_rename 384

4.2.220 sp_renamedb 386

4.2.221 sp_resetstatus 386

4.2.222 sp_resolve_logins 387

4.2.223 sp_resync_targetserver 388

4.2.224 sp_revokedbaccess 389

4.2.225 sp_revokelogin 390

4.2.226 sp_runwebtask 391

4.2.227 sp_server_info 393

4.2.228 sp_serveroption 395

4.2.229 sp_setapprole 398

4.2.230 sp_setnetname 399

4.2.231 sp_settriggerorder 401

4.2.232 sp_scriptsubconflicttable 402

4.2.233 sp_spaceused 403

4.2.234 sp_special_columns 405

4.2.235 sp_sproc_columns 407

4.2.236 sp_srvrolepermission 410

4.2.237 sp_start_job 411

4.2.238 sp_statistics 413

4.2.239 sp_stop_job 415

4.2.240 sp_stored_procedures 416

4.2.241 sp_tableoption 418

4.2.242 sp_table_privileges 420

4.2.243 sp_table_privileges_ex 422

4.2.244 sp_tables 424

4.2.245 sp_tables_ex 426

4.2.246 sp_trace_create 428

4.2.247 sp_trace_generateevent 430

4.2.248 sp_trace_setevent 431

4.2.249 sp_trace_setfilter 438

4.2.250 sp_trace_setstatus 441

4.2.251 sp_unbindefault 442

4.2.252 sp_unbindrule 444

4.2.253 sp_update_alert 445

4.2.254 sp_update_category 449

4.2.255 sp_updateextendedproperty 450

4.2.256 sp_update_job 451

4.2.257 sp_update_jobschedule 454

4.2.258 sp_update_jobstep 457

4.2.259 sp_update_log_shipping_monitor_info 460

4.2.260 sp_update_log_shipping_plan 463

4.2.261 sp_update_log_shipping_plan_database 464

4.2.262 sp_update_notification 465

4.2.263 sp_update_operatorz 466

4.2.264 sp_updatestats 469

4.2.265 sp_update_targetservergroup 470

4.2.266 sp_updatetask 471

4.2.267 sp_validname 471

4.2.268 sp_validatelogins 472

4.2.269 sp_who 473

4.2.270 sp_xml_preparedocument 475

4.2.271 sp_xml_removedocument 478

4.2.272 xp_cmdshell 478

4.2.273 xp_deletemail 481

4.2.274 xp_enumgroups 482

4.2.275 xp_findnextmsg 483

4.2.276 xp_grantlogin 484

4.2.277 xp_logevent 485

4.2.278 xp_loginconfig 486

4.2.279 xp_logininfo 488

4.2.280 xp_msver 490

4.2.281 xp_readmail 492

4.2.282 xp_revokelogin 496

4.2.283 xp_sendmail 496

4.2.284 xp_sprintf 500

4.2.285 xp_sqlagent_proxy_account 501

4.2.286 xp_sqlmaint 504

4.2.287 xp_sscanf 505

4.2.288 xp_startmail 506

4.2.289 xp_stopmail 507

第5章 T-SQL复制存储过程 509

5.1 复制存储过程概述 509

5.2 复制存储过程引用 509

5.2.1 sp_add_agent_parameter 509

5.2.2 sp_add_agent_profile 511

5.2.3 sp_addarticle 513

5.2.4 sp_adddistpublisher 520

5.2.5 sp_adddistributiondb 522

5.2.6 sp_adddistributor 525

6.2.7 sp_addmergealternatepublisher 526

6.2.8 sp_addmergearticle 527

5.2.9 sp_addmergefilter 533

5.2.10 sp_addmergepublication 534

5.2.11 sp_addmergepullsubscription 538

5.2.12 sp_addmergepullsubscription_agent 539

5.2.13 sp_addmergesubscription 545

5.2.14 sp_addpublication 549

5.2.15 sp_addpublication_snapshot 554

5.2.16 sp_addpublisher70 556

5.2.17 sp_addpullsubscription 557

5.2.18 sp_addpullsubscription_agent 559

5.2.19 sp_addscriptexec 564

5.2.20 sp_addsubscriber 565

5.2.21 sp_addsubscriber_schedule 568

5.2.22 sp_addsubscription 570

5.2.23 sp_addsynctriggers 575

5.2.24 sp_addtabletocontents 577

5.2.25 sp_adjustpublisheridentityrange 578

5.2.26 sp_article_validation 579

5.2.27 sp_articlecolumn 580

5.2.28 sp_articlefilter 582

5.2.29 sp_articlesynctranprocs 583

5.2.30 sp_articleview 584

5.2.31 sp_attachsubscription 586

5.2.32 sp_browsesnapshotfolder 587

5.2.33 sp_browsemergesnapshotfolder 588

5.2.34 sp_browsereplcmds 589

5.2.35 sp_change_agent_parameter 591

5.2.36 sp_change_agent_profile 593

5.2.37 sp_changearticle 593

5.2.38 sp_changedistpublisher 598

5.2.39 sp_changedistributiondb 599

5.2.40 sp_changedistributor_password 600

5.2.41 sp_changedistributor_property 601

5.2.42 sp_changemergearticle 601

5.2.43 sp_changemergefilter 606

5.2.44 sp_changemergepublication 608

5.2.45 sp_changemergepullsubscription 611

5.2.46 sp_changemergesubscription 613

5.2.47 sp_changepublication 615

5.2.48 sp_changesubscriber 619

5.2.49 sp_changesubscriber_schedule 622

5.2.50 sp_changesubscriptiondtsinfo 623

5.2.51 sp_changesubstatus 624

5.2.52 sp_change_subscription_properties 628

5.2.53 sp_check_for_sync_trigger 630

5.2.54 sp_copymergesnapshot 631

5.2.55 sp_copysnapshot 631

5.2.56 sp_copysubscription 632

5.2.57 sp_deletemergeconflictrow 633

5.2.58 sp_disableagentoffload 634

5.2.59 sp_drop_agent_parameter 635

5.2.60 sp_drop_agent_profile 636

5.2.61 sp_dropanonymousagent 637

5.2.62 sp_droparticle 638

5.2.63 sp_dropdistpublisher 639

5.2.64 sp_dropdistributiondb 639

5.2.65 sp_dropdistributor 640

5.2.66 sp_dropmergealternatepublisher 641

5.2.67 sp_dropmergearticle 642

5.2.68 sp_dropmergefilter 643

5.2.69 sp_dropmergepublication 644

5.2.70 sp_dropmergepullsubscription 645

5.2.71 sp_dropmergesubscription 646

5.2.72 sp_droppublication 647

5.2.73 sp_droppullsubscription 648

5.2.74 sp_dropsubscriber 649

5.2.75 sp_dropsubscription 650

5.2.76 sp_dsninfo 651

5.2.77 sp_dumpparamcmd 652

5.2.78 sp_enableagentoflload 654

5.2.79 sp_enumcustomresolvers 655

5.2.80 sp_enumdsn 655

5.2.81 sp_enumfullsubscribers 656

5.2.82 sp_expired_subscription_cleanup 657

5.2.83 sp_generatefilters 658

5.2.84 sp_getagentoffloadinfo 658

5.2.85 sp_getmergedeletetype 659

5.2.86 sp_get_distributor 660

5.2.87 sp_getqueuedrows 661

5.2.88 sp_getsubscriptiondtspackagename 662

5.2.89 sp_grant_publication_access 663

5.2.90 sp_help_agent_default 663

5.2.91 sp_help_agent_parameter 664

5.2.92 sp_help_agent_profile 665

5.2.93 sp_helparticle 666

5.2.94 sp_helparticlecolumns 668

5.2.95 sp_helparticledts 669

5.2.96 sp_helpdistpublisher 670

5.2.97 sp_helpdistributiondb 672

5.2.98 sp_helpdistributor 673

5.2.99 sp_helpmergealternatepublisher 675

5.2.100 sp_helpmergearticle 676

5.2.101 sp_helpmergearticlecolumn 677

5.2.102 sp_helpmergearticleconflicts 678

5.2.103 sp_helpmergeconflictrows 679

5.2.104 sp_helpmergedeleteconflictrows 680

5.2.105 sp_helpmergefilter 682

5.2.106 sp_helpmergepublication 683

5.2.107 sp_helpmergepullsubscription 686

5.2.108 sp_helpmergesubscription 689

5.2.109 sp_helppublication 691

5.2.110 sp_help_publication_access 693

5.2.111 sp_helppullsubscription 694

5.2.112 sp_helpreplfailovermode 697

5.2.113 sp_helpreplicationdboption 698

5.2.114 sp_helpreplicationoption 699

5.2.115 sp_helpsubscriberinfo 700

5.2.116 sp_helpsubscription 702

5.2.117 sp_helpsubscription_properties 704

5.2.118 sp_ivindexhasnullcols 706

5.2.119 sp_link_publication 707

5.2.120 sp_marksubscriptionvalidation 708

5.2.121 sp_marksubscriptionvalidation 709

5.2.122 sp_mergearticlecolumn 709

5.2.123 sp_mergecleanupmetadata 711

5.2.124 sp_mergedummyupdate 713

5.2.125 sp_mergesubscription_cleanup 713

5.2.126 sp_publication_validation 714

5.2.127 sp_refreshsubscriptions 716

5.2.128 sp_reinitmergepullsubscription 716

5.2.129 sp_reinitmergesubscription 717

5.2.130 sp_reinitpullsubscription 718

5.2.131 sp_reinitsubscription 719

5.2.132 sp_removedbreplication 720

5.2.133 sp_repladdcolumn 721

5.2.134 sp_replcmds 723

5.2.136 sp_repldone 724

5.2.135 sp_replcounters 724

5.2.137 sp_repldropcolumn 726

5.2.138 sp_replflush 727

5.2.139 sp_replicationdboption 727

5.2.140 sp_replication_agent_checkup 729

5.2.141 sql_replqueuemonitor 729

5.2.142 sp_replsetoriginator 730

5.2.143 sp_replshowcmds 731

5.2.144 sp_repltrans 732

5.2.145 sp_restoredbreplication 733

5.2.146 sp_resyncmergesubscription 734

5.2.147 sp_revoke_publication access 735

5.2.148 sp_script_synctran_commands 736

5.2.149 sp_setreplfailovermode 737

5.2.150 sp_showrowreplicainfo 738

5.2.151 sp_subscription_cleanup 739

5.2.152 sp_table_validation 740

5.2.153 sp_update_agent_profile 742

5.2.154 sp_validatemergepublication 743

5.2.155 sp_validatemergesubscription 744

5.2.156 sp_vupgrade_replication 745

第6章 T-SQL表 747

6.1 系统表概述 747

6.2 系统表引用 749

6.2.1 backupfile 749

6.2.2 backupmediafamily 750

6.2.3 backupmediaset 751

6.2.4 backupset 752

6.2.5 logmarkhistory 754

6.2.6 log_shipping_databases 754

6.2.7 log_shipping_monitor 754

6.2.8 log_shipping_plan_databases 755

6.2.9 log_shipping_plan_history 755

6.2.10 log_shipping_plans 756

6.2.11 log_shipping_primaries 757

6.2.12 log_shipping_secondaries 757

6.2.14 MSagent_profiles 759

6.2.15 MSarticles 759

6.2.13 MSagent_parameters 759

6.2.16 MSdistpublishers 760

6.2.17 MSdistribution_agents 760

6.2.18 MSdistribution_history 762

6.2.19 MSdistributiondbs 763

6.2.20 MSdistributor 763

6.2.21 MSdynamicsnapshotjobs 763

6.2.23 MSlogreader_agents 764

6.2.22 MSdynamicsnapshotviews 764

6.2.24 MSlogreader_history 765

6.2.25 MSmerge_agents 765

6.2.26 MSmerge_altsyncpartners 766

6.2.27 MSmerge_contents 766

6.2.28 MSmerge_delete_conflicts 767

6.2.29 MSmerge_errorlineage 768

6.2.30 MSmerge_genhistory 768

6.2.31 MSmerge_history 769

6.2.33 MSmerge_subscriptions 770

6.2.32 MSmerge_replinfo 770

6.2.34 MSmerge_tombstone 771

6.2.35 MSpub_identity_range 771

6.2.36 MSpublication_access 772

6.2.37 MSpublications 772

6.2.38 MSpublisher_databases 774

6.2.39 MSqreader_agents 774

6.2.40 MSqreader_history 774

6.2.41 MSrepl_backup_lsns 775

6.2.44 MSrepl_identity_range 776

6.2.42 MSrepl_commands 776

6.2.43 MSrepl_errors 776

6.2.45 MSrepl_originators 777

6.2.46 MSrepl_transactions 777

6.2.47 MSrepl_version 777

6.2.48 MSreplication_objects 778

6.2.49 MSreplication_options 778

6.2.50 MSreplication_queue 779

6.2.51 MSreplication_subscriptions 779

6.2.53 MSsnapshot_history 780

6.2.52 MSsnapshot_agents 780

6.2.54 MSsubscriber_info 781

6.2.55 MSsubscriber_schedule 782

6.2.56 MSsubscription_agents 783

6.2.57 MSsubscription_articles 784

6.2.58 MSsubscription_properties 785

6.2.59 MSsubscriptions 786

6.2.60 MSsub_identity_range 787

6.2.63 restorefilegroup 788

6.2.62 restorefile 788

6.2.61 MSsync_states 788

6.2.64 restorehistory 789

6.2.65 sysalerts 790

6.2.66 sysaltfiles 791

6.2.67 sysarticles 791

6.2.68 sysarticleupdates 792

6.2.69 syscacheobjects 793

6.2.70 syscategories 795

6.2.71 syscharsets 795

6.2.72 syscolumns 796

6.2.73 syscomments 797

6.2.74 sysconfigures 798

6.2.75 sysconstraints 798

6.2.76 syscurconfigs 799

6.2.77 sysdatabases 799

6.2.78 sysdbmaintplan_databases 801

6.2.79 sysdbmaintplan_history 801

6.2.82 sysdepends 802

6.2.81 sysdbmaintplans 802

6.2.80 sysdbmaintplan_jobs 802

6.2.83 sysdevices 803

6.2.84 sysdownloadlist 804

6.2.85 sysfiles 805

6.2.86 sysfilegroups 805

6.2.87 sysforeignkeys 806

6.2.88 sysfulltextcatalogs 806

6.2.89 sysindexes 806

6.2.91 sysjobhistory 808

6.2.90 sysindexkeys 808

6.2.92 sysjobschedules 809

6.2.93 sysjobs 810

6.2.94 sysjobservers 812

6.2.95 sysjobsteps 812

6.2.96 syslanguages 813

6.2.97 syslockinfo 815

6.2.98 syslogins 818

6.2.100 sysmergearticles 819

9.2.99 sysmembers 819

6.2.101 sysmergepublications 821

6.2.102 sysmergeschemaarticles 824

6.2.103 sysmergeschemachange 825

6.2.104 sysmergesubscriptions 825

6.2.105 sysmergesubsetfilters 827

6.2.106 sysmessages 827

6.2.107 sysnotifications 828

6.2.108 sysobjects 828

6.2.110 sysopentapes 830

6.2.109 sysoledbusers 830

6.2.111 sysoperators 831

6.2.112 sysperfinfo 832

6.2.113 syspermissions 832

6.2.114 sysprocesses 833

6.2.115 sysprotects 834

6.2.116 syspublications 835

6.2.117 sysreferences 837

6.2.118 sysremotelogins 838

6.2.120 systargetservergroupmembers 839

6.2.119 sysreplicationalerts 839

6.2.121 systargetservergroups 840

6.2.122 systargetservers 840

6.2.123 systaskids 841

6.2.124 systypes 841

6.2.125 sysusers 842

索引 843

第6卷中 T-SOL编程元素索引 884