I am using ASP and i just upsized from access to SQL 2000 but when i run some scripts it gives me this error messages, please what could be happening.Also how do i call functions in SQL 2000, i can only use SQL server 7 for stored procedures and views.please help.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]The request for procedure 'qryContentWebPages' failed because 'qryContentWebPages' is a function object.
/discovery/cms/contentthefund/webpages.asp, line 19


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]The view or function 'qryContentTheCompanyBoardList' is not updatable because the definition contains the TOP clause.
/discovery/cms/contentthecompany/boardmanagementAddEditFn.asp, line 103

   It seems you used some sort of automated function to upsize. These qrys that are causing the error are probably not syntactically compatiable with SQL server syntax. They will need to be rewritten, either as a stored procedure or a function, depending on how you plan on using it. I think stored procedures will probably be what you need.

[Microsoft][ODBC SQL Server Driver][SQL Server]The view or function 'qryContentTheCompanyBoardList' is not updatable because the definition contains the TOP clause.