error on install

Have just completed the install procedure, first changing the constants:

Const strDbTable = "bds"
Const strDbProc = "bds"

in common.asp and msSQL_server_setup.asp

Then ran the msSQL_server_setup.asp file and it said installation successful. But then, when I went to the forum/index.asp page to have a look for the first time, I got the error message:

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

Could not find stored procedure 'wwfSpSelectConfiguration'.

/forum/common.asp, line 283

It would appear to be looking for a SP with the old 'wwf' name prefix. Can someone give me a steer on this? Is it a page that's corrupted, or am I going to have to do a complete reinstall? If so, I presume I am going to have to go through and drop all the tables and SPs first?

(Unfortunately I can't use enterprise manager on the site I'm trying to install the forum on, so I cannot 'see' what SPs are there etc.

Thanks

Bill

No! As explained, I changed the prefixes in common.asp and the sql set up file, and only THEN did the installation of the SPs and tables.

But the index.asp  page is still looking for the old wwf... SP!

Bill wrote: (Unfortunately I can't use enterprise manager on the site I'm trying to install the forum on, so I cannot 'see' what SPs are there etc. Thanks Bill

Use this:

CREATE PROCEDURE dbo.listProcedures 
AS 
BEGIN 
    SET NOCOUNT ON 
    SELECT 
        ROUTINE_NAME 
    FROM 
        INFORMATION_SCHEMA.ROUTINES 
    WHERE 
        ROUTINE_TYPE='PROCEDURE' 
        AND OBJECTPROPERTY 
        ( 
            OBJECT_ID(ROUTINE_NAME), 
            'IsMsShipped' 
        ) = 0 
    ORDER BY 
        ROUTINE_NAME 
END 
GO

then in ASP

<% 
    set conn = CreateObject("ADODB.Connection") 
    conn.open "<connection string>" 
    set rs = conn.execute("EXEC dbo.listProcedures") 
    do while not rs.eof 
        response.write rs(0) & "<br>" 
        rs.movenext 
    loop 
    rs.close: set rs = nothing 
    conn.close: set conn = nothing 
%>