Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SMS query troubles

Status
Not open for further replies.

MISMCSA

MIS
Jun 24, 2004
43
US
I'm running SMS 2003.

I have this query:

Code:
SELECT DISTINCT sys.Netbios_Name0, sys.Operating_System_Name_and0, os.LastBootUpTime0, os.TimeStamp
FROM v_R_System sys INNER JOIN v_HS_OPERATING_SYSTEM os on sys.ResourceID = os.ResourceID

and it is giving this error when I attempt to run:


Microsoft VBScript runtime error '800a0007'

Out of memory: 'GetRows'

/SMSReporting_ML1/Report.asp, line 548


Does anyone have any idea why this would be?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top