#marketplace, .navbar, .container, .container-fluid, #media, #category, #ewards, #careers, .blueHeroSearchContainer, #photoHeroBanner, #etextbooks-page-2015, .slider-arrow, #books-page-2015, #my-account-wrapper-2015 {display:none;} .noscriptmsg p, .noscriptmsg h1 {color: #000;} body {background-color: #ccc !important; font-size: 14px; }

We're sorry, but eCampus.com doesn't work properly without JavaScript.

Either your device does not support JavaScript or you do not have JavaScript enabled.

How to enable JavaScript in your browser.

Need help? Call 1-855-252-4222

Rent now promotional banner

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Scripting XML and WMI for Microsoft<sup>®</sup> SQL Server<sup>TM</sup> 2000: Professional Developer's Guide book cover, ISBN 9780471399513

Scripting XML and WMI for Microsoft^® SQL Server^TM 2000: Professional Developer's Guide

by Tobias Martinsson

ISBN13: 9780471399513
ISBN10: 0471399515
Format: Paperback
Copyright: 2001-01-01
Publisher: Wiley

Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
1. Scripting XML and WMI for Microsoft^® SQL Server^TM 2000: Professional Developer's Guide > ISBN13: 9780471399513

List Price: $44.99

We're Sorry.
No Options Available at This Time.

Summary

A quick-start guide to mastering all of SQL Server 20002s hot new Web development and database programming features SQL Server 20002s new XML features, Windows Management Instrumentation (WMI), and scripting capabilities make it easier than ever for Web developers to create and manage flexible, scalable database applications optimized for the Internet--especially e-commerce applications. This quick-start guide is for Web developers and database programmers who need to get up to speed on these powerful new features. It begins with a no-frills tutorial on SQL programming basics and all the new SQL features. Then, step-by-step, it shows readers how to use those features to build cool database applications and to optimize database performance.

Table of Contents

Acknowledgments

xiii

Introduction

xv

Part One SQL Server and Extensible Markup Language (XML)

1

(118)

SQL Server 2000

3

(18)

Introduction

3

(2)

The Installation Process

5

(16)

Launching the Program

6

(1)

Invoking the Installation

6

(1)

Computer Name

7

(1)

Installation Selection

8

(1)

User Information

9

(1)

Installation Definition

9

(1)

Instance Name

10

(2)

Setup Type

12

(1)

Select Components

12

(1)

Services Account

13

(1)

Authentication Mode

14

(1)

Collation Settings

14

(1)

Installing Additional Components

15

(1)

Starting the Microsoft SQL Server Service Manager

15

(2)

Starting the SQL Server Enterprise Manager

17

(2)

Windows Management Instrumentation (WMI)

19

(2)

Introduction to Extensible Markup Language (XML)

21

(26)

Background

21

(25)

Hypertext Markup Language (HTML)

22

(1)

XML

22

(2)

XML Parsers

24

(1)

XML Elements

24

(2)

XPath Language

26

(7)

XSL Transformations

33

(5)

XML Namespaces

38

(3)

XML Schema

41

(4)

XML, HTTP, and SQL Server

45

(1)

Summary

46

(1)

SQL Server and XML on the Web

47

(24)

XML and IIS

47

(22)

The ISAPI Extension

48

(1)

Launching the Management Tool

48

(1)

Adding a Virtual Directory

49

(5)

SQL and URLs

54

(1)

The FOR XML Clause

55

(2)

The Top-Level Element

57

(4)

Template File Query

61

(4)

Executing Stored Procedures

65

(3)

Parameters

68

(1)

Summary

69

(2)

The FOR XML Modes

71

(8)

The Raw Mode

71

(2)

Auto Mode

73

(2)

Explicit Mode

75

(3)

Limitations of FOR XML

78

(1)

Summary

78

(1)

Annotated Schemas

79

(8)

Schema-Building

79

(4)

Adding the Top Level

80

(1)

Defining Data Types

80

(2)

Tree Structures

82

(1)

Configuration

83

(2)

The Query Language

85

(1)

Locating Data in a Schema

85

(1)

Summary

86

(1)

Writing, Modifying, and Deleting XML Data

87

(10)

The Open XML Function

87

(1)

XML System Stored Procedures

88

(1)

Element-Centric Mapping

88

(2)

Attribute-Centric Mapping

90

(1)

Edge-Table Mapping

91

(1)

Inserting Data

92

(2)

Modifying Data

94

(1)

Deleting Data

95

(1)

Summary

96

(1)

Updategrams

97

(6)

Introduction

97

(1)

Inserting and Deleting Records

98

(1)

Updating Records

99

(1)

Updategram XML

100

(1)

More Information

101

(1)

Summary

