When I double click a stored procedure with an owner
that is NOT 'dbo', the resulting script that is shown
in the editor has "[dbo]" instead of the real owner
name. This results in an error message when running
the query:
Server message
Procedure 'mh_test2' group number 1 already exists in
the database. Choose another procedure name.
The generated script is:
-------------------------
USE [test]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[mh_test2]') and OBJECTPROPERTY(id,
N'IsProcedure') = 1)
drop procedure [dbo].[mh_test2]
GO
CREATE PROCEDURE mh_test2
(
@inVc varchar(32),
@inBd decimal(18,4)
)
AS begin
update mh_test
set
columnvc = @inVc,
columndec = @inBd
end
-----------------------------
but the owner in the database is not "dbo".