The only wait type I can see is CXPACKET which I tried to get rid of by altering the threshold value but no joy there.

As far as I can see,...

Oh well, looks like more fun and games with that then.

Thanks Steve. That's given me something to think about then.

Apologies if this is a stupid question, but would be similar to transaction log shipping?

I did float that idea (about trans log shipping) (some of our transaction logs are ridiculously...

So that would mean we can't add indexes without adding to the "original".

Oh well, back to the drawing board......unless we use another method.

Any suggestions?

Hi Gail

We currently use mirroring from Server A to server B and then take a snapshot so we can report from it.

We're wanting something we can read from directly rather...

Hi both

I've realised I've made a mistake in my original post and all the servers will be on SQL2012 (just different editions).

What we're wanting to do is this:-

Server A will...

Thanks for that, it clarifies that bit at least.

Unfortunately, when we set the server workspaces as default and unchecked allow multiple checkouts, we could still both open, change and check-in...

We've done that on two machines and set it to use server workspaces as well but it's still trying to use local copies instead of the server versions.

I get the...

Ah, sorry. Forgot that bit.

We're currently using Visual Studio 2010.

Hi Luis

You solution seemed to run into the same issue as Chris's (a slightly out of sequence ward location).

I'm just testing out the adjusted version from Mark and it looks...

Thanks both

I'm testing both and they are very close to what I need.

Chris - yours is closest to what I need but I have found a bit of an oddity.

When...

I'm working on a couple of assumptions here that are:-

1 - you can't just delete the linked server and put it back if necessary

2 - the connections are made through...

Thanks for the replies folks.

Luis - Inside the TRY block would be the DROP statement. Inside the CATCH block would be the CREATE statement.

Thinking about this logically, we'd need...

Thanks folks.

We've (just about) agreed on the functional issues.

Now we're looking at the formatting to make everything look identical and make it easy to follow.