CONTENTS
Up to Level
Building SQL Server Applications Overview
Connecting Early Version Clients to SQL Server 2000
Samples
Samples
User-Defined Function Samples
Utility Samples
Bii
Pbalance
Virtual Backup Device Samples
Mprocess
Mthread
Osimple
Simple
Snapshot
XML Samples
XMLDemo
XMLStartup
SQL-SCM Samples
SCMControl
SCMStatus
MS DTC Samples
MS DTC Dblib Sample
MS DTC ODBC Sample
MS DTC T-SQL Sample
OLE Automation Samples
Getnpv OLE Automation Sample
Loopback (DAO) OLE Automation Sample
Loopback (RDO) OLE Automation Sample
Traverse OLE Automation Sample
Database Schema Samples
Sample Corporate Data Model
Sample Enterprise Data Warehouse
Sample Human Resources Data Mart
Sample Sales Data Mart
ADO and SQL Server
Programming ADO SQL Server Applications
Getting Started with ADO
ADO Syntax Conventions
System Requirements for ADO
ADO and OLE DB Provider Installation
ADO File Locations
Upgrading the Catalog Stored Procedures
Using ADO in Different Development Environments
Visual Basic and ADO
Visual C++ and ADO
Web-Based Applications and ADO
Adding a Data Source
Deleting a Data Source
Creating an ADO Application
Connecting to a SQL Server Data Source
Connecting to Multiple Instances of SQL Server
Retrieving Connection Properties
Executing Queries
Using the Command Object
Using the Connection Object
Constructing an SQL Statement
Using Parameters
Executing Statements
Executing Statements Directly
Executing Prepared Statements
Executing Stored Procedures
Using Return Code and Output Parameters for Stored Procedures
Executing User-Defined Functions
Using Batch Updates
Generating Multiple Recordsets
Processing Results
Using the Recordset Object
Using the Fields Collection and Field Object
Determining the Characteristics of a Result Set
Mapping Data Types
Data Type Usage Considerations
Using Cursors with ADO
Using Default Result Sets
Using Server Cursors with ADO
Scrolling and Retrieving Rows
Bookmarking Rows
Performing Transactions in ADO
Handling Errors and Messages in ADO
Handling Data Definition Language
Managing Long Data Types
ADO Support for SQL Server XML Features
XML-Related Properties
Using Streams for Command Input
Retrieving Result Sets into Streams
Mapping an XML Schema to a Relational Schema Using Annotated Schemas
ADO Support for OpenXML
SQL Server ADO Programmer's Reference
Objects
Command Object
Connection Object
Record Object
Recordset Object
Stream Object
Dynamic Properties
A
Access Order Property
Active Sessions Property
Asynchable Abort Property
Asynchable Commit Property
Autocommit Isolation Levels Property
B
Base Path Property
Blocking Storage Objects Property
Bookmark Type Property
Bookmarkable Property
C
Catalog Location Property
Catalog Term Property
Change Inserted Rows Property
Column Definition Property
Column Privileges Property
Column Set Notification Property
Command Time Out Property
Connect Timeout Property
Content Type Property
Current Catalog Property
Cursor Auto Fetch Property
D
Data Source Property
Data Source Name Property
Data Source Object Threading Model Property
DBMS Name Property
DBMS Version Property
Defer Column Property
Defer Prepare Property
Delay Storage Object Updates Property
E
Extended Properties Property
F
Fetch Backwards Property
G
GROUP BY Support Property
H
Heterogeneous Table Support Property
Hold Rows Property
I
IAccessor Property
IColumnsInfo Property
IColumnsRowset Property
IConnectionPointContainer Property
IConvertType Property
Identifier Case Sensitivity Property
Immobile Rows Property
Initial Catalog Property
IRowset Property
IRowsetChange Property
IRowsetIdentity Property
IRowsetInfo Property
IRowsetLocate Property
IRowsetResynch Property
IRowsetScroll Property
IRowsetUpdate Property
ISequentialStream Property
Isolation Levels Property
Isolation Retention Property
ISupportErrorInfo Property
L
Literal Bookmarks Property
Literal Row Identity Property
Locale Identifier Property
Lock Mode Property
M
Mapping Schema Property
Maximum Index Size Property
Maximum Open Rows Property
Maximum Pending Rows Property
Maximum Row Size Property
Maximum Row Size Includes BLOB Property
Maximum Rows Property
Maximum Tables in SELECT Property
Multiple Parameter Sets Property
Multiple Results Property
Multiple Storage Objects Property
Multi-Table Update Property
N
Notification Granularity Property
Notification Phases Property
NULL Collation Order Property
NULL Concatenation Behavior Property
O
Objects Transacted Property
OLE DB Version Property
OLE Object Support Property
Open Rowset Support Property
ORDER BY Columns in Select List Property
Others' Changes Visible Property
Others' Inserts Visible Property
Output Encoding Property
Output Parameter Availability Property
Output Stream Property
Own Changes Visible Property
Own Inserts Visible Property
P
Pass By Ref Accessors Property
Password Property
Persist Security Info Property
Persistent ID Type Property
Prepare Abort Behavior Property
Prepare Commit Behavior Property
Preserve on Abort Property
Preserve on Commit Property
Procedure Term Property
Prompt Property
Provider Friendly Name Property
Provider Name Property
Provider Version Property
Q
Quick Restart Property
R
Read-Only Data Source Property
Reentrant Events Property
Remove Deleted Rows Property
Report Multiple Changes Property
Return Pending Inserts Property
Row Delete Notification Property
Row First Change Notification Property
Row Insert Notification Property
Row Privileges Property
Row Resynchronization Notification Property
Row Threading Model Property
Row Undo Change Notification Property
Row Undo Delete Notification Property
Row Undo Insert Notification Property
Row Update Notification Property
Rowset Conversions on Command Property
Rowset Fetch Position Change Notification Property
Rowset Release Notification Property
S
Schema Term Property
Schema Usage Property
Scroll Backwards Property
Server Cursor Property
Server Data on Insert Property
Skip Deleted Bookmarks Property
SQL Support Property
SS STREAM FLAGS Property
Strong Row Identity Property
Structured Storage Property
Subquery Support Property
T
Table Term Property
Transaction DDL Property
U
Unique Rows Property
Updatability Property
Use Bookmarks Property
User ID Property
User Name Property
W
Window Handle Property
X
XML Root Property
XSL Property
Provider Support for ADOX
ADO Samples
ADO Connection and Error Handling
ADO and Long Data Types (Visual Basic)
ADO and Long Data Types (C++)
ADO and Long Data Types (Web)
ADO Web Application
ADO and FOR XML
ADO and Open XML
ADO and XPath Query
OLE DB and SQL Server
Programming OLE DB SQL Server Applications
Getting Started with the OLE DB Provider for SQL Server
OLE DB Syntax Conventions
System Requirements for the OLE DB Provider for SQL Server
Installing the OLE DB Provider for SQL Server
Upgrading the Catalog Stored Procedures (OLE DB)
Creating an OLE DB Application
Establishing a Connection to a Data Source
Executing a Command
Processing Results
Compiling OLE DB Applications
About OLE DB Properties
Data Source Objects
Data Source Properties
Data Source Information Properties
Initialization and Authorization Properties
Sessions
Session Properties
Persisted Data Source Objects
Commands
Command Syntax
Command Parameters
Preparing Commands
Commands Generating Multiple-Rowset Results
Using IMultipleResults to Process Multiple Result Sets
Rowsets
Creating a Rowset with IOpenRowset
Creating Rowsets with ICommand::Execute
Rowset Properties and Behaviors
Rowsets and SQL Server Cursors
Fetching Rows
Next Fetch Position
Fetching a Single Row Using IRow
Using IRow::GetColumns
Fetching BLOB Data Using IRow
Fetching BLOB Data Using IRow::GetColumns and ISequentialStream
Fetching BLOB Data Using IRow::Open and ISequentialStream
Bookmarks
Running Stored Procedures (OLE DB)
Calling a Stored Procedure (OLE DB)
Running User-Defined Functions (OLE DB)
Bulk-Copy Rowsets
Enabling a Session for IRowsetFastLoad
IRowsetFastLoad Rowsets
Updating Data in Rowsets
Updating Data in SQL Server Cursors
Resynchronizing Rows
BLOBs and OLE Objects
Getting Large Data
Setting Large Data
Tables and Indexes
Creating SQL Server Tables
Adding a Column to a SQL Server Table
Removing a Column from a SQL Server Table
Dropping a SQL Server Table
Creating SQL Server Indexes
Dropping a SQL Server Index
Notifications
Data Types (OLE DB)
Data Type Mapping in Rowsets and Parameters
Data Type Mapping in ITableDefinition
Schema Rowset Support in SQLOLEDB
Catalog Stored Procedures
Distributed Query Support in Schema Rowsets
Transactions
Supporting Local Transactions
Supporting Distributed Transactions
Isolation Levels in SQLOLEDB
SQLOLEDB Enumerator
Errors
Return Codes
Information in OLE DB Error Interfaces
SQL Server Error Detail
SQLOLEDB Example: Retrieving Error Information
SQL Server Message Results
SQL Server OLE DB Programmer's Reference
Interfaces (OLE DB)
IRowsetFastLoad (OLE DB)
IRowsetFastLoad::Commit (OLE DB)
IRowsetFastLoad::InsertRow (OLE DB)
ISQLServerErrorInfo (OLE DB)
ISQLServerErrorInfo::GetErrorInfo (OLE DB)
Schema Rowsets (OLE DB)
LINKEDSERVERS Rowset (OLE DB)
ODBC and SQL Server
Programming ODBC SQL Server Applications
Getting Started with ODBC
ODBC Syntax Conventions
System Requirements for ODBC
SQL Server ODBC Driver
SQL Server
Network Software
Installing the SQL Server ODBC Driver
Upgrading the Catalog Stored Procedures (ODBC)
Adding a Data Source
Deleting a Data Source
Connecting to a SQL Server Data Source
Using odbcping to Verify a Connection
Creating an ODBC Application
Asynchronous Mode and SQLCancel
Multithreaded Applications
Communicating with SQL Server
Allocating an Environment Handle
Allocating a Connection Handle
SQL Server ODBC Data Sources
Connecting to a Data Source
Disconnecting from a Data Source
Executing Queries
Allocating a Statement Handle
Constructing an SQL Statement
Constructing SQL Statements for Cursors
Using Statement Parameters
Binding Parameters
Executing Statements
Direct Execution
Prepared Execution
Procedures
Batches of Statements
Effects of SQL-92 Options
Freeing a Statement Handle
Processing Results
Determining the Characteristics of a Result Set
Assigning Storage (Binding)
Fetching Result Data
Mapping Data Types
Data Type Usage
Autotranslation of Character Data
Using Cursors
How Cursors Are Implemented
Using Default Result Sets
Using Server Cursors
ODBC Cursor Library
Cursor Types
Cursor Behaviors
Cursor Properties
Cursor Rowset Size
Cursor Concurrency
Cursor Transaction Isolation Level
Cursor Programming Details (ODBC)
Implicit Cursor Conversions (ODBC)
Using Autofetch with ODBC Cursors
Fast Forward-Only Cursors (ODBC)
Scrolling and Fetching Rows
Bookmarking Rows
Positioned Updates (ODBC)
Performing Transactions
Transactions in ODBC
Performing Distributed Transactions
Handling Errors and Messages
Processing Statements That Generate Messages
Diagnostic Records and Fields
Native Error Numbers
SQLSTATE (ODBC Error Codes)
Error Messages
Running Stored Procedures
Calling a Stored Procedure
Batching Stored Procedure Calls
Processing Stored Procedure Results
Using Catalog Functions
Performing Bulk Copy Operations
Logged and Nonlogged Bulk Copies
Using Data Files and Format Files
Bulk Copying from Program Variables
Managing Bulk Copy Batch Sizes
Bulk Copying text and image Data
Converting from DB-Library to ODBC Bulk Copy
Managing text and image Columns
Bound vs. Unbound text and image Columns
Logged vs. Unlogged Modifications
Data-at-execution and text, ntext, or image Columns
Connecting to a Failover Server
Profiling ODBC Driver Performance
SQL Server ODBC Driver Programmer's Reference
ODBC API Implementation Details
SQLBindCol
SQLBindParameter
SQLBrowseConnect
SQLCloseCursor
SQLColAttribute
SQLColumnPrivileges
SQLColumns
SQLConfigDataSource
SQLDescribeCol
SQLDescribeParam
SQLDriverConnect
SQLDrivers
SQLEndTran
SQLFetchScroll
SQLForeignKeys
SQLFreeHandle
SQLFreeStmt
SQLGetConnectAttr
SQLGetCursorName
SQLGetData
SQLGetDescField
SQLGetDiagField
SQLGetFunctions
SQLGetInfo
SQLGetStmtAttr
SQLGetTypeInfo
SQLMoreResults
SQLNativeSql
SQLNumResultCols
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLRowCount
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
SQL Server Driver Extensions
Bulk-Copy Functions
bcp_batch
bcp_bind
bcp_colfmt
bcp_collen
bcp_colptr
bcp_columns
bcp_control
bcp_done
bcp_exec
bcp_getcolfmt
bcp_init
bcp_moretext
bcp_readfmt
bcp_sendrow
bcp_setcolfmt
bcp_writefmt
Schema Functions Supporting Distributed Queries
SQLLinkedCatalogs
SQLLinkedServers
ODBC Samples
Cursors and Transactions, Data Entry and Concurrency
LoadData
Performance
ODBC Bulk Copy Sample
COMPUTE Clause and Multiple Result Sets
SQL - DMO
Developing SQL-DMO Applications
Getting Started with SQL-DMO
SQL-DMO Syntax Conventions
System Requirements for SQL-DMO
Installing SQL-DMO
SQL-DMO Objects and SQL Server Administration
SQL-DMO Object
Object Properties
Object Methods
Object Events
Creating SQL Server Components Using SQL-DMO Objects
SQL-DMO Objects and Existing SQL Server Components
Programming Extended SQL-DMO Objects
Using SQL-DMO Multistrings
SQL-DMO Collections and SQL Server Administration
SQL-DMO Collections
Collection Properties
Collection Methods
Creating SQL Server Components Using SQL-DMO Collections
Removing SQL Server Components Using SQL-DMO Collections
Description of the SQLServer Object
Creating and Connecting a SQLServer Object
SQL-DMO Object Tree
Developing SQL-DMO Applications Using Visual Basic
Object Creation
Properties Collection
SQL-DMO Constants
Handling SQL-DMO Events
Handling SQL-DMO Errors
Developing SQL-DMO Applications Using C or C++
Objects, References, and Reference Counting
Object Creation
Member Functions (Properties and Methods)
SQL-DMO Strings
SQL-DMO Properties Collection
SQL-DMO Data Types
Handling SQL-DMO Events
Handling SQL-DMO Errors
SQL-DMO Reference
Objects
A
Alert Object
AlertSystem Object
Application Object
B
Backup Object
Backup2 Object
BackupDevice Object
BulkCopy Object
BulkCopy2 Object
C
Category Object
Check Object
Column Object
Column2 Object
Configuration Object
ConfigValue Object
D
Database Object
Database2 Object
DatabaseRole Object
DatabaseRole2 Object
DBFile Object
DBObject Object
DBOption Object
DBOption2 Object
Default Object
Default2 Object
DistributionArticle Object
DistributionArticle2 Object
DistributionDatabase Object
DistributionDatabase2 Object
DistributionPublication Object
DistributionPublication2 Object
DistributionPublisher Object
DistributionPublisher2 Object
DistributionSubscription Object
DistributionSubscription2 Object
Distributor Object
Distributor2 Object
DRIDefault Object
F
FileGroup Object
FileGroup2 Object
FullTextCatalog Object
FullTextCatalog2 Object
FullTextService Object
I
Index Object
Index2 Object
IntegratedSecurity Object
J
Job Object
JobFilter Object
JobHistoryFilter Object
JobSchedule Object
JobServer Object
JobServer2 Object
JobStep Object
K
Key Object
L
Language Object
LinkedServer Object
LinkedServer2 Object
LinkedServerLogin Object
LogFile Object
Login Object
Login2 Object
M
MergeArticle Object
MergeArticle2 Object
MergeDynamicSnapshotJob Object
MergePublication Object
MergePublication2 Object
MergePullSubscription Object
MergePullSubscription2 Object
MergeSubscription Object
MergeSubscription2 Object
MergeSubsetFilter Object
N
NameList Object
O
Operator Object
P
Permission Object
Permission2 Object
Property Object
Publisher Object
Publisher2 Object
Q
QueryResults Object
QueryResults2 Object
R
RegisteredServer Object
RegisteredSubscriber Object
Registry Object
Registry2 Object
RemoteLogin Object
RemoteServer Object
RemoteServer2 Object
Replication Object
Replication2 Object
ReplicationDatabase Object
ReplicationDatabase2 Object
ReplicationSecurity Object
ReplicationStoredProcedure Object
ReplicationStoredProcedure2 Object
ReplicationTable Object
ReplicationTable2 Object
Restore Object
Restore2 Object
Rule Object
Rule2 Object
S
Schedule Object
ServerGroup Object
ServerRole Object
SQLObjectList Object
SQLServer Object
SQLServer2 Object
StoredProcedure Object
StoredProcedure2 Object
Subscriber Object
Subscriber2 Object
SystemDatatype Object
SystemDataType2 Object
T
Table Object
Table2 Object
TargetServer Object
TargetServerGroup Object
TransactionLog Object
TransArticle Object
TransArticle2 Object
Transfer Object
Transfer2 Object
TransPublication Object
TransPublication2 Object
TransPullSubscription Object
TransPullSubscription2 Object
TransSubscription Object
TransSubscription2 Object
Trigger Object
Trigger2 Object
U
User Object
User2 Object
UserDefinedDatatype Object
UserDefinedDataType2 Object
UserDefinedFunction Object
V
View Object
View2 Object
Collections
A
AlertCategories Collection
Alerts Collection
B
BackupDevices Collection
C
Checks Collection
Columns Collection
ConfigValues Collection
D
DatabaseRoles Collection
Databases Collection
DBFiles Collection
Defaults Collection
DistributionArticles Collection
DistributionDatabases Collection
DistributionPublications Collection
DistributionPublishers Collection
DistributionSubscriptions Collection
F
FileGroups Collection
FullTextCatalogs Collection
I
Indexes Collection
J
JobCategories Collection
Jobs Collection
JobSchedules Collection
JobSteps Collection
K
Keys Collection
L
Languages Collection
LinkedServerLogins Collection
LinkedServers Collection
LogFiles Collection
LogFiles2 Collection
Logins Collection
M
MergeArticles Collection
MergeDynamicSnapshotJobs Collection
MergePublications Collection
MergePullSubscriptions Collection
MergeSubscriptions Collection
MergeSubsetFilters Collection
N
Names Collection
O
OperatorCategories Collection
Operators Collection
P
Properties Collection
R
RegisteredServers Collection
RegisteredSubscribers Collection
RemoteLogins Collection
RemoteServers Collection
ReplicationDatabases Collection
ReplicationStoredProcedures Collection
ReplicationTables Collection
Rules Collection
S
ServerGroups Collection
ServerRoles Collection
SQLServers Collection
StoredProcedures Collection
SystemDatatypes Collection
T
Tables Collection
TargetServerGroups Collection
TargetServers Collection
TransArticles Collection
TransPublications Collection
TransPullSubscriptions Collection
TransSubscriptions Collection
Triggers Collection
U
UserDefinedDatatypes Collection
UserDefinedFunctions Collection
Users Collection
V
Views Collection
Properties
A
Action Property (Backup)
Action Property (Restore)
ActiveEndDate Property
ActiveEndTimeOfDay Property
ActiveStartDate Property
ActiveStartTimeOfDay Property
AdditionalParameters Property
Adsp Property
AfterTrigger Property
AgentCheckupInterval Property
AgentLogFile Property
AgentOffload Property
AgentOffloadServer Property
AgentsStatus Property
Alias Property
AllowDTS Property
AllowIdentity Property
AllowInteractiveResolver Property
AllowLength Property
AllowMergePublication Property
AllowNulls Property
AllowQueuedTransactions Property
AllowSynchronousTransactions Property
AllowSyncToAlternate Property
AltSnapshotFolder Property
AnsiNulls Property
AnsiNullsStatus Property
AnsiPaddingStatus Property
ApplicationName Property
AppRole Property
ArticleResolver Property
ArticleType Property
AssignmentDiag Property
Attributes Property
AuditLevel Property
AutoClose Property
AutoCreateStat Property
AutogenerateSyncProcedures Property
AutoIdentityRange Property
AutoReConnect Property
AutoShrink Property
AutoStart Property
AutostartDTC Property
AutostartLicensing Property
AutostartMail Property
AutostartServer Property
AutoUpdateStat Property
B
BackupDirectory Property
BackupSetDescription Property
BackupSetName Property
BaseType Property
BlockingTimeout Property
BlockSize Property
C
CaseSensitive Property
Catalog Property
Category Property
CentralizedConflicts Property
CharacterSet Property
Checked Property
CheckPermissions Property
Clustered Property
CmdExecSuccessCode Property
CodePage Property
Collation Property
CollationName Property
ColumnDelimiter Property
ColumnMaxLength Property
ColumnName Property
Columns Property
ColumnsNullByDefault Property
ColumnTracking Property
ColumnType Property
Command Property
CommandOptions Property
CommandTerminator Property
CompareNull Property
CompatibilityLevel Property (Database)
CompatibilityLevel Property (MergePublication2, TransPublication2)
ComputedText Property
ConflictPolicy Property
ConflictRetention Property
ConflictTable Property
ConnectionID Property
ConnectTimeout Property
ContactNull Property
CopyAllDefaults Property
CopyAllFunctions Property
CopyAllObjects Property
CopyAllRules Property
CopyAllStoredProcedures Property
CopyAllTables Property
CopyAllTriggers Property
CopyAllUserDefinedDatatypes Property
CopyAllViews Property
CopyData Property
CopySchema Property
Count Property
CountResetDate Property
CountResetTime Property
CreateDate Property
CreateForAttach Property
CreationScriptOptions Property
CreationScriptPath Property
CurrentCompatibility Property
CurrentExecutionStatus Property
CurrentResultSet Property
CurrentRunRetryAttempt Property
CurrentRunStatus Property
CurrentRunStep Property
CurrentValue Property
CursorCloseOnCommit Property
D
Database Property
DatabaseFileGroups Property
DatabaseFiles Property
DatabaseName Property
DatabaseUserName Property
DataFile Property
DataFilePath Property
DataFileSize Property
DataFileType Property
DataFolder Property
DataSource Property
DataSpaceUsage Property
DataSpaceUsed Property
Datatype Property
DateCreated Property
DateFindOperand Property
DateJobCreated Property
DateJobLastModified Property
DateLastModified Property
Day Property
Days Property
DboLogin Property
DBOUseOnly Property
DBOwner Property
DBReadOnly Property
Default Property (Column, UserDefinedDatatype)
Default Property (FileGroup)
DefaultCursor Property
DefaultDomain Property
DefaultLogin Property
DefaultOwner Property
DefaultPath Property
DelayBetweenResponses Property
DeleteCommand Property
DeleteLevel Property
DenyNTLogin Property
Description Property
DestDatabase Property
DestinationObjectName Property
DestinationOwnerName Property
DestLogin Property
DestPassword Property
DestServer Property
DestTranslateChar Property
DestUseTrustedConnection Property
DeviceNumber Property
Devices Property
DistributionAgent Property
DistributionCleanupTaskName Property
DistributionDatabase Property
DistributionJobID Property
DistributionServer Property
DistributionWorkingDirectory Property
Distributor Property
DistributorAvailable Property
DistributorInstalled Property
DistributorLocal Property
DropDestObjectsFirst Property
DropLogins Property
DTSPackageLocation Property
DTSPackageName Property
DTSPackagePassword Property
DynamicFilterHostName Property
DynamicFilterLogin Property
DynamicFilters Property
DynamicReconfigure Property
DynamicSnapshotJobId Property
DynamicSnapshotLocation Property
E
EmailAddress Property
EmailLevel Property
EnableBcp Property
Enabled Property
EnabledForSyncMgr Property
EnableMergePublishing Property
EnableTransPublishing Property
Encrypted Property
EndRunDate Property
EndRunTime Property
EnlistDate Property
ErrorFilePath Property
ErrorLogPath Property
ErrorLogSize Property
EventCategoryID Property
EventDescriptionKeyword Property
EventID Property
EventlogLevel Property
EventSource Property
ExcludeReplication Property
ExpirationDate Property
ExportWideChar Property
F
FailSafeOperator Property
FakeSystemTable Property
FileGroup Property
FileGrowth Property
FileGrowthInKB Property
FileGrowthType Property
FileNumber Property
Files Property
FillFactor Property
FilterClause Property
FirstDayOfWeek Property
FirstRow Property
Flags Property
FormatFilePath Property
FormatMedia Property
ForwardAlways Property
ForwardingServer Property
ForwardingSeverity Property
FrequencyInterval Property
FrequencyRecurrenceFactor Property
FrequencySubDay Property
FrequencySubDayInterval Property
FrequencyType Property
FTPAddress Property
FTPLogin Property
FTPPassword Property
FTPPort Property
FTPSubdirectory Property
FullName Property
FullSubscription Property
FullTextCatalogID Property
FullTextCatalogName Property
FullTextColumnLanguageID Property
FullTextImageColumnType Property
FullTextIndex Property
FullTextIndexActive Property
FullTextIndexSize Property
FullTextKeyColumn Property
FullTextPopulateStatus Property
G
Get Property
Granted Property
GrantedGranted Property
Grantee Property
GroupID Property
GroupRegistrationServer Property
GroupRegistrationVersion Property
H
HasBigIntColumn Property
HasBigIntIdentityColumn Property
HasClusteredIndex Property
HasDBAccess Property
HasFullTextIndexedTables Property
HasGuidColumn Property
HasIdentityColumn Property
HasIdentityNotForReplColumn Property
HasIndex Property
HasNotification Property
HasPrimaryKey Property
HasRemoteDistributionPublisher Property
HasRowVersionColumn Property
HasSchedule Property
HasServer Property
HasSQLVariantColumn Property
HasStep Property
HasSubscription Property
HasTimeStampColumn Property
HistoryCleanupTaskName Property
HistoryRetention Property
HostName Property
I
ID Property
ID Property (DistributionArticle2)
Identity Property
IdentityIncrement Property
IdentityRangeThreshold Property
IdentitySeed Property
Impersonate Property
ImpersonateClient Property
ImportRowsPerBatch Property
InActiveDirectory Property
InAlter Property
IncludeDB Property
IncludeDependencies Property
IncludeEventDescription Property
IncludeIdentityValues Property
IncludeLogins Property
IncludeUsers Property
IndexedColumns Property
IndexOnTable Property
IndexSpaceUsage Property
IndexSpaceUsed Property
Initialize Property
InPrimaryKey Property
InsertCommand Property
InstanceName Property
InsteadOfTrigger Property
Isbulkadmin Property
IsClustered Property
IsComputed Property
Isdb_accessadmin Property
Isdb_backupoperator Property
Isdb_datareader Property
Isdb_datawriter Property
Isdb_ddladmin Property
Isdb_denydatareader Property
Isdb_denydatawriter Property
Isdb_owner Property
Isdb_securityadmin Property
Isdbcreator Property
IsDeleted Property
IsDeterministic Property
Isdiskadmin Property