doobya (7/7/2010)

---

Grant Fritchey (7/7/2010)

---

You're dealing with a fundamental change in behavior. If you're raising errors inside the procedure, the errors are recognized by the TRY/CATCH construct, as designed. That's how...

You're dealing with a fundamental change in behavior. If you're raising errors inside the procedure, the errors are recognized by the TRY/CATCH construct, as designed. That's how it's supposed to...

Sounds like the database might be in FULL recovery mode but you don't have log backups running, or possibly, the log backups are not running frequently enough.

But if you have pre-existing procs with established and functioning logic, why are you changing them to use TRY/CATCH at all? I would only suggest rewriting them as needed and...

There are limitations. One of the first you'll need to take into account is the fact that the transactions are running through DTC as distributed transactions. That alone limits what...

muzahm (7/7/2010)

---

Hi,

Is it a good idea to blindly apply all the indexes suggested by dm_db_missing_index_details.

To put it in other way, does dm_db_missing_index_details suggest you all the indexes that you database...

WayneS (7/6/2010)

---

Jeff Moden (7/6/2010)

---

CirquedeSQLeil (7/6/2010)

---

WayneS (7/5/2010)

---

Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of the Threadizens...

I've...

HardCoder (7/6/2010)

---

Gianluca Sartori (7/6/2010)

---

BEGIN / END delimits a block of code, without controlling a transaction. If not already inside a transaction, each statement will execute in an autonomous transaction. Typically...

I've only used it in testing, like yourself. I've found that it doesn't grow any worse than other monitoring software that we use (Idera & Microsoft Operations Manager). It just...

Gail's already pointed you to the best resource, Books Online, but the second best resource on the general topic of Trace, Trace Events and the Profiler is Brad Magehee's book.

Which of the three answers helped? Just asking so someone else finding this thread on a search knows how to solve their problem too.

WayneS (7/5/2010)

---

Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of the Threadizens...

I've been contemplating making a...

I've done multi-day training sessions... with secretary's & other non-technical people....

Steve, I will be submitting an abstract for a pre-con at the Spring PASS event.

Jeff Moden (7/2/2010)

---

Hey Grant! What day is your local Pass meeting on in July? I'm going to be in lil' Rhody from the 11th to the 17th and...