You can create User-defined data types when you need to store the same type of data in multiple tables. User-defined data types ensure that those columns...

Microsoft has a set of Technologies to access Relational (i.e. SQL Server data, Oracle data, DB2 data), non-relational data (i.e. Text data, images, etc), and multi-dimensional data (OLAP...

When you attempt to restore your database SQL Server will perform a safety check to eliminate the possibility of overwriting your database unintentionally and fail the operation if the database...

I agree with Robert when MS ACCESS is used as a front-end to an OLTP database. If you intend to use it as a front-end to a multidimensional data structure...

You may like to review the following articles on clustering:

http://support.microsoft.com/default.aspx?scid=kb;en-us;815431

http://support.microsoft.com/default.aspx?scid=kb;en-us;281662

http://support.microsoft.com/default.aspx?scid=kb;en-us;246328

http://support.microsoft.com/default.aspx?scid=kb;en-us;818548#appliesto

http://support.microsoft.com/default.aspx?scid=kb;en-us;815431

http://support.microsoft.com/default.aspx?scid=kb;en-us;301520

Regards

Rachel,

SQL Server has an automatic locking mechanism that allows different types of resources to be locked by a transaction. SQL Server automatic locking mechanism selects appropriate locks for resources (single...

Your issue may be related with orphaned sessions. An orphaned session occurs when the client terminates suddenly (i.e. power failure on the client, client computer is physically shut down) without...

There are two ways you can get information about locks:

Transact SQL command sp-lock or

SQL Server Enterprise Manager in the “Current Activity Window”

If you need to control the type...

Thread

A thread is a Windows function that enables application instructions be separated into many concurrent execution paths.

When the OS executes an application, it creates a unit of work called process....

Normally a nonfatal error will allow the operations within SQL Server with no apparent adverse reaction. Nevertheless, it is a good idea to know exactly what happened, to eliminate...

Juanita,

We definitely know SQL Server 2000 SP3A runs on Windows 2000 Server, Advanced Server, and Datacenter Server with any service packs.

However, the DBA, has the responsibility to ensure the...

I you run Enterprise Manager for the first time on your server (the computer where you have installed SQL Server), it should have automatically registered your SQL Server.

Apparently you are...

The sysdatabases table in the master database contains one row for each database you create. Use sp_helpdb to report information about databases. The syntax for this command is:

 “sp_helpdb” if you...

You can also use Data Transformation Services (DTS Import/Export Wizard) to copy the objects and the data of an SQL Server database to another SQL Server database.

Regards

There are many options you can set to modify the behavior of a database. These options are grouped in different categories. There is an option...