I'm not sure mirroring or log shipping work if this is a local server being read only for online work in an application. Updates for both of those will cause...

your question is not clear, and your pattern does not make sense.

Are you trying to have a value in the column "alias name" increment with letters? On insert or are...

You have some data in that column that does not convert correctly. That's the overflow.

No matter what you think, this is a common error and a reason why you store...

Interesting, and thanks to the Hugo for digging into SMSS. I never expected the tool to override the behavior of the system.

Points awarded back, and the question clarified to say...

You don't know enough independents. I can name 10 off the top of my head that are the sole wage-earner for their household, and easily make over US$100k a year.

You...

Excellent point.

Haven't found any great resources for other DBS, other than the StackOverflow sites. Not sure why, and I've been tempted to work on one, but it's a time/resources issue.

Exchange -...

I tend to agree with Gary. The overhead is always there.

As an independent you have to allow for it. You still get sick leave and vacation, you plan for it....

It's not clear what you are trying to do. Have you looked at the datepart functions?

That's great. We can put the ark out here at the ranch.

Clarified the explanation with a note on minimally logged operations. Also added an "always" note to the answers.

Grant Fritchey (2/21/2012)

---

As far as the apathy goes, most people are apathetic about almost all their basic rights. I'm pretty sure a healthy majority of people would be willing to...

I suppose the host could change the rules, but...

ksharpe (2/21/2012)

---

in Canada we had Family Day yesterday - Ontario, Alberta and Saskatchewan only - leaving only March or April, depending on Easter, June and November without a stat holiday...

Ahhh, apologies. Meant to say...