Gift Peddie (12/10/2009)

---

The error you are getting says two things your databases are in compatibility 80 and your application is also old because this problem is fixed for SQL Server...

Kit G (12/10/2009)

---

When I lived in LA for 10 years, it was easy to spot the native Angelinos from every one else when it

a) rained - A few rain...

Bru Medishetty (12/10/2009)

---

Lynn Pettis (12/10/2009)

---

Bru Medishetty (12/10/2009)

---

ray 78019 (12/10/2009)

---

Hi Greg,

If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different...

jcrawf02 (12/10/2009)

---

GabyYYZ (12/10/2009)

---

-3C/27F here (-12C/11F with wind chill)...uggh...

My vacation may not be much warmer, heading to Amsterdam to visit family for Christmas, it's a bit warmer than Toronto, but way...

-3C/27F here (-12C/11F with wind chill)...uggh...

My vacation may not be much warmer, heading to Amsterdam to visit family for Christmas, it's a bit warmer than Toronto, but way windier and...

And now for something completely different, a coworker, non-DBA, forwarded me this link. I thought it was a hilarious Dilbert: http://www.dilbert.com/strips/comic/2009-11-01/[/url]

Edit: Fixed hyperlink

Thanks folks, will trust the data then. Regarding backup sizes, I'll have to modify that as some of our backups are compressed, but otherwise, it looks like I have...

I don't know if anyone else does this, but after every full backup, I immediately generate a transaction log backup. This may be due to paranoia that if a...

Wouldn't the backup fail because of a corrupt table?

CirquedeSQLeil (11/3/2009)

---

Not a fan of direct to tape backup solutions. I like to have my backups to disk and then a tape backup copy the bak file to tape...

Mad Hacker (11/3/2009)

---

While reaing this article I was reminded of an old episode of 60 Minutes on CBS where they were interviewing a professional car thief. When the thief...

For those worried about the loss of keys, do what we do in our company.

Any new or changed encryption key is always in two parts. The security team typically...

I've been wondering if people who accidentally stumble onto the first page of the THREAD and casually go from page to page, not realizing how long it has grown? ...

SanjayAttray (10/19/2009)

---

Very good question. I was asked this question in an interview.

Q). What's the easiest and fastest way to move data of a table from file1 to file2?

A). Move...

Much obliged. Now to figure out which ones to do this on, LOL. We're still patching to the previous hotfix.