Oleg,

Well spotted, thanks for the advice. Running in "Results to grid" mode worked a treat. Fantastic.

Matt

Scripting in binary format is a great idea, however the script is failing for some reason with this table:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[EcsPurAccount](

[id] [int] NOT NULL,

[reference]...

Surely you don't need to apply the snapshot if you already have a copy of the publisher? Just uncheck the Initialize checkbox. Or am I misunderstanding you?

Matt

I seem to remember there is a filter option you can use when you create your publication. I did you use this?

Matt

Thanks for the answer, its reassuring to know that my question made sense at least.

I guess you are right, if the principal server is generally one particular server then...

HI there,

Did you find a solution to this problem? I have come up against the same thing. My Version is 9.00.3054.00. The only strange thing I know of, is that...