Back again.

What works:

Allows: swapping in a single update

Disallows: swapping in 2 separate updates

Sample data devices:

pk 10 , sim 10

pk 20 , sim 20

Allowed:

update devices

set simid=sim

from devices

inner join

(

--setting multiple values...

Cheers!

About the non-clustered index on device.simid.

By default, when you create a foreign key, sql server doesn't automatically add an index on both columns involved in the master-parent relationship (at least...

Autogrowth is recommended be a fixed size instead of a percentage.

A monitoring script for database-size should be in the scripts-sections.

Hello,

If you wish to restore a database to a point in time you will need

A full backup to restore from

+ A differential backup to restore from (optional, contains all...

Hello,

Thanks for the sample data. It was great for testing.

Columnnames can vary.

I would implement it via a foreign key (validation) +trigger (preventing duplicates)

--check if sim is valid using...

Are the new records inserted in "Tom" or is there replication involved (possible delay)?

Hello,

Have a look at

http://www.sqljunkies.ddj.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

It answers a lot of memory questions.

Generally I leave 0.5GB-1GB for the operating system (otherwise expect odd errors).

You might want to check

SQLServer:Memory Manager: Target Server Memory...

Strange that an alerting engine would interfere with the replication jobs.

Can you lower the MaxBcpthreads back to 1?

I haven't much experience with replication troubleshooting.

What is the current servicepack of both...

I would lower the BcpBatchSize to 10000 or something. How many records are in the table?

also have a look at another replication site I've found

http://www.informit.com/articles/article.aspx?p=344817

found a nice site with replication faq

http://www.replicationanswers.com/General.asp

Any detailed info after failed (like I/O, ...)?

What is the timeout on the snapshot agent?

The first link deals with the added RPC security of Windows 2003 (and MSDTC)

(starting at Set the appropriate MSDTC Security Configuration options on Windows Server 2003 SP1 and Windows XP...

Sorry, the extra dot was really tight

http://sql-server-performance.com/Community/forums/p/28131/151182.aspx

Have a look at

http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-05/0276.html

and

http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-05/0278.html

Have you checked the permissions of SQL Agent?

The autoupdating of stats usually improves execution plan.

Perhaps you can try this in a test-environment

CHECKPOINT --writes dirty blocks to disk

DBCC DROPCLEANBUFFERS --cleans the cache

DBCC FREEPROCCACHE --cleans the stored proc cache.

Then...