Take a look here, this might help.

http://home.att.net/~codeLibrary/XML/rss.htm

This hour of the night my brain is only picking up about half the info. What is it you specifically are concerned with. SQL supports various security such most handled...

Your going to have to use ActiveScripting and the VBScript examples you saw. We have something doing this now and I can share the code just email me, however keep...

Are you getting an error message and have you checked the install log file?

By default, the Setup.log log file is created and stored in the systemroot folder(typically C:\Winnt).

Since you are using Active Scripting loop the the Worksheet objects to get the name and place in another variable. I don't have sample code here but email me I...

Right off the only way I see is to do your query as a sub select and an other selection with SUM.

Select

School,

Sum(GK) GK,

Sum(G1) G1,

Sum(G2) G2,

Sum(G3) G3,

Sum(G4) G4,

Sum(G5) G5,

(

 Select

 Distinct LC.LocationDesc...

From SQL BOL

Configuring the Web Assistant Wizard

Before running the Web Assistant Wizard, you must:

• Set appropriate permissions.
• Choose the database to publish.
• Create queries.

Setting Permissions

To run the Web Assistant...

WHat version of SQL and have you condsidered using ActiveScripting to get both the records and the count so they are guaranteed to match up if get the record count...

On a 4GB machine the only way to use more than 2GB of RAM for applications is to have the /3GB switch in place as the Kernel is going to...

Actually you would need to add the WOTH RECOMPILE statement to your SPs declaration or most will suffer performance issues worse than Dynamic SQL. Otherwise should be similar in speed...

For the most part as long as the machines name doesn't change there isn't anything to do. However if you are running the SQL Server or Agent under a domain...

As the queries are exactly the same is it being run in 2 different databases on the same serevr? If so then try.

SELECT

DB1.*

FROM

(

SELECT     Projects.ProjectName, Tasks.TaskName, Customers.CustomerName, Groups.GroupName 

FROM         db1..Tasks INNER...

Sorry wasn't sooner.

AWE isn't the issue here. With 4 GB of memory the address space is split 50/50 between user mode address space (first 2gb) and kernel mode address space (last 2gb)....

You cannot.