MS CRM心得

今天接到database team的邮件，说CRM的数据库被一个stored procedure block住了，然后给了stored procedure的名字和代码， p_GetNewValueFromAuditTrail。 

然后去msdn上查了一下，原来是out of box的 stored procedure. 仔细研究了下发现还有很多相似的out of box procedure. 在安装CRM的database的时候就自动安装了，复制一个表以便以后自己查阅。

Name of Stored Procedure	Description
p_CollectSolutionInternalAncestors	Stored procedure that collects all solution internal ancestors for a given set of components in the #ComponentSet table.
p_RetrieveAllPublishedDependencies	Stored procedure to retrieve all published dependencies for all of a given set of solution components in a particular solution.
p_CollectPrincipals	Supports database driven security.
p_CascadeRevokeAccess	For cascading revoke access
p_PublishMetadata	Publishes metadata in the metadata tables
p_GetPrimaryKeyAttributes	Metadata browser stored procedure.
p_GetForeignKeyAttributes	Metadata browser stored procedure.
p_RetrieveDependenciesForUninstall	Stored procedure to retrieve component dependencies that exist for the solution being uninstalled.
p_CleanupInactiveWorkflowAssemblies	Stored procedure to cleanup rows from PluginType,PluginAssembly tables that correspond to inactive workflows.
fn_EndOfNextMonth	Datetime utilities used by report filters
p_GetAuditDetails	Stored procedure to retrieve the new values for all the attributes of a given audit row
fn_GetChildUserPrincipalsAndTeams	Retrieves child users in the users hierarchy, together with their teams.
p_RetrieveDependenciesForDelete	Stored procedure to retrieve all of the component dependencies when a certain component is being deleted.
fn_NTDayOfWeek	Function used for report view generation.
p_GetTablesForDeletion	Get Tables which have DeletionStateCode
p_GetKeyAttributes	Metadata browser stored procedure.
GetSubsidiaryBusinesses	Supports database driven security.
p_CopyRole	Supports database driven security.
fn_RetrieveAllRoles	Retrieves all roles, team roles and parent root roles for the specified userId
p_DetectUnitLoop	Detects unit loop.
fn_GetFiscalYearCore	Used in executing queries which aggregate by fiscal year.
fn_UTCToTzSpecificLocalTime	Function used for report view generation.
p_GrantAccessBulkForCreate	For bulk grant Access during create
p_RollupByOpportunity	Opportunity Rollup support
fn_POARetrieveMultiple	Supports database driven security.
fn_BeginOfLastSevenDay	Datetime utilities used by report filters
p_GetBusinessHierarchy	Returns business hierarchy.
p_Reindex	Indexing support
p_CreateBusinessClosureCalendar	Creates a business closure calendar.
p_feGetFormXml	Generates form xml.
fn_RetrieveVersionAsFloat	Function to convert a nvarchar .NET version to float.
fn_GetBusinessDataLocalizedLabel	Helper function for getting transactional data localized labels for filtered view
p_DetectUserLoop	Detects user loop.
fn_BeginOfLastWeek	Datetime utilities used by report filters
fn_CollectForCascadeReparent	For collecting all cascaded entities into temp table (Reparent Operation)
fn_GetFiscalPeriodCore	Used in executing queries with fiscal period references.
fn_UTCToTzCodeSpecificLocalTime	Function used for report view generation and aggregate queries.
fn_GetTeamIdsWithUserIdForUser	Function used for report view generation.
p_DetectSubjectLoop	Detects subject loop.
p_DefragIndexes	Indexing support
CascadeCollectionTableCreation	Creates CascadeCollectionTable type table
fn_BeginOfSpecificFiscalYear	Datetime utilities used by report filters
fn_CollectForCascadeAssign	For collecting all cascaded entities into temp table (Assign Operation)
fn_CheckAccessForResource	Helper function to see if a given user has acccess to a given resource.
p_DeleteCustomActivityEntries	Stored procedure used to Delete custom activity entries from activity pointer and activity parties.
fn_BeginOfLastFiscalPeriod	Datetime utilities used by report filters
fn_NextXMonth	Datetime utilities used by report filters
fn_BeginOfThisWeek	Datetime utilities used by report filters
p_KeyLeftAttributes	Metadata browser stored procedure.
fn_EndOfNextXFiscalYear	Datetime utilities used by report filters
p_FixUsersForBusinessMove	Supports database driven security.
p_GetAddedRoleCount	Gets number of roles added.
fn_GetMaxPrivilegeDepthMask	Supports database driven security in filtered views.
p_RetrieveDependenciesForExport	Stored procedure to retrieve all component dependencies that are required on an export.
p_RetrieveRoots	Stored procedure that retrieves all of roots for a given component.
fn_CollectForCascadeDelete	For collecting all cascaded entities (Delete Operation)
fn_CollectForCascadeShare	For collecting all cascaded entities into temp table (Share Operation)
fn_LastXYear	Datetime utilities used by report filters
p_DeleteMarketingListMembers	Stored procedure to delete members from a Marketing List using XML.
p_GetAllTableRelationships	Get all table relationships.
p_CreateDefaultCalendar	Creates a default calendar for system users.
fn_RptBracket	Function used for reporting neglected cases.
p_AddAttributeToIndex	Add Attributes to Index
fn_EndOfNextYear	Datetime utilities used by report filters
p_PrincipalAttributeAccessMapReinit	Supports database driven security: reinit PrincipalAttributeAccessMap for a principal user or team.
fn_CollectForCascadeDeleteSchema	For collecting all cascaded entities (Delete Entity Defition Operation)
p_SetDbCollation	Set database collation.
fn_EndOfLastFiscalYear	Datetime utilities used by report filters
fn_BeginOfLastXWeek	Datetime utilities used by report filters
p_InsertNewWebResource	Inserts a new webresource along with its dependencies during DBUpdates.
fn_BeginOfFiscalYear	Datetime utilities used by report filters
fn_LastXMonth	Datetime utilities used by report filters
p_UpdateRootSite	Stored procedure to update root site collection of given SharePoint record.
p_AccountDistRollup	rollup stored procedure for Account Distribution Report
fn_FindUserGuid	Function used for report view generation.
p_RetrievePostsAndComments	Stored procedure to retrieve posts with comments for activity feeds wall given a set of Post Ids.
fn_CollectForCascadeWrapper	For collecting all cascaded and remove link entities (Delete Operation)
p_CascadeGrantAccess	For cascading grant Access
fn_EndOfThisWeek	Datetime utilities used by report filters
fn_CollectForCascadeUnshare	For collecting all cascaded entities into temp table (Unshare Operation)
fn_GetChildUserPrincipals	Retrieves child users in the users hierarchy
p_GrantInheritedAccess	Supports database driven security.
p_DetectAccountLoop	Detects account loop.
p_PopulateDefaultSyncFilters	Populates default Offline and Outlook filters.
p_CollectPrincipalsInDeepAndReinit	Supports database driven security for role change.
fn_LocalTimeToUTC	Function used for report view generation.
p_GetNextEmailTrackingNumber	Generates email tracking number.
p_ResetGoalSubtreeOnDelete	Stored procedure to reset tree id and depth of child goals on goal delete.
p_ReinitRecordCountSnapshots	Reinitializes the record count snapshots table.
fn_GetPrivilegeDepthMask	Supports role upgrade.
p_BusinessUnitMapSetParent	Supports database driven security.
EntityIdCollectionCreation	Creates EntityIdCollectionCreation type table
fn_EndOfTomorrow	Datetime utilities used by report filters
p_GrantUpdateRevokeAttributeAccessSyncTracking	For tracking in synchronization a replicated entity instance on which AttributeAccess is Granted, Updated or Revoked
fn_BeginOfThisMonth	Datetime utilities used by report filters
p_CopyCustomRolesFromParent	Supports database driven security.
fn_EndOfNextXHour	Datetime utilities used by report filters
p_GetTableIntersectRelationships	Metadata browser stored procedure.
p_GetPicklist	Returns picklist information.
fn_BeginOfThisFiscalPeriod