hi.

got problem here. two months ago i made an application programm ( accounting ) using Ms Access project as the interface and Ms SQL Server 7 . two days ago i formatted my hard disk drive ( only Drive C:/ ) and i've already back up all my data to drive d:/ included my script , and after it finished . i installed sql-2000 and try to compile it with quesry analyzer . The quesry analyzer said it was succed in compiling but i found so many erros when i try to execute it. The Programm cans run . but it doesn't work well .


and here's the messages from query analyzer when i try to execute it :

Server: Msg 207, Level 16, State 3, Procedure SP_Check_UserGID, Line 10
Invalid column name 'suid'.
Server: Msg 207, Level 16, State 1, Procedure SP_Check_UserGID, Line 10
Invalid column name 'suid'.
Server: Msg 207, Level 16, State 3, Procedure SP_GetUserID, Line 10
Invalid column name 'suid'.
Server: Msg 207, Level 16, State 1, Procedure SP_GetUserID, Line 10
Invalid column name 'suid'.
Server: Msg 207, Level 16, State 1, Procedure SP_GetUserID, Line 10
Invalid column name 'suid'.

my question is :
why the script has some errors when i try to execute it execute and it tells so many errors ?
it happends becoz i try to compile with the new sql ??


* still learning now and need your help...