101

(2)

Applying XML from SQL Server

103

(16)

IIS Virtual Directory Management

103

(5)

VDirControl

103

(1)

SQLVDirs Collection Object

104

(1)

SQLVDir Object

104

(2)

VirtualNames Collection

106

(1)

VirtualName Object

107

(1)

Microsoft Data Access Components (MDACs)

108

(9)

The Command Object

108

(1)

The Stream Object

109

(3)

Microsoft XML Parser

112

(1)

Direct Queries

113

(1)

Posting Requests

113

(1)

XML-to-HTML-to-ASP

114

(1)

Parameterized XML Queries

115

(1)

XPath and the Mapping Schema

116

(1)

Summary

117

(2)

Part Two SQL Server and Windows Management Instrumentation (WMI)

119

(102)

Windows Management Instrumentation (WMI)

121

(26)

Introduction

121

(2)

The Management Architecture

123

(7)

Windows Management Service

123

(2)

The CIM Repository and CIM Object Manager

125

(2)

About CIM

127

(3)

The Security Model

130

(2)

WMI and Microsoft SQL Server

132

(13)

The Provider

133

(1)

MSSQL Classes

134

(7)

Creating New Objects

141

(4)

Summary

145

(2)

The WMI Scripting API

147

(44)

Introduction

147

(1)

The SWbemLocator Object

148

(3)

Overview: The SWbemLocator Object

150

(1)

The SWbemServices Object

151

(10)

Get Instance or Class

152

(1)

Enumerating Instances

153

(1)

Executing Queries

154

(1)

Overview: The SWbemServices Object

154

(7)

SWbemObject

161

(1)

Overview: The SWbemObjectSet

161

(1)

The SWbemObject Object

162

(8)

Overview: The SWbemObject Object

164

(6)

The SWbemSink Object

170

(3)

Overview: The SWbemSink Object

171

(2)

The SWbemMethod and SWbemProperty Objects

173

(2)

Overview: The SWbemMethodSet Collection, SWbemMethod Object SWbemPropertySet Collection, and SWbemProperty Objects

174

(1)

The SWbemPrivilegeSet Object

175

(2)

Overview: The SwbemPrivilegeSet Collection Object

175

(2)

The SWbemObjectPath Object

177

(1)

Overview: The SWbemLastError Object

178

(1)

The SWbemNamedValueSet Object

178

(2)

Overview: The SWbemNamedValueSet Collection Object

179

(1)

The SWbemNamedValue Object

180

(1)

The SWbemEventSource Object

180

(1)

Overview: The SWbemEventSource Object

180

(1)

Method Return Values

181

(2)

Languages and Output Parameters

182

(1)

Scripting Languages and Variants

183

(1)

Common WMI Enumerated Constants

184

(6)

Summary

190

(1)

WMI Query Language

191

(12)

Introduction

191

(9)

Data Queries

192

(4)

Event Queries

196

(3)

Schema Queries

199

(1)

Query Optimization

199

(1)

Programing with Events

200

(1)

Summary

201

(2)

Common Management Tasks

203

(18)

Creating a New Database

203

(2)

Creating a New Table

205

(1)

Adding a New Column

206

(1)

Creating a New Login

207

(1)

Associating a Login with an SQL Server Role

207

(1)

Getting Information about a Login

208

(1)

Starting and Stopping SQL Server

209

(1)

Dumping Properties of a Table

209

(1)

Dumping All Instances of a Class

210

(1)

Creating a Stored Procedure

211

(2)

Assigning Permissions to a Stored Procedure

213

(1)

Enumerating Parameters of the Stored Procedure

214

(1)

Modifying Database Settings

214

(1)

Bulk-Copying a Table

215

(1)

WMI Context Objects

216

(1)

Error Checking

217

(1)

Registering for NT Log Events

218

(1)

Summary

219

(2)

Part Three Schema Reference

221

(4)

Common Material

222

(3)

Appendix A Aggregations

225

(6)

Appendix B Dependent Objects

231

(20)

Appendix C Permissions

251

(10)

Appendix D Scoped Objects

261

(6)

Appendix E Containment

267

(4)

Appendix F Static Settings

271

(22)

Appendix G Dynamic Settings

293

(12)

Appendix H Extensions

305

(4)

Appendix I Statistics

309

(4)

Appendix J Logical Elements

313

(6)

Appendix K Users and Accounts

319

(10)

Appendix L Service and Process Classes

329

(24)

Appendix M Storage

353

(6)

Appendix N Database Management System (DBMS) Objects

359

(38)

Appendix O Top-Level Classes, Parameters, and More

397

(4)

Appendix P What Is on the CD-ROM?

401

(2)

Index

403

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program

%>