ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Schall" <mike.sch...@gmail.com>
Subject Re: Multiple Stored Procedures with same name (different owners) causes issues
Date Thu, 29 Jun 2006 16:50:47 GMT
Doing a little bit more digging looks like the culprit is
sp_procedure_params_rowset in the master database.

I pulled the text of this sp to test with and added the following and
ran as text

if exists(select * from sysobjects where name = @procedure_name and
user_name(sysobjects.uid) = user_name())
	set @procedure_schema = user_name()
else
	set @procedure_schema = 'DBO'

This give me what I want.  Has anyone changed a system stored procedure before?

Pretty sure that is a no-no.
Thoughts?
Mike

Mime
View raw message