Web Wiz Forums - SQL DB Statistics

Print Page | Close Window

SQL DB Statistics - Version 7.9

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11098
Printed Date: 08 April 2026 at 4:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL DB Statistics - Version 7.9

Posted By: TrueBlue
Subject: SQL DB Statistics - Version 7.9
Date Posted: 06 July 2004 at 8:29am

Hi!

I downloaded and installed the forum on our web site.

The only thing that I get an error on is the SQL DB Statistics in verion 7.9.

Here is the error:

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'master.dbo.spt_values'.

/forum/admin/sql_server_db_stats.asp, line 24

I did a search for the word master and found one occurrence in the sql_server_connect.asp and changed it to our database's name and uploaded it to our site, but it made no difference. Shouldn't this be a variable anyway instead of a database named master?

Any ideas?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 July 2004 at 3:12am

The SQL Server stats page will only work with MS SQL Server 2000, if you are getting this error you are probally using MS SQL Server 7

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: TrueBlue
Date Posted: 07 July 2004 at 8:06am

Hi boRg!

Our database is on a MS SQL Server 2000.

Any other ideas?

Posted By: WebWiz-Bruce
Date Posted: 07 July 2004 at 8:16am

I guess then that the page is not compatible with the sql server you are using.

This file is not required for the running of the forum, it's just there for those that are interested and all statistics on the page such as the database size can be found by looking at your sql server database through enterprise manager.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting