Index_O

O

Object Browser (in Query Analyzer), 168-169

Object Browser options, accessing, 169

Object levels, explained, 201

Object Search tool, 170

object_id() function, 248

objectproperty() function, 337

Objects

cleaning up, 207

creating, 204

finding, 170

ODBC, 166

ODBC driver, 116

ODBC error messages, injection attacks and, 85-86

ODBC messages, viewing, 168

ODBC OLE DB Provider, 116

ODS (Open Data Services), 5

Offline option (database Properties), 43

Offline Pending state (resource), 398

Offline state (resource), 398

OLE Automation service, 203-208

security issues, 204

stopping, 207

stored procedures (sp_oa*.*), 81, 99

OLE DB, replication use of, 423

OLE DB Provider for DB2, 115

OLE DB Provider for ODBC, 116

OLE DB Provider for Oracle, 115

OLE DB providers, 116

listing installed, 487-488

where to find, 116

Online Pending state (resource), 398

Online state (resource), 398

Open transactions, detecting, 190-191

openquery() function, 242, 319-321

openrowset() function, 319-321

Operating system components, optimizing, 210-211

Operators, 103-106

Oracle, 5

connecting to, 313

OLE DB provider for, 115

table naming compatibility issues, 223

upgrading to SQL Server from, 115

ORDER BY clause, 317-318, 329

avoiding using, 242

creating a view with, 243-245

Organization charts (personnel), 50

osql utility, 167-168

calling from xp_cmdshell, 181

parameters, 167

OS/2 LAN Manager, 4

Outage, acceptable amount in a year, 262

Outlook 2000 e-mail client, 95-97

Ownership chain, 71