"Make the point to your boss and (if possible) the owner of the company that once multiple people know the password, they could inadvertantly give it out to someone who...

Great article, Jeff. I've forwarded the link to my colleagues. We all need to be reminded once in a while that, no matter how hard we try, we...

Jeff Moden (1/2/2008)

---

This is the fastest/shortest method for finding gaps I've ever seen and it does not use any Temp Tables or Table Variables. I wish I could find...

I heard that they...

Do you have another box where the service is running normally? If so, look at its service account and give the account where the service is failing the same...

"I didn't have any issues with connecting and taking a long time with the other databases, regardless of being on the same host computer or a database on a remote...

Hi, James. I couldn't determine from your description if you have other databases on this SQL Server or if you access other SQL Servers from this SSMS. If...

Hmmm... The Fionavar Tapestry. It's been a while since I read that trilogy, I'll have to get it back out. Yes, it is very good.

Jeff Moden (12/21/2007)

---

The seed should probably the value returned from the NextID proc...

Other problem is, you have to increment the NextID in the NextIDtable by the number of rows you...

Jeff said: "They do a heck of a lot of unnecessary locking... like I said, I'll see if I can come up with a working example of how sequence...

James said: "Bad movies I liked:

Meet Joe Black. I know this one was panned bigtime, but I liked it. It probably made some lists as one of the...

I agree. According to BoL the sp_addserver even allows for...

For a real rollercoaster adventure read The Judas Strain by James Rollins. He's always good for a thrill-a-minute. The basic premise will scare your pants off. (Read...

Jeff Moden (12/20/2007)

---

DonaldW (12/20/2007)

---

GilaMonster (12/19/2007)

---

Jeff Moden (12/19/2007)

---

I didn't know how long it originally took and, like the bumble bee who doesn't know it's not supposed to be able to fly,...

GilaMonster (12/19/2007)

---

Jeff Moden (12/19/2007)

---

I didn't know how long it originally took and, like the bumble bee who doesn't know it's not supposed to be able to fly, I rewrote it......