-
February 22nd, 2003, 11:50 AM
#1
Senior Member
SQL Question
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|