|
|
Posted by Patrik on 12/05/86 11:31
Hi,
I need help on this one. For the past two days, whenever I make a
modification to a stored procedure using enterprise manager (Apply),
the stored procedure stops working.
If I copy it under a new name, it works but as soon as I make a
modification, it stops working. I am going crazy on this one.
The error : wrong column name. He doesn't recognize the column name on
a very straighforward line : SELECT @SQL1 = 'SELECT @Total1 = Count(*)
FROM dbo.Tbl_Report WHERE Utilisateur = "'+@utilisateur+'"
For example 'sa' is not a column (it skips Utilisateur as the column
name).
Very strange. Never had this problem in the past. thank you very much.
Navigation:
[Reply to this message]
|