Did you actually run this in QA? You can't passcolumn names as parametersto a TVF in SQL 2000! In SQL 2005 you can do it via the censored operator.

Believe it Seems intuitive, doesn't it? But of course it's not. This is one of the issues fixed in SQL 2005 with the censored. For the example you...

sp_addlinkedserver  @server = 'additional_server', @srvproduct = N'SQL Server'

You might have to play with the parameters (sp_addlinkedserver has up to 7 of them).

Did you already try something like this?

demoPath="Provider=SQLOLEDB;" & _

"Data Source=domain\myserver;Integrated Security=SSPI;" & _

"Initial Catalog=qdb"

Or

demoPath="Provider=SQLOLEDB;" & _

"Data Source=""domain\myserver"";Integrated Security=SSPI;" & _

"Initial Catalog=qdb"

CREATE TABLE #Temp(org INT NOT NULL,

 acct VARCHAR(7) NOT NULL,

 class VARCHAR(4) NOT NULL,

 prod VARCHAR(7) NOT NULL,

 note VARCHAR(16) NOT NULL,

 htmltext VARCHAR(16) NOT NULL,

 PRIMARY KEY (org, acct, class, prod, note)

)

INSERT INTO #Temp (org,...

Figured it was "OUO" or "Confidential" or some such   In the Army they let us put it on the front cover and in...

15GB is plenty of space for master DB and probably plenty of your user data as well.  You will get a performance boost if you put your user DB's and...

Copy and paste it into Query Analyzer.  Switch to the database you want to run it in.  Press F5.  You can leave out SPECIFIC_CATALOG, SPECIFIC_SCHEMA, or whatever else you want...

Ahhh I know all about government regs   What is it, "FOUO"?

For an application that specific you're probably stuck running that page through separately...

Something like this?

SELECT DISTINCT a.CompanyID,

  b.Contacted_Date,

  b.FollowUp_Date

FROM  #Temp a

INNER JOIN (

 SELECT c.CompanyID, MAX(c.Contacted_Date) AS Contacted_Date, MAX(c.FollowUp_Date) AS FollowUp_Date

 FROM #Temp c

 WHERE c.CompanyID = CompanyID

 GROUP BY c.CompanyID

) b

ON a.CompanyID...

Just one page?  Can you feed the sheet through the printer again, upside down and print the last page?  Just wondering, but why in the world do you have to...

Master probably won't grow overly large.  Normally you don't do a lot of stuff in master (or shouldn't be anyway...)  Don't know how big your C: drive is, but the...

Can you post your query and DDL?

SELECT SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_CATALOG, CREATED, LAST_ALTERED

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = 'PROCEDURE'

ORDER BY SPECIFIC_NAME

?