Object Explorer
stored procedures actions in, 52
table modification and script generation in, 49
use in SQL Server Management Studio, 4753
Object-linking and embedding database (OLE DB)
defined, 121122
providing generic access to database system, 1011
understanding, 126127
use SQL Server Integration Services (SSIS), 78
Object-Oriented Systems Model (OSM), 92
Object-Role Modeling (ORM), 92
ODBC. See Open database connectivity (ODBC)
ODBC Microsoft SQL Server Setup dialog box, 125
OLE DB. See Object-linking and embedding database (OLE DB)
One-to-many relationships, 9593
Online index operations, 68
Open database connectivity (ODBC), 11
create data source name , 123125
main components of database application connecting to SQL Server 2005 through, 10
program applications, 125126
providing generic access to
database system, 1011
SQL Reporting Services, 79
Open database connectivity (ODC), 121124
Operational requirements
architecture and, 77
availability, 7778
defined, 74, 76
examples, 7677
interoperability, 7879
manageability, 7980
performance, 8081
reliability, 8182
scalability, 82
security, 83
See also Requirements
Operation system requirements, 1516
Optimistic concurrency, 261265, 281
ORDER BY clause, 162, 176177
ORM. See Object-Role Modeling (ORM)
OSM. See Object-Oriented Systems Model (OSM)
Other Data Sources node, 287
Output parameters, 164165