Tom.Thomson (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit...

Why do I not believe you on that point? 😀

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit of...

You can join them if you query the TVF in a derived table. More commonly, you can Apply them. For details, look up "Cross Apply" and "Outer Apply"...

Trey Staker (7/25/2011)

---

Speaking of superhero type movies, I rented "I am Number Four" this weekend and watched twice. I really enjoyed it, I rarely watch a movie more than...

The way I've done this before is use tags in the body to indicate the parts that are going to be built, and then use replace statements and select statements...

Right-click the publication and "reinitialize all subscriptions", select the option for generating and using a new snapshot.

It would make sense to use FTS for that, but instead of defining all the combinations in the AlternateText column, build/buy/find a custom thesaurus for names.

If you look at the...

john.arnott (7/25/2011)

---

Would it be OK to submit this as a QOD?

Question:

What's the answer?Answer choices:

It depends.

It doesn't depend.

What's the question?

I think there's a tpyo in here so I can only guess.

There...

mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master"...

Here's what MSDN says about severity 20:

20-25

Indicate system problems and are fatal errors, which means that the Database Engine task that is executing a statement or batch is no...

halifaxdal (7/25/2011)

---

I got this idea from Mark Armer, I agree that in some/or many cases SQL cannot be stopped however I still think his idea is surprised, unexpected and workable...

Okay, now that I have a better idea of what you're trying to solve, my suggestion would be have the trigger pass values to web service on the other server,...

GilaMonster (7/25/2011)

---

I just had a fun one. Told someone that they shouldn't run Backup log with truncate only as it breaks the log chain. So they reference an article that...

If you don't like running them through SSMS for whatever reason, you can run them through the command line. That'll allow you to keep the databases online and the...