Alvin Ramard (5/21/2009)

---

Lynn, is there...

Are we talking about our...

Would anyone mind if I asked him how he got this job if he can't even figure out how to read error messages and complete simple tasks?

john.arnott (5/21/2009)

---

I don't have the old QM anymore, but in my SQL2005 SSMS connected to a SQL2000 engine gives the same behavior, including the interpretation of "E"xponent notation. Interesting...

RBarryYoung (5/20/2009)

---

Lynn Pettis (5/20/2009)

---

As long as you remember this...

Unfortunately, no. Something like that just might be useful but not sure how it would be implemented.

I would also look at increasing the frequency of your transaction log backups from every hour to every 15 minutes. I would also consider adding an alert that would...

Too Cool!!

I agree, great way to mess with someones head.

As long as you remember this one Cardinal Rule:...

Bruce W Cassidy (5/20/2009)

---

Jeff Moden (5/20/2009)

---

Take Lynn's original advise... The third operand of ROUND will allow you to truncate instead of round. Heh... look it up in Books Online....

Here is one I found with a Google search, http://www.mymathforum.com/.

If that one doesn't work, try Google to find some more.

john.arnott (5/20/2009)

---

Jan asks

I thought of that but didn't dare dip my toe in that pool. How funny would it be...

nimmi.smith (5/20/2009)

---

Lynn: You hit the nail right on the head. That is exactly what he is looking for.This is a tiny shop. There is no front-end developer. Just myself...

I have to make a plug here. If you find yourself needing to go to compressed backups, look at HyperBac. It can be installed and configured to compress...

nimmi.smith (5/20/2009)

---

He has multiple box sizes and multiple bottle sizes. I will have him give me the the physical dimensions of the bottles, not their volume and repost the...