I've had less coffee this morning than is probably prudent, but it seems to me there's no script in the article. 🙂

Not sure if it's just a typo when posting on the forum but the double equals in this line doesn't look right:

$dbLogFile = = new-object -typename Microsoft.SqlServer.Management.Smo.LogFile -argumentlist $dbObject, $loglogname

I...

Nope, aliases don't work either.

Yes it is.

As I said, I can connect to a whole bunch of other SQL2K5 servers, it's just this cluster in particular that I'm having trouble with.

We use simple names for the actual server names:

SQL01

SQL02

And a descriptive name for the cluster group:

SQLCLUST

With a "v" to visually distinguish the virtual names:

VSQL01

VSQL02

It seems like all the function calls are a bit overkill IMO, unless I'm missing how they handle some edge-case.

A simple

ORDER BY len(column), column usually works for me for...

Books Online says "This statement must be executed as a separate batch." so I'm guessing you can't do what you're hoping for.

This would work however:

DECLARE @sql NVARCHAR(255)

SET

Quick and dirty from what you've got already is to use your existing query as a subquery.

SELECT

company,

year,

sum(q1amt) 'Q1',

...

Yeah, setting the isolation level in each proc is what I've been doing. I was hoping there was a better way.

Oh well, thanks for the confirmation.

This sounds like it's better asked at the myLittleAdmin forums: http://forum.mylittleadmin.com/

I'm wholly unfamiliar with MyLittleAdmin, but I would (wildly) guess the lack of those icons means you lack...