Grant - whoops, sorry, just seen how old this is!

Pam,

You might want to have a look at this presentation from the SQLBits conference (the one before last) by MS Certified...

Great - thanks for the help!

Alvin Ramard (10/26/2010)

I can't confirm, but I believe you're correct.

Another option is to recreate the DSNs on your computer. That means you have to install those drivers used by...

LutzM (10/25/2010)

---

Hmmm...

I've re-run your code and get the same results now.

Must have been a problem with my system back then - either the part behind the screen or in front...

Odd - it returns the expected result for me. I've triple...

Ah - I've got it (needed SUM instead of COUNT). Doh!

select #usl.userid, #usl.approved, count(distinct #usl.skillId) as num_skills,

sum(case when s.rnk = 1 and s.skillLevel < s.TargetLevel then 1 else 0...

Typing "waist" instead of "waits"

If only select * from sys.dm_os_waist_stats returned 24" like it used to...

Thanks, will do.

select name

into #MyNewTable

from sys.syscolumns

where id = object_id('dbo.MyTable')

How does one inform MS Product Support about something like this without starting a support call and incurring costs?

No, I haven't. Do you think this is a "feature"?

I've had this issue before, with database names that either contain dashes or start with a number.

Use the square brackets and that should be okay:

ALTER DATABASE [Blah-Blah] ...

Jeff Moden (9/20/2010)

---

mazzz (9/20/2010)

---

Jeff Moden (9/20/2010)

---

mazzz (9/20/2010)

---

Jeff

I've just seen your update in the OP - do you need any more results?

My home setup is Win 7, Intel core duo CPU,...

Jeff Moden (9/20/2010)

---

mazzz (9/20/2010)

---

Jeff

I've just seen your update in the OP - do you need any more results?

My home setup is Win 7, Intel core duo CPU, 4GB RAM, 64bit,...

Jeff

I've just seen your update in the OP - do you need any more results?

My home setup is Win 7, Intel core duo CPU, 4GB RAM, 64bit, SQL2008 R2 if...