hmmm, leaving us with the problem of altering the database before applying the transaction logs.

Looks like log ship, recover and then apply replication it is then.

Mike,

That's what I thought too.  Here's another one.  When log shipping a replicated database (merge repl.) is it possible to have replication ready on the secondary before changing roles or...

A-haaa.

Is there any way of preventing this as the query is pretty hefty and changing tabs becomes very much a thumb-twiddling event?

Thanks

DeltaKilo

"Changes Tab", when she is setting the transformation properties and she changes from the "general" tab to, say, the "Destination" tab. As far as I know they're not using...

Global. It's a head-wrecker!

David

Hi Michelle,

The funny thing is we do have it working on a Win2k machine so I believe it should work.

My problem with the last option is that this radio button...

Hi Don,

Sorry, I didn't really make my question clear; is it possible to have them expire automatically and if so how can I do that because that would be extremely...

Here's the gist of what we're trying to achieve.

We periodically allow developers (devs) to have dbo or even sysadmin access to our servers and that considered okay. What's not...

"Begin and End date"-- glazed look. I don't understand; there is going to be a lot of that in this thread let me warn you!

We had thought of just...

Thanks Steve,

That's helpful. Have you any opinon on the overall strategy, good, bad or indifferent.

David

Hi,

I've got a similar problem, but I've already used the backup file on another server and the restore works fine. Any suggestions.... I'm at my wits end and feeling the...

Hi Andy,

Is there any administration that one should be performing on these or are they just to be ignored.

DeltaKilo

Hidee Ho on this Friiiiiday morning,

Just thought I'd let you know that I removed sysadmin rights from the builtin group two days ago with no negative reponse. It still has...

Thanks Wootton.

I'd read most of those already and I'm quite happy with doing this. However our NT admin isn't and that's because they're not comfortable with clustering. I...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q293646

And you should see the leak. If we don't kill the dllhost.exe in the morning before production it will gooble up memory (5-600MB of 1GB by early aftenoon). Quite...