In my mind, this is your ethical/moral boundary. I can't decide that for you, and different beliefs/religions/etc draw a different...

I think I depreciated the other answers 🙁

Didn't check them, have gotten...

Mary.Stephens 54133 (8/15/2011)

---

THANK YOU STEVE, I knew there was a reason I like you. Using ethics to make a decision far outweights the morally corrupt "ya, but it's not...

No. Haven't had the $1mm,...

Stefan Krzywicki (8/15/2011)

---

Steve Jones - SSC Editor (8/15/2011)

---

Grant Fritchey (8/15/2011)[/b

What bothered me about it was that he wants to do it short term to make lots of money while he...

Grant Fritchey (8/15/2011)

---

My bigger concern is that he hates technology. Good god, why do it if you just hate it. Especially if, you're actually not doing it yet. "I don't...

Interesting, I'd never used ALL.

You could wrap in ISNULL to handle NULLs, and return zero's instead (or some other value).

If @a = @b-2 and @a = @c, then @b-2 = @c by the transitive property.

Profiler is a great way to help. The other thing I'd suggest is that you start building documentation as you go. Note what you think tables are used for and...

Jobs fail or don't run sometimes. There is no guarantee that a job restarted your server every day.

I have had a few people claim the limit is 99 logs which...

The import/export wizard is the easiest way.

There is no copy/paste function you can use. Any other method, outside of a third party tool, will be slightly more complicated.

First, even if you uncheck that box, I'm not sure SQL Server keeps an unlimited number of logs. I haven't found documentation and don't really want to restart an instance...

Sorry, didn't realize you're posted that. Just so we're clear, you have log shipping set up on a primary and secondary server. The primary server (source) has logs set to...

Brandie Tarvin (8/12/2011)

---

Steve Jones - SSC Editor (8/12/2011)

---

Is anyone here working with, or struggling to

- work in a complex development environment that does automated builds at high volumes (> 1x...

I wouldn't think log shipping would require a restart. If you check the log shipping tables, are your settings changed?