look in the snapshot log and/or the sql server logs, something is (or is not) happening as it should.

How big is the database? It could take a while to push the snapshot over there if its big, in which case you might want to just backup and restore...

I have never seen a case where permissions fail to 'stick' without someone or something intervening.

Having said that, being a member of the datareader/datawriter roles does not give execute permissions...

see my edit.

In earlier versions I used to reset the replinfo flag in sysobjects. But there may be a better (i.e. safer) way in 2008. I haven't had to do this...

Steve Jones - SSC Editor (5/9/2012)

---

Then this doesn't fit for you. Certainly once you reach a certain scale of server and application, this doesn't make any sense, especially financial sense.

However...

"...And they'll even handle the backups automatically for your new database. "

making backups is only 1 tenth of the infrastructure involved with hot standby-failover or DR procedures which typically have...

You don't need a cursor for that. That is one thing that is slowing you down.

.Netter (5/7/2012)

---

Its not in the company standard its my line manger which has said its the number 1 rule every SQL person follows, which i did find hard to believe...

GSquared (5/4/2012)

---

ken.trock (5/3/2012)

---

I'm with CrankyRat on this one. Maybe not the Glenn Beck part 🙂 In the last 10-12 years here in the USA we've seen internet bubbles, mortgage meltdowns,...

Personally I prefer to avoid the use of triggers wherever possible. The can have adverse side effects and cause performance and concurrency issues.

Having said that, they can typically be added...

I think XML has its place but it has been over-hyped and inappropriately used in various situations.

The product requirements should clearly indicate that using XML (for whatever purpose) is advantageous...

CrankyRat (5/2/2012)

---

Jeez, I'm listening to a lot of Fox news and Glen Beck devotees. What nonsense, no one in Congress said any such thing. They'ed be out on their butt...

Excellent analogy.

I happen to think people that believe government has their best interests at heart lack...

MdApache (5/2/2012)

---

I used to be a strong believer in regular funding of my retirement account, but now I'm less likely to do so. The finances for the USA are...