Event-5586
Detail
Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.
Could not find stored procedure 'proc_UpdateStatisticsNVP'. 2017-07-31T00:00:09.193: Starting 2017-07-31T00:00:09.193: Dropping automatically created stats on user tables 2017-07-31T00:00:09.193: Updating statistics on user indices 2017-07-31T00:00:09.200: Statistics for dbo.IX_Dependencies_ObjectId are now being updated with default sampling. 2017-07-31T00:00:09.200: Rebuilding 2017-07-31T00:00:09.210: Done 2017-07-31T00:00:09.210: Statistics for dbo.IX_Objects_Version are now being updated with default sampling. 2017-07-31T00:00:09.210: Rebuilding 2017-07-31T00:00:09.273: Done 2017-07-31T00:00:09.273: Statistics for dbo.PK_Objects are now being updated with default sampling. 2017-07-31T00:00:09.273: Rebuilding 2017-07-31T00:00:09.280: Done 2017-07-31T00:00:09.280: Statistics for dbo.IX_Objects_ClassId_ParentId_Name are now being updated with default sampling. 2017-07-31T00:00:09.280: Rebuilding 2017-07-31T00:00:09.290: Done 2017-07-31T00:00:09.290: Statistics for dbo.PK_LastUpdate are now being updated with default sampling. 2017-07-31T00:00:09.290: Rebuilding 2017-07-31T00:00:09.300: Done 2017-07-31T00:00:09.300: Statistics for dbo.IX_ServerVersionInformation_ServerId_Product_PatchableUnit_PatchName are now being updated with default sampling. 2017-07-31T00:00:09.300: Rebuilding 2017-07-31T00:00:09.307: Done 2017-07-31T00:00:09.307: Statistics for dbo.IX_TimerLocks_JobId are now being updated with default sampling. 2017-07-31T00:00:09.307: Rebuilding 2017-07-31T00:00:09.310: Done 2017-07-31T00:00:09.310: Statistics for dbo.IX_TimerLocks_LockedByServerId are now being updated with default sampling. 2017-07-31T00:00:09.310: Rebuilding 2017-07-31T00:00:09.320: Done 2017-07-31T00:00:09.320: Statistics for dbo.IX_TimerLocks_JobId are now being updated with default sampling. 2017-07-31T00:00:09.320: Rebuilding 2017-07-31T00:00:09.323: Done 2017-07-31T00:00:09.323: Statistics for dbo.IX_TimerLocks_LockedByServerId are now being updated with default sampling. 2017-07-31T00:00:09.323: Rebuilding 2017-07-31T00:00:09.330: Done 2017-07-31T00:00:09.330: Statistics for dbo.IX_TimerRunningJobs_ServiceId_VirtualServerId_JobId_ServerId are now being updated with default sampling. 2017-07-31T00:00:09.330: Rebuilding 2017-07-31T00:00:09.333: Done 2017-07-31T00:00:09.333: Statistics for dbo.IX_TimerRunningJobs_ServerId_Status are now being updated with default sampling. 2017-07-31T00:00:09.333: Rebuilding 2017-07-31T00:00:09.340: Done 2017-07-31T00:00:09.340: Statistics for dbo.IX_TimerRunningJobs_ServiceId_VirtualServerId_JobId_ServerId are now being updated with default sampling. 2017-07-31T00:00:09.340: Rebuilding 2017-07-31T00:00:09.350: Done 2017-07-31T00:00:09.350: Statistics for dbo.IX_TimerRunningJobs_ServerId_Status are now being updated with default sampling. 2017-07-31T00:00:09.350: Rebuilding 2017-07-31T00:00:09.357: Done 2017-07-31T00:00:09.357: Statistics for dbo.IX_TimerScheduledJobs_JobId_ServerId are now being updated with default sampling. 2017-07-31T00:00:09.357: Rebuilding 2017-07-31T00:00:09.370: Done 2017-07-31T00:00:09.370: Done updating statistics
Cause:
This problem is caused by updating SharePoint 2010 to SP1. This update will try to execute this stored procedure, but it’s not there. If you go to location: “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\SQL” you’ll see a file called “STOREUP.SQL”. This file will call this stored procedure. For one or another reason, the creation of the stored procedure fails when installing SP1. If you look at the file called “STORE.SQL”, you will see that there is a create statement for this stored procedure. Strange..
Solution:
1.Find out which databases do not have this stored procedure. You can do this by executing the following statement:
exec sp_msforeachdb 'if exists(select name from [?].sys.objects where type = "P" and name like "%proc_UpdateStatistics%") AND not exists(select name from [?].sys.objects where type = "P" and name like "%proc_UpdateStatisticsNVP%") select "?"'
2. create this stored procedure by using the following script,That’s all you have to do! Be sure that you execute this script on the right database. Use the drop down in SQL Management Studio, or start the script with “USE [DBName]”.
Script:
/****** Object: StoredProcedure [dbo].[proc_UpdateStatisticsNVP] Script Date: 08/12/2011 10:22:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[proc_UpdateStatisticsNVP]
AS
SET NOCOUNT ON
DECLARE @command varchar(8000)
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Value' AND object_id = object_id(N'[dbo].[NameValuePair]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePair_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair] NameValuePair_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Albanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Albanian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAlbanian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Albanian_CI_AS] NameValuePair_Albanian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Arabic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Arabic_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairArabic_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Arabic_CI_AS] NameValuePair_Arabic_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_PRC_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_PRC_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_PRC_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_PRC_CI_AS] NameValuePair_Chinese_PRC_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_PRC_Stroke_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_PRC_Stroke_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS] NameValuePair_Chinese_PRC_Stroke_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Taiwan_Bopomofo_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS] NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Taiwan_Stroke_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Taiwan_Stroke_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS] NameValuePair_Chinese_Taiwan_Stroke_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Croatian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Croatian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCroatian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Croatian_CI_AS] NameValuePair_Croatian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Cyrillic_General_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Cyrillic_General_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCyrillic_General_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Cyrillic_General_CI_AS] NameValuePair_Cyrillic_General_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Czech_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Czech_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCzech_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Czech_CI_AS] NameValuePair_Czech_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Danish_Norwegian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Danish_Norwegian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairDanish_Norwegian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Danish_Norwegian_CI_AS] NameValuePair_Danish_Norwegian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Estonian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Estonian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairEstonian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Estonian_CI_AS] NameValuePair_Estonian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Finnish_Swedish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Finnish_Swedish_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairFinnish_Swedish_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Finnish_Swedish_CI_AS] NameValuePair_Finnish_Swedish_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_French_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_French_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairFrench_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_French_CI_AS] NameValuePair_French_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Georgian_Modern_Sort_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGeorgian_Modern_Sort_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS] NameValuePair_Georgian_Modern_Sort_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_German_PhoneBook_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_German_PhoneBook_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGerman_PhoneBook_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_German_PhoneBook_CI_AS] NameValuePair_German_PhoneBook_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Greek_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Greek_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGreek_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Greek_CI_AS] NameValuePair_Greek_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hebrew_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hebrew_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHebrew_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hebrew_CI_AS] NameValuePair_Hebrew_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hindi_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hindi_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHindi_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hindi_CI_AS] NameValuePair_Hindi_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hungarian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hungarian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHungarian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hungarian_CI_AS] NameValuePair_Hungarian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hungarian_Technical_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hungarian_Technical_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHungarian_Technical_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hungarian_Technical_CI_AS] NameValuePair_Hungarian_Technical_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Icelandic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Icelandic_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairIcelandic_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Icelandic_CI_AS] NameValuePair_Icelandic_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Japanese_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Japanese_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairJapanese_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Japanese_CI_AS] NameValuePair_Japanese_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Japanese_Unicode_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Japanese_Unicode_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairJapanese_Unicode_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Japanese_Unicode_CI_AS] NameValuePair_Japanese_Unicode_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Korean_Wansung_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Korean_Wansung_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKorean_Wansung_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Korean_Wansung_CI_AS] NameValuePair_Korean_Wansung_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Korean_Wansung_Unicode_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKorean_Wansung_Unicode_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS] NameValuePair_Korean_Wansung_Unicode_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Latin1_General_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Latin1_General_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLatin1_General_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Latin1_General_CI_AS] NameValuePair_Latin1_General_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Latvian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Latvian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLatvian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Latvian_CI_AS] NameValuePair_Latvian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Lithuanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Lithuanian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLithuanian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Lithuanian_CI_AS] NameValuePair_Lithuanian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Lithuanian_Classic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Lithuanian_Classic_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLithuanian_Classic_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Lithuanian_Classic_CI_AS] NameValuePair_Lithuanian_Classic_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Traditional_Spanish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Traditional_Spanish_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTraditional_Spanish_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Traditional_Spanish_CI_AS] NameValuePair_Traditional_Spanish_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Modern_Spanish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Modern_Spanish_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairModern_Spanish_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Modern_Spanish_CI_AS] NameValuePair_Modern_Spanish_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Polish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Polish_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairPolish_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Polish_CI_AS] NameValuePair_Polish_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Romanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Romanian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairRomanian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Romanian_CI_AS] NameValuePair_Romanian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Slovak_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Slovak_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSlovak_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Slovak_CI_AS] NameValuePair_Slovak_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Slovenian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Slovenian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSlovenian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Slovenian_CI_AS] NameValuePair_Slovenian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Thai_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Thai_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairThai_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Thai_CI_AS] NameValuePair_Thai_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Turkish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Turkish_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTurkish_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Turkish_CI_AS] NameValuePair_Turkish_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Ukrainian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Ukrainian_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairUkrainian_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Ukrainian_CI_AS] NameValuePair_Ukrainian_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Vietnamese_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Vietnamese_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairVietnamese_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Vietnamese_CI_AS] NameValuePair_Vietnamese_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Azeri_Cyrillic_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Azeri_Cyrillic_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAzeri_Cyrillic_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Azeri_Cyrillic_90_CI_AS] NameValuePair_Azeri_Cyrillic_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Azeri_Latin_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Azeri_Latin_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAzeri_Latin_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Azeri_Latin_90_CI_AS] NameValuePair_Azeri_Latin_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Hong_Kong_Stroke_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS] NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Divehi_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Divehi_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairDivehi_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Divehi_90_CI_AS] NameValuePair_Divehi_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Indic_General_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Indic_General_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairIndic_General_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Indic_General_90_CI_AS] NameValuePair_Indic_General_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Kazakh_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Kazakh_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKazakh_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Kazakh_90_CI_AS] NameValuePair_Kazakh_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Macedonian_FYROM_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Macedonian_FYROM_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairMacedonian_FYROM_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Macedonian_FYROM_90_CI_AS] NameValuePair_Macedonian_FYROM_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Syriac_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Syriac_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSyriac_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Syriac_90_CI_AS] NameValuePair_Syriac_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Tatar_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Tatar_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTatar_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Tatar_90_CI_AS] NameValuePair_Tatar_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Uzbek_Latin_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Uzbek_Latin_90_CI_AS]'))
BEGIN
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairUzbek_Latin_90_CI_AS_Value are now being updated with default sampling.'
SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Uzbek_Latin_90_CI_AS] NameValuePair_Uzbek_Latin_90_CI_AS_Value'
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'
EXEC (@command)
PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'
END
RETURN 0
浙公网安备 33010602011771号