Dbo isn't a user, it's a schema. Are you sure that you can't apply the
schema yourself? By default, the schema ownership will be for the user
account that was logged in to create the tables/stored procedures but that
doesn't mean you're limited to it. dbo isn't a user itself, it's a role and
your user account is probably already in that role, just using a seperate
owner schema. Try creating a new table so that you have an object generated
with your current schema. Then run the following stored procedure
sp_changeobjectowner 'itemname','dbo' where itemname is the name of the new
object.
This should change the schema to dbo and you can check and see if you can
still access the object OK through a tool like sql management console. If
that works then you can use this procedure to change the schema of all the
aspnet objects needed for membership.
--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
"Iván Sainz" <Iv******@discussions.microsoft.comwrote in message
news:0D**********************************@microsof t.com...
>I ran the aspnet_regsql.exe tool with the -sqlexportonly option to create
the
script. I searched and replace the string [dbo] by [mySchema] and had the
dba's run the script. When I do anything like Membership.CreateUser or
click
on the 'security' tab in the website admin tool I get... Could not find
stored procedure 'dbo.aspnet_CheckSchemaVersion'.
I think this is because "dbo" is harcoded in the framework. The hosting
company won't let us use the dbo user of course. Do I have yo rewrite the
provider? Is there any other and easyer workaround for getting this to
work?
Thank you very much
--------------------
Iván Sainz
Ahead Labs, S.L.