Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Could not find stored procedure 'gemini_authenticateuser'

web-app

My hosting service moved me to sql server 2005. Gemini 2.0.5 was working correctly on sql server 2000. Now I get the error

Could not find stored procedure 'geminiauthenticateuser'.

[SqlException: Could not find stored procedure 'geminiauthenticateuser'.]
   Gemini.Default.AuthUser(String uid, String pwd) +79
   Gemini.Default.Page_Load(Object sender, EventArgs e) +218
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +766

Management Studio can open the database and the procedure is still there. I there some way to fix this?
PaulS
· 1 		PaulS
Tuesday, March 20, 2007, 9:34:01 PM
Replies (7)
helpful
0
not helpful

Please check who is the owner of the stored procedure.

It might be that it has a non dbo owner.
Mark Wing
· 9108 		Mark Wing
Wednesday, March 21, 2007, 8:47:44 AM
helpful
0
not helpful

The schema (owner) of tables and procedures is not 'dbo'.  I don't know what it was before under sql server 2000.

Should I change it to 'dbo'?

I don't use sql server enough to remember -- I know there was a script to make owner changes but I always have to look it up in google. You'd think people have to do this often enough they would just make it a command in the management studio menus.

If you have a script to change owners please post it, thanks.
PaulS
· 1 		PaulS
Wednesday, March 21, 2007, 6:29:55 PM
helpful
0
not helpful

Ok this works:


USE gemini1;
GO
ALTER SCHEMA dbo TRANSFER myaccount.gemini_authenticateuser;
GO


How to loop over every table and procedure :+>
PaulS
· 1 		PaulS
Wednesday, March 21, 2007, 7:01:24 PM
helpful
0
not helpful

Run:

select 'alter schema dbo transfer  myaccount.'+[name] from sysobjects where type in ('U','V') or type='P' and [name] like 'gemini_%'

and run the output...
Saar Cohen
· 5000 		Saar Cohen
Wednesday, March 21, 2007, 10:36:38 PM
helpful
0
not helpful

The following is from an mvp on usenet. It's pretty easy after all. You just run the outpout of the select statements. Thank you.


SELECT 'ALTER SCHEMA dbo TRANSFER ' + SCHEMANAME(schemaid) + '.' + name FROM sys.tables WHERE schemaid != SCHEMAID('dbo');



SELECT 'ALTER SCHEMA dbo TRANSFER ' + SCHEMANAME(schemaid) + '.' + name FROM sys.views WHERE schemaid != SCHEMAID('dbo');



SELECT 'ALTER SCHEMA dbo TRANSFER ' + SCHEMANAME(schemaid) + '.' + name FROM sys.procedures WHERE schemaid != SCHEMAID('dbo');
PaulS
· 1 		PaulS
Wednesday, March 21, 2007, 11:45:14 PM
helpful
0
not helpful

where should one run the scripts above? and what I wanted is to change only for the stored procedures and not for the sys.
Can somone be kind and take the time to write one example sql statement ? Thanx
Meralaz
· 1 		Meralaz
Tuesday, April 3, 2007, 3:14:13 PM
helpful
0
not helpful

select 'alter schema dbo transfer  myaccount.'+[name] from sysobjects where type='P' and [name] like 'gemini_%'
Mark Wing
· 9108 		Mark Wing
Tuesday, April 3, 2007, 4:36:29 PM