Wow, good to know.

It appears you can use an ip address, perhaps that will allow you to move forward while they debate changes to the naming convention.

Try with square brackets? [server-name]?

As a DBA and occasional AD admin, Powershell considerably simplifies my life.

Goodbye .bat, see ya later mmc AD. SQL OLE Automation was, IMHO, nearly unusable.

I do have the luxury of...

Same here. I had a quick look at Tableau BOL, I must say, it seems a little obscure to me. Or maybe I also need more coffee.

Sure you can: My AD account does not have a Windows SQL Login, but I am a member of a group that does.

SELECT SUSER_NAME(); returns me (not the group).

go

-- ...

It is possible, if the login you're using has the correct permissions. See EXECUTE AS in BOL.

Yikes. Thanks for pointing that out Jeff.

I've only (reluctantly) used it with very small sets, mostly in pre-2K5 code.

I'll be checking my code now...

How about:

IF OBJECT_ID('MyTable') IS NOT NULL

DROP TABLE MyTable

GO

SELECT * INTO MyTable

FROM (VALUES(1,19), (2,90), (3,20), (4,8), (5, 9)) AS M(ID, VALUE)

GO

SELECTm.Id, SUM(m2.Value)

FROMMytable m

JOINMytablem2ON m2.ID <= m.id

GROUP...

Right. And I didn't have RPC:Starting in my trace definition. Well that explains it.

Thanks!

P

In my experience, it's the front ends that come and go, back ends tend to be more stable. Granted there has been a bit of a shake-up with the availability...

This might help: psftp has a public key option.

http://the.earth.li/~sgtatham/putty/0.52/htmldoc/Chapter6.html

Yeah, I know it's a cmd hack, and you're right, it'll only work for a single response.

In my particular case, that's all that would have been required.

I got around it...

Hmmmmm.

I found this on the net; the author plainly states it's a bit of a hack, but also claims to have made it work for him. I've not been able...

In fact, neither works when inserting >1 parents.

I was simply wondering if I could save myself some code and a step with some fancy DRI.

Now I see that while it...

Thanks Sean.