Menu

#100 4.0.1.0: wrong owner creation

open
nobody
None
5
2005-11-16
2005-11-16
m.hilpert
No

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".

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.