message in Visual Studio .NET

Drawer PDF-417 2d barcode in Visual Studio .NET message

The fundamental unit of data within a Service Broker application. It contains all the information that needs to be processed.

an update lock. This type of lock starts as a shared lock and then is changed to an exclusive lock just before the data is modified.

The name for a particular implementation of a message. It defines the possible formats allowed within a message body. ing session that is in a recovering state, does not allow any connections, and is receiving changes from the principal.

mirror The database within a database mirror-

A file that contains a transaction log. (See also data file.) process to keep track of the location in a transaction log where the next write should occur. This is an internal structure that has no visibility and cannot be manipulated.

log shipping The automated process of back-

database is promoted to principal and recovered. This process also automatically demotes the principal to become the mirror within the database mirroring session.

ing up, copying, and restoring a transaction log from one database on a primary server to one or more secondary databases on another server.

Server to back up data once but create multiple copies of a database that occur in a single backup operation.

One of two mechanisms for validating attempts to connect to instances of SQL Server. Users must specify a SQL Server login ID and password when they connect. The SQL Server instance ensures that the login ID and password combination are valid before allowing the connection to succeed. You can create SQL Server logins that are not mapped to an operating system user. You use Mixed Mode authentication when you need to provide access to non-Windows users. (See also Windows authentication.) instance that keeps track of a log shipping process and raises alerts when the process fails.

Commonly used words in a given language such as the, a, and an that are ignored by index population as well as full-text queries.

not cause data pages within a table to be sorted. You can create up to 249 nonclustered indexes per table.

return a different value each time the function is called. The SQL Server built-in function GETDATE() , which returns the current system date and time, is an example of a nondeterministic function. (See also deterministic function.)

A conversation that occurs between a single endpoint and any number of target endpoints. This conversation type is not currently available in SQL Server 2005.

A process that uses row-versioning technology to enable you to build an index while read and write operations are occurring in the underlying table. This feature is available only in SQL Server 2005 Enterprise Edition. A configuration that governs how a database mirroring session synchronizes transactions and which failover options are available. You can choose from three operating modes: High Availability, High Performance, or High Protection. nisms and parameters required to send a message to a person or group of people.

that has been given a name to differentiate it from other named instances and from the default instance on the same computer. A named instance is identified by the computer name and instance name.

operator Defines the notification mecha-

system account that is similar to authenticated user accounts. This account has the same level of access to system resources and objects as members of the Users group. Services that run under this account access network resources using the credentials of the computer account. It is not recommended that this account be used for the SQL Server service or SQL Server Agent service account.

tables in a query, a type of join that returns all rows from one or both tables and nonmatching rows from the other table. (See also inner join.)