i recently create c#.net we application in vs2005 environment using membership control provided by vs 05 ,first i uploded my site to ftp a/c then generated sql script from enterprise manager of my local database and run script on remote database using sql query analyzer database created , i try to run application it give me error on login page that dbo.asp_checkschema stored procedure have not permission to execute
then i learned that dbo is admin an i have create stored procedures with my user name , then i followed same and change stored procedures ownership to my username than again i try to run my application it give error that dbo.asp_checkschema stored procedure have not found but same stored procedure is there only with owner name changed such as abc.asp_checkschema , iserched a lot but i not find a solution on that plese help me in solving it