Transactional replication is the best way to do this. The regular disconnections required by Log Shipping are no end of frustration for end users.

Keep in mind, however, that you need...

I whacked our movie channels to save $20/mo when we got Netflix streaming. A month later my wife was upset with me. Not enough of a selection for her on...

Evil Kraig F (12/9/2011)

---

We might have a slightly different perspective on this since I once was a janitor. You want to pay me my contract rates to grab a...

IceDread (12/9/2011)

---

Well.. I would probably had said no a year ago.

This year however, my boss told me he was thinking about having me take over some share point tasks...

bitbucket-25253 (12/8/2011)

---

Steve - suprised at you for letting us off so easy at the end of the week - or was this a TGIF (Thank God Its Friday) to all...

Revenant (12/8/2011)

---

I think I could make an argument that humans share some of what we call 'morals' with other species of mammals; for example, special consideration for mothers with babies....

Tony Palmeri (12/8/2011)

---

Some of us don't think so.

But that topic is *way*...

Jack Corbett (12/8/2011)

---

Brandie Tarvin (12/8/2011)

---

So with this Redmond report about IT losing jobs this year, and possibly next year, how upbeat or pessimistic are you feeling about the industry?

It's...

I dislike global grants, so while Lowell's solution is the simplest, I prefer that you specifically grant to each sproc/function, as Anthony showed.

We have, might do so again. Writing a test is hard. And it's fraught with hassles from people that complain.

I kick around now and then, so we'll see.

I think that some delay in reports is good. If a severe flaw is found, it's absolutely possible that x, say 10, criminals know about it. Therefore we have 10...

paul.knibbs (12/7/2011)

---

You might not consider...

Elliott Whitlow (12/7/2011)

---

But TDE doesn't help with replication, it only protects data-at-rest and as long as the database server is up you have no visible encryption. So query the...

Fair enough, but does it hurt to have it in Express? I'm not...

There won't be a message. You can try digging through the fn_my_permissions function to find this.

Can you grant these rights to a new user, someone that you create for testing...