Great!  Results look good...

The result is actually a derived set from system tables.  I've just been scratching my head how to get rid of those duplicates.  Should've posted this question...

When you execute it manually and it's successful, is it from your workstation or logged into the server?

Executing from your workstation could be invoking components local to your PC that...

Yeah, the code I posted wasn't exact, and only included the "meat" of the code.

Thanks for comments. I didn't know about the 4000 record limitation. I'll have to take a...

I'm almost 100% sure I did just that, but you got me questioning myself.

I've never called WMI through SQL before.  Always been through VB.  Can you provide any details about the error?  Or how you're performing the query?

No, not yet.  We moved reporting services to its own website, and it still came up with the same error when not mapped to "All Unassigned". 

Some of the documents and...

fyi, I found the problem, here's the resolution...

IP Address Mapping

Reporting Services requires that the default Web site IP address is mapped to (All Unassigned). To verify this setting,...

No, that service wasn't even running.  I started it (with it still under the Local System account) and tried the setup... it failed.  Changed the service account over to an admin account,...

Each build should come with its own "Build Uninstall Wizard"

From the CTP download (or Beta CD) find sqlbuw.exe, it should be located under the "Tools\Setup Tools\Build Uninstall Wizard"  I'm pretty sure the...

Quickest and easiest way is to create a database maintenance plan, and schedule it to run after your inserts.  You'll find it under the Management folder in SQL Enterprise Manager.

Thanks for the reply... yeah, I ran into that article already.  We're running SQL2000 sp3a.

According SQL 2005 BOL, (search "Install Messaging Objects" on BOL) Service Broker is required for Database Mail (aka SQLiMail) functionality.