Psion (3/25/2010)

---

Thanks for the quick reply. Even though this query ran without any errors, I need the data to be pulled from my table, Answer. I don't know...

Here is the solution using an existing tally table. John just happened to be faster than me this time.

create table #TestTable (

ID int,

...

Okay, the Missing Cert thread is starting to get political under tones as well.

Also, iirc, the TRUNCATE_ONLY option on BACKUP LOG has also been depreciated as well.

Trey Staker (3/25/2010)

---

It is run just before the full back up. It really does no harm exec put a warning in the sql error log. It's the principle...

Is this done before or after the BACKUP DATABASE command?

First question, why was mirroring down?

DDL triggers are also available in SQL Server 2005, as is event notification. Both could be used to set up DDL auditing.

Alvin Ramard (3/25/2010)

---

Lynn Pettis (3/25/2010)

---

Is it me...

Is it me or is she always...

Okay, now show us what you have tried so far to solve your problem.

Gift Peddie (3/25/2010)

---

I have to disagree with you on this. I have issues with people using brain dumps to pass certification tests and I am not Microsoft certified. If you...

Not a problem, you appear to be new to SSC. The biggest reason to follwo the advice given, more people willing to jump in and help, plus you will...

Gift Peddie (3/24/2010)

---

When I got my pilot's license, I had a book with every possible question on the test in it, and it was (and I assume still is) quite...

nick-604971 (3/25/2010)

---

Lynn,

That seems to work like a charm.

Thanks taking the time to produce a working example, its really appreciated.

I will do some real world testing on it shortly to see...