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.

I'm trying to set up a parent-child relationship. Some rows will be parents (nId = nParent), and some rows will be descendants (nId <> nParent).

In the past, I've always created...

The important point here is, it doesn't have to go from Access to your final data model in SQL Server in a single step

Import it into a staging table in...