george sibbald (1/10/2009)

---

cheers...

In addition to Steve's advice I would recommend that you prepare to do some manual changes as well. You may be able to get it ALL right via programming,...

I second everything that Jerry said. Anytime you are making changes to your SQL Server you should backup everything. Don't forget the resource database as well. See...

I've got no experience with Oracle, but SSIS is designed for these types of tasks.

VC - Venture Capital.

There may be a better way in 2005, because I am not familiar with all the DMV's, but sp_lock will show the resources locked and accepts a SPID as a...

First you need to enable and set up database mail (look it up in BOL) and then you need to enable the mail profile for SQL Server Agent. Under...

WILLIAM MITCHELL (1/9/2009)

---

I am lucky at my current position, we hit 9.5 out of 10.

The only partial exception is #3 because Vista stinks, Office 2007 stinks, and SQL 2008 is...

Wow, I think this may be a record for editorials.

I have one more comment, Image is not just appearance, it is also attitude and getting along with others. Being...

Jeff Moden (1/9/2009)

---

Jack Corbett (1/9/2009)

---

Grant Fritchey (1/9/2009)

---

Jack Corbett (1/9/2009)

---

Steve Jones - Editor (1/9/2009)

---

I'm with Grant, heat, heat, heat.

I like skiing, but other than that, I'd like warm weather all the...

I wouldn't go that far, but thanks and you are welcome.

You are not getting the result you want because the format you are trying to get to is a time format and you are trying to format a numeric to...

Your issue is this statement:

case [header].[Document Type]

when 0 then 'Quote'

when 2 then 'Sales Order'

...

Grant Fritchey (1/9/2009)

---

george sibbald (1/9/2009)

---

from...

It may be awhile before I get to an example as I currently don't have SQL Server 2005 easily available. I will post an example on this thread later...