I tried to create a stored procedure but instead of opening up to a new stored procedure it displays an exist stored procedure. I erased the code and typed in my code now i received this error message.
MS SQL-DMO (ODBC SQLState:42000)
Error 2729: Procedure ‘spUpdate_date_time’ group number 1 already exists
in the database. Choose another procedure name
I think it has something to go with the code attached to the end of the stored procedure to cause the same sp opens up when trying to create a new stored proc.
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON
can anyone help to set this? I tried deleting it but doesn't work.