I am Using An 8GB machine

SQL Server 2000 Enterprize Addition SP4 (32 bit)

SQL Is configured to use up to 7GB

found it in here

http://www.databasejournal.com/features/mssql/article.php/3379901

Thanks

Referntial Ontegrity Constraint Applied through Forigen Keys Keep You safe When you are trying to delete rows

But It can be very dangerous when you anble cascading delete.

Prefomarnce degregation are Imminent

Try...

Well Snap Shot VS DTS

Advantages off SnapShot

1. Works On Extents (64K) IO

2. Use Unsincronized Buffer Reading and Writing

3.Ensure Accurate Schema Transfer.

Disatvantege

1. Relativly More Complicated.

2. Has Limitation Of 255 Columns And...

Onther situation

I Other Tables Are Rarely Updated In The Center But can be Updated at the remote site

Does Snapshot replication take into account these changes and when the snapshot applied...

I Will Have Some SnapShot Replication

(Each SnapShot Replication Group Severl Articales, and Applied at diffrent times and reintilized in diffrent times).

I will also have Transactionl and merger Replication on other...

This Is From The BOOKS ON LINE

SQL Server does not allow the creation of a unique index on columns that already include duplicate values, whether or not IGNORE_DUP_KEY is set....

The DBCC CHECKDB Returns In its Output

The Object ID and The Index ID Where The Problem Is

Using Information Schema OR System Tables You Can Find The Object (Table and Index)

Then...

The Follwing Exmplw May Be of Some Use

--------------------------

-- Aggregate Bitwise OR --

--------------------------

-- data and schema

CREATE TABLE Bitvalues

(

key_col int NOT NULL PRIMARY KEY,

group_col int NOT...

What Hapans When you reinitilzes the subscription

Thanks I do not Know How I have Missed It

Access Will Copy all the data from An SQL Server table to the Jet in Link table situation when you join a link table and a locla table on...

First Thanks For The Advice

the error returend from The DBCC DBREPAIR

Are

Server: Msg 8929, Level 16, State 1, Line 1

Object ID 2: Errors found in text ID 17397841920 owned by...

No They Cnaot Be Drop Using Drop Statistic And They Are Not starting with _WA

By The Way The Index Status is 10485792

it is int form of hypothetical auto...