It's not to do with permissions. In modern versions of Windows, you can't interact with the UI associated with the SQL Server Service Process - remember that XP_CMDSHELL is running...

Nope, you can use it as you wish, commercially or otherwise. Maybe the installer failed and rolled back? If you're installing it via the normal installer, there should be a...

raotor (5/21/2012)

---

None of my DB's use auto-shrink, so there's no...

You should disable Auto Shrink entirely on all databases, it's terrible for performance as it causes loads of fragmentation.

When running the command manually, there's a parameter you can specify...

GSquared (5/18/2012)

---

mtassin (5/18/2012)

---

Gazareth (5/18/2012)

---

dwain.c (5/18/2012)

---

I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy,...

AlAndrew (5/18/2012)

---

michael vessey (5/18/2012)

---

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from table_2 where userid=x.userid...

You haven't provided sample data, but something like this should do the job:

;WITH Latest_Age AS (

SELECT UserID, Age, ROW_NUMBER() OVER (PARTITION BY UserID, ORDER BY RecDate DESC) rn

FROM Table_2

WHERE Age...

dwain.c (5/18/2012)

---

I must conclude that somehow I must have mucked it up then.

The only difference was that I wasn't doing an INSERT.

I'll have to give it another go sometime because...

dwain.c (5/17/2012)

---

GSquared (5/17/2012)

---

If you want to mess around with it a bit, it occurs to me that you could use an Output clause on a Merge statement to end up...

Hi Barry,

That's interesting. Here though, its not just the ordering that's incorrect, the entire accumulated resultset gets discarded, so it just doesn't work.

This does crop up every now and...

Happy to agree to disagree. I don't think the article refers to accumulating functions being used in that way. The syntax exists as an alternative to SET, so you can...

Matt Miller (#4) (5/17/2012)

---

HowardW (5/17/2012)

---

Hmm, hang on, that article was based on SQL 2000. It's the same argument with the "Quirky Update" running totals solution in that it relies on...

Matt Miller (#4) (5/17/2012)

---

I am not sure how you're jumping from the "it will not use predictably any ORDER BY" to "it's not documented at all". While it might not...

Well, there's no fundamental barrier to creating an SSAS linked server to the same server as the RDBMS instance, you just have to give the linked server a different name,...

gemisigo (5/17/2012)

---

HowardW (5/17/2012)

---

The problem here is you're relying on an undocumented and unreliable use of variable assignment in a select statement.

There's absolutely no guarantee that the variable assignment will occur...