Exactly the answer I was looking for, thanks 🙂

Nice to see the same expert answering my questions all these years on!

Thank you Gila Monster

Just a thought - all procs stored in syscomments right?

Is there a way to back these up in a script before overwriting [PRIMARY] and re deploy them after the load?

I...

Log Shipping wont work, I want the UD functions and SPs to remain as they are on the database B.

These must be in the same DB if possible.

Sorry but I...

Thanks for your suggestion,

DB Mirroring is not an option as I dont want the overhead on Server A - the load must be totally offline.

The reason I want to backup...

Hi chaps

Thanks for your input but I think you are missing my point.

The code is made up,

The end user is not the best at writing efficient SQL and I wanted...

Great, thanks very much!

Hi

In my experience the TCP endpoint address is not always tcp://servername:5022

If your host has a DNS suffix i.e the fully qualified domain name is "servername.ssc.com", the endpoint address will be...

To be fair to her she is working with a lot of data and she should have her own datawarehouse environment.

This is not possible at the moment.

Even if the queries...

The stored procedures she is writing mostly consist of

create proc uspHogTheServer as

select * INTO #tmpHumongous from Massive

INSERT INTO #tmpHumongous

select * from Gigantic

SELECT * FROM #tmpHumongous

go

So I would get her to...

Gail

To clarify your solution would be to run something like this in the same query window?

(I would have thought the setting would need to be above her TSQL code?

execute uspHogTheServer

OPTION...

Animal Magic,

There is no chance that a fixedcharge (child) record could be created before the Customerlevel(parent) record in this instance as the application logic prohibits it.

I will look in to...

Does anyone know the answer to my original question -

Does SS Replication is do a DELETE and INSERT of the record, rather than doing the UPDATE which I would expect...

Thanks Ed.

I will time synchronise, restore both full backups and both subsequent transaction logs up to the STOPAT point.

Cheers

Rich

Thanks for the reply,

FixedCharge does not and cannot exist on the publishing database in this case.

It is a static table on SQL094 and not part of a subscription.

So I think...

Cheers guys -

EdV - this was also RedGate's suggested solution.

Looks like Im going to need to work on some backup scripts to streamline this operation.

Cheers