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.
| Author |
Topic |
|
qaz
Starting Member
2 Posts |
 Posted - 2008-12-08 : 10:04:11
|
| I am trying to change my 1st stored procedure.First I make the change.Second I click the blue check to see if it is ok. It says "command(s) completed successfully"Third I click the red ! and it says "msg 2714, level 16, state 3, procedure try1, line 10 There is already an object named try1 in thee database"The unchanged stored procedure still runs. USing SQL Server Management Studio Express and calling procedure from Cold Fusion.How can I change the stored procedure? |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-08 : 10:24:05
|
| make sure it's "Alter Procedure" |
 |
|
|
qaz
Starting Member
2 Posts |
Posted - 2008-12-08 : 11:46:47
|
| Thank you for that. |
|
|
|
|
|
|
can't change stored procedure