toby
-
Total Posts
:
20
-
Reward points
:
0
- Joined: May 14 '03
-
Status: offline
|
sp_helpdb
Wed. May 14, '03 8:19 PM
( permalink)
I have the software up and running but when I log in as admin, the nav displays fine but the content page errors saying: Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The database ' ' does not exist. Use sp_helpdb to show available databases. everything else seems ok. I can' t find sp_helpdb in any of the stored procedures or in the query anylizer scripts provided. Any help would be appreciated. thanks t
|
|
|
|
FreddyD
-
Total Posts
:
835
-
Reward points
:
41220
- Joined: Mar 02 '02
- Location: Louis Lake
-
Status: offline
|
RE: sp_helpdb
Thu. May 15, '03 1:22 AM
( permalink)
as far as I know, there isn' t a stored procedure named sp_helpdb in this software. 
|
|
|
|
Guest
-
Total Posts
:
888
-
Reward points
:
0
- Joined: May 23 '01
-
Status: online
|
RE: sp_helpdb admin/stats.asp line 65
Thu. May 15, '03 2:17 PM
( permalink)
admin/stats.asp line 65 it refers to sp_helpdb
|
|
|
|
toby
-
Total Posts
:
20
-
Reward points
:
0
- Joined: May 14 '03
-
Status: offline
|
RE: sp_helpdb
Thu. May 15, '03 2:24 PM
( permalink)
I' m sorry I logged in as admin for the first reply, I' ll be more considerate in the future. there is a reference to this on page...... admin/stats.asp line 65
|
|
|
|
Malibu
-
Total Posts
:
44
-
Reward points
:
1990
- Joined: Oct 27 '02
- Location: Florida
-
Status: offline
|
RE: sp_helpdb
Thu. May 15, '03 2:25 PM
( permalink)
sp_helpdb is an internal stored procedure to SQL 2000. It provides information about a database that you have setup on your SQL server. In Query Analyzer: sp_helpdb ' myDatabase' will show you information on the database " myDatabase"
|
|
|
|
Samuel
-
Total Posts
:
11858
-
Reward points
:
180790
- Joined: May 23 '01
-
Status: offline
|
RE: sp_helpdb
Thu. May 15, '03 5:21 PM
( permalink)
Yes, stats.asp use sp_helpdb to find information regarding the application database. Someone in your organization probably modified the source code and caused the problem.
ASPPlayground.NET ~ see our Version 4 plans here
|
|
|
|