There is TONS of good information here on SQL ServerCentral. The challenge is to find what you need without getting bogged down in all the other interesting information here.

Sounds...

You will definitely need to work with them to test a full system restore. This will probably sound like an overly simple question, but do you move the backups...

Anye Mercy (5/8/2009)

---

Two more bits of empirical evidence in favor of having a degree, regardless of what area of study:

1) I've been told more than once that the fact that...

Alvin Ramard (5/7/2009)

---

steve smith (5/7/2009)

---

Alvin Ramard (5/6/2009)

---

GSquared (5/6/2009)

---

Maybe I have the volume on my speakers turned down to far, but I haven't noticed anyone's avatars making any noises at all......

Perhaps try adding 'DISTINCT' to get rid of some of the redundancy? I did not test it; it's a thought.

In a SQL...

tosscrosby (5/6/2009)

---

Lynn Pettis (5/6/2009)

---

Bruce W Cassidy (5/6/2009)

---

[font="Verdana"]Does anyone remember a language called Algol? I believe that in the original form, it had no concept of "reserved words", so it...

Alvin Ramard (5/6/2009)

---

GSquared (5/6/2009)

---

Maybe I have the volume on my speakers turned down to far, but I haven't noticed anyone's avatars making any noises at all... (cuz I'm a blonde,...

General observations as I wind down my day:

1. The value of a college education is not in the nature of the degree, but the kind of personal growth you...

"codingsanity" - sounds like an oxymoron. Sanity is what you have BEFORE coding. If you're lucky, you still have a...

Wonderful article. I followed you completely up until almost the last sentence - where you used the ambiguous term 'opposite' in the Q&A section:

'Scripting the database will work wherever...

Point well taken. Thanks Noel!

Noel, that's true. However, snapshot replication is much more forgiving. By dropping the article (i.e., table) out of the replication, you can then modify the keys. In...

Noel, I'm old school. Give me a command line any day. I've constantly exasperated with the inability to get at the underlying coding that goes into so many...

When you say script 'everything', there are caveats there: If there are pull subscriptions, they are scripted on other systems than the publisher. Even with push subscriptions, you...