I dont think you've had any replies as this is not normal behaviour for replication.

Something or someone could well be causing this to happen by editing the publication...

USE [BankLoans]

GO

/****** Object: StoredProcedure [dbo].[usp_insert_LoanOfficer] Script Date: 10/07/2010 09:58:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_insert_LoanOfficer]

-- Add the parameters for the stored procedure here

(

@LoanOfficerID int,

@BranchID int = 9,

@LoanOfficerNumber int...

I wouldnt say Active/Active/Passive is frowned upon, it just isnt common. I set one of these up for my previous company as by virtue of legacy reasons their production...

A lot of this depends on your environment and SQL estate. If you have a small number of servers with a limited number of transactions I would say yes,...

The maximum connections can be viewed by running this script on SQL Server.

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

exec sp_configure 'show advanced' , 1

reconfigure...

If you are not space constrained and it is imperative that you cannot have down time, I would consider creating a duplicate table based on the partition function of a...

An exact match works nicely with a look up and this can be configured to your "key" fields.

If you are using Enterprise edition you have the option of...

If you add the article using scripts and then generate the snapshot, the snapshot agent should only add the new articles and limit the impact to both the publisher and...

I dont know of any more from Microsoft. ApexSQL offer the Enforce product.

Previously I've done this in a three step approach in the following order DELETE, UPDATE and INSERT using a temporary/staging table.

/*Tableb is staging table, Tablea is live */

DELETE FROM tableA

FROM...

I have a schedule which scripts all objects in all db's using powershell. I'm sure you can find many articles online but this is one I quickly found that...

You have several options

-In SQL 2008 you have the option of using a table as a parameter Link

-You could make the temporary table Global (##temp) and wrap s1,s2,s3 and...

Sorry I should have posted both KB articles. We are on AMD also.

http://support.microsoft.com/?id=983460

http://support.microsoft.com/?id=979149

Microsoft have confirmed this was a problem with the Windows Server R2 kernel which is fixed in this KB article and hotfix.

http://support.microsoft.com/?id=983460

Thanks for the reply.

I have since been working with Microsoft to find a resolution.

Our issue was resolved by enabling the "Lock Pages in Memory" windows security policy on...