Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Stored Procedure Error

Author  Topic 

1sabine8
Posting Yak Master

130 Posts

Posted - 2007-12-12 : 06:28:44
Hi, I am trying to execute a Stored Procedure. When i parse it, it's good, but when i click on Excecute i get the following error :"There is already an object named 'Waiters' in the database." Waiters is the name of the stored procedure. What's the problem?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-12 : 06:37:44
When you change a stored procedure, you have to replace the header "create procedure" with "alter procedure".



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -