数据库中未知的存储过程 [英] unknown stored procedure in database

问题描述

您好，专家，
我有一个与我的SQL Server 2008 R2数据库有关的大问题

为什么我的数据库包含如下所述的存储过程

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

Why my database contain the stored procedures as mentioned below

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

注意:我没有使用asp.net的任何登录向导控件. 那怎么可能呢?
以及如何删除它.

如果我从数据库中手动删除它，则我的站点将无法运行.
它给出了存储过程丢失的错误.
甚至我在asp.net网站上都没有使用上述存储过程

我已经在自己的网站中管理了运行时主题管理

有人可以帮助我吗?
请快速.

Mahesh Patel
软件开发人员
[phone]

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
[phone]

推荐答案

它们都是aspnet安全数据库的过程.在某个时候，有人运行了创建这些过程的SQL脚本....您也有表吗?

例如

aspnet_Membership
aspnet_Roles
aspnet_Users

如果在删除程序时您的网站没有运行，那么您显然正在使用它！看看您的Web配置文件，您为...指定了什么?

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...

<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 > < /提供者 > < /成员身份 >

" type="Blah.Blah"/> </add></providers> </membership>

这篇关于数据库中未知的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！