Thanks for all your help. I had been blind - I had not seen the second common.asp file.

Really appreciate all your assistance!

PS you can do the same for showing the tables:

SELECT name      FROM sysobjects      WHERE xtype='U'      ORDER BY name    -- or    SELECT TABLE_NAME      FROM INFORMATION_SCHEMA.TABLES      WHERE TABLE_TYPE='BASE TABLE'      ORDER BY TABLE_NAME

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  %>

Bill wrote: 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!

Just to make sure we have all bases covered:

• THere is no index.asp, its default.asp?

The error you are getting is because of this line:

If strDatabaseType = "SQLServer" Then  strSQL = "EXECUTE " & strDbProc & "SelectConfiguration"

As you can see, the prefix is a variable set a few lines above, and therefore to get the error you have, the variable must be set as wwfSP.

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!

if the SPs and tables where installed before you changed the prefix, you will need to drop everything and reinstall, or rename everything..

you also have to change the prefixes in both common.asp files and the sql setup file

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