unknown stored procedure in database

Question

0.00/5 (No votes)

See more:

Hi experts,
I have big question related to my SQL Server 2008 R2 Database

Why my database contain the stored procedures as mentioned below

VB

aspnet_Profile_GetProperties
aspnet_Profile_SetProperties
aspnet_Profile_DeleteProfiles
aspnet_Profile_DeleteInactiveProfiles
aspnet_Profile_GetNumberOfInactiveProfiles
aspnet_Profile_GetProfiles
aspnet_UsersInRoles_IsUserInRole
aspnet_UsersInRoles_GetRolesForUser
aspnet_Roles_CreateRole
aspnet_Roles_DeleteRole
aspnet_Roles_RoleExists
aspnet_UsersInRoles_AddUsersToRoles
aspnet_UsersInRoles_RemoveUsersFromRoles
aspnet_UsersInRoles_GetUsersInRoles
aspnet_UsersInRoles_FindUsersInRole
aspnet_Roles_GetAllRoles
aspnet_Personalization_GetApplicationId
aspnet_Paths_CreatePath
aspnet_PersonalizationAllUsers_GetPageSettings
aspnet_PersonalizationAllUsers_ResetPageSettings
aspnet_PersonalizationAllUsers_SetPageSettings
aspnet_PersonalizationPerUser_GetPageSettings
aspnet_PersonalizationPerUser_ResetPageSettings
aspnet_PersonalizationPerUser_SetPageSettings
aspnet_PersonalizationAdministration_DeleteAllState
aspnet_PersonalizationAdministration_ResetSharedState
aspnet_PersonalizationAdministration_ResetUserState
aspnet_PersonalizationAdministration_FindState
aspnet_PersonalizationAdministration_GetCountOfState
aspnet_WebEvent_LogEvent
aspnet_Setup_RestorePermissions
aspnet_Setup_RemoveAllRoleMembers
aspnet_RegisterSchemaVersion
aspnet_CheckSchemaVersion
aspnet_Applications_CreateApplication
aspnet_UnRegisterSchemaVersion
aspnet_Users_CreateUser
aspnet_Users_DeleteUser
aspnet_AnyDataInTables
aspnet_Membership_CreateUser
aspnet_Membership_GetUserByName
aspnet_Membership_GetUserByUserId
aspnet_Membership_GetUserByEmail
aspnet_Membership_GetPasswordWithFormat
aspnet_Membership_UpdateUserInfo
aspnet_Membership_GetPassword
aspnet_Membership_SetPassword
aspnet_Membership_ResetPassword
aspnet_Membership_UnlockUser
aspnet_Membership_UpdateUser
aspnet_Membership_ChangePasswordQuestionAndAnswer
aspnet_Membership_GetAllUsers
aspnet_Membership_GetNumberOfUsersOnline
aspnet_Membership_FindUsersByName
aspnet_Membership_FindUsersByEmail

Note: I am not using any login wizard control of asp.net
then how can it possible.
and what is the solution to remove it.

If i manually remove it from my database, my site can not run.
it is giving an error of stored procedure missing.
even i have not used above stored procedure in my asp.net website

I have managed runtime theme management in my site

any one can help me?
Pls do fast.

Mahesh Patel
Software Developer
+91 9924625962

Posted 27-Jan-12 2:59am

Mr. Mahesh Patel

Updated 27-Jan-12 3:00am

v2

Add a Solution

Comments

Herman<T>.Instance 27-Jan-12 9:07am

using ORM?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2012-01-27T03:09:00

They are all procedures for the aspnet security database. At some point, someone has run the SQL script that creates these procedures....do you have the tables as well?

e.g.

aspnet_Membership
aspnet_Roles
aspnet_Users

If your site doesn't run when you remove procedures, you obviously are using this aren't you! Have a look in your web config file, what do you have specified for...

XML

<rolemanager enabled="true" defaultprovider="ChangeControlRoleProvider">
    <providers>
        <clear />
        <add name="SomeRoleProvider" connectionstringname="MyString" applicationname="Myapp" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </providers>
</rolemanager>
<profile>
    <providers>
        <clear />
        <add name="SomeProfileProvider" connectionstringname="MyString" applicationname="Myapp" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </providers>
</profile>
<membership defaultprovider="SomeMembershipProvider">
    <providers>
        <clear />
        <add name="SomeMembershipProvider">
     connectionStringName=""
     enablePasswordRetrieval="false"
     enablePasswordReset="true"
     requiresQuestionAndAnswer="false"
     applicationName="ChangeControl"
     requiresUniqueEmail="true"
     passwordFormat="Encrypted"
     maxInvalidPasswordAttempts="1000"
     minRequiredPasswordLength="6"
     minRequiredNonalphanumericCharacters="0"
     passwordAttemptWindow="10"
     passwordStrengthRegularExpression="^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{6,15}$"
     type="Blah.Blah"/>
    </add></providers>
</membership>