Jeff Moden (2/15/2008)

---

If you have line numbers greater than 255, you will need to build a Tally table instead of using Master.dbo.spt_Values.

Also, the above code uses a limited cross join...

One of my favorite quotes is in my signature block. Was quite fitting during a transition I made a year and half ago. Also fitting for the work...

Matt, thanks for the quick response. I don't...

After serving 14+ years in the U.S. Air Force, I definitely concur with the previous comments about military leaders. While I was in the Air Force, I was able...

Jeff Moden (2/12/2008)

---

Ian, my apologies for the delay in this matter... please see the attached. Also, keep in mind that "XXX" throughout the document is where the company name...

I have tried restarting the server after changing the account (per Steve) and that didn't have any effect. I have also restarted after setting the services to restart the...

EdVassie (2/7/2008)

---

The SQL Agent option 'auto restart if service stops unexpectedly' performs the same function as the Service applet auto restart function, but does it in a different way.

In order...

Steve - thanks. Per your advice I have changed the account to mine and then back to the service account (system). I can't restart this server now, but...

Thanks for your responses. The account is enabled with no expiration on the password. There has been no problem logging into QA with this account that I know...

Great article, I have already put this in my "Briefcase".

During one of my assignments while I was in the Air Force, I was part of a Quality Assurance team for...

I would have to say Colin Powell. I heard him speak a couple years ago and he is an incredible speaker - very energetic and enthusiastic. If you...

leokarp (1/17/2008)

---

Chong,

There are problems in your code.

1. If CommandType is set to stored Procedure then CommandText should be the name of the Stored Procedure being called without any...

Steve Jones - Editor (1/12/2008)

---

I tend to agree with Bob that lower prices works and it gives them an advantage, though I'm not sure it's good overall for the world.

I...

Chong,

I am not sure if the names need to be the same or not. In my application, I changed the name of a parameter and it executed just fine....

Jeff Moden (1/8/2008)

---

We've actually put sime "documentation standards" into play at work. They're not so limiting as to suppress innovation, but they do state what must be documented within...