Effect Of Update Statistics On Database And On An ASP Application

Hi

I had run a stored procedure in my server that update statistics against all user defined tables in my database (MSSQL 7.0).

Since then I am getting errors in my ASP application where I am reffering to adovbs.inc.

Here is an example of errors I get.

Microsoft VBScript runtime error '800a0411'

Name redefined: 'adOpenForwardOnly'

/Essai/adovbs.inc, line 14



Below is the stored procedure I have run against the database.

Can anybody help tank you guys.



CREATE PROCEDURE update_all_stats
AS
/*
This PROCEDURE will run UPDATE STATISTICS against
ALL user-defined tables within this database.
*/
DECLARE @tablename varchar(30)
DECLARE @tablename_header varchar(75)
DECLARE tnames_cursor CURSOR FOR SELECT name FROM sysobjects
WHERE type = 'U'
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @tablename
WHILE (@@fetch_status <> -1)


BEGIN
IF (@@fetch_status <> -2)


BEGIN
SELECT @tablename_header = "Updating " +
RTRIM(UPPER(@tablename))
PRINT @tablename_header
EXEC ("UPDATE STATISTICS " + @tablename )
END
FETCH NEXT FROM tnames_cursor INTO @tablename
END
PRINT " "
PRINT " "
SELECT @tablename_header = "************* NO MORE TABLES" +
" *************"
PRINT @tablename_header
PRINT " "
PRINT "Statistics have been updated FOR ALL tables."
DEALLOCATE tnames_cursor