Similiar to Ray's suggestion.

tableID (identity) as PK

then create a UNIQUE INDEX on the 2 other columns (department and number). 

This will prevent the duplicates that you were trying to accomplish...

Perhaps you should consider revisting your solution.  Replication isn't the best solution to get data from a staging environment to a production environment.  The replication between the 2 production servers...

Sql server installs the files on both nodes of the cluster during setup (see msdn article)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_7ab7.asp

Solution "A" could also pose problems with duplicate authors based on how the interface is designed, ANSI padding, etc...

"Smith "

"Smith"

" Smith"

Solution "B" is best.

In addition, consider changing the "UserID" field...

During the set-up of the subscriber, if you are saying "INITIALIZE SCHEMA AND DATA", then the .sch scripts will be run against the subscriber.  In the replication folder read the...

free tool has been posted on this site many times.  SQL Digger

http://sqldigger.bdsweb.be/

SQL Server doesn't have versioning control.  You would need Visual Source Safe or another versioning tool to store versions of sprocs.

You only other choice is what Remi said about restoring...

If you want to restrict them from viewing all but the 1 database they have access to, you can grant select to the following tables in the database you want...

Sorry

Anyhow adjust accordingly.  So, 3.5Gb per node.

For optimal performance you should reserve 500MB for the OS Kernal.  Since this is an active/active cluster and total RAM is 4GB then each instance should have max memory set to 1.5GB RAM

1.  Enterprise Mangager is part of all editions of sql server 2000, except DeskTop Edition. 

SQL Server 2000 Standard Edition or Personal Edition is all you really need.

yes, I can connect and run the package manually.

it means the next identity value that will be assigned on the column will be

"839674091" this value is higher than the value you checked "8769854", so it should be ok.

In your...

The job does execute, but hangs at the RUN DTS step.

(during troubleshooting I added a new step to do a "select getdate()" and the Run DTS was Step2

Currently Step 1...

2 more things:

1.  other DTS jobs are running when scheduled as job on this server

2.  when troubleshooting, I did save a copy of the DTS without a password thinking this...