You may have an issue with installing the
KB5004285 on your system. At first, the updates would install successfully, but when you reboot you will get an error saying “Failure configuring Windows Updates. Reverting Changes”
There will not be any error on your Windows machine, only a generic message that the update failed with the error message Code
800F0922 in the Windows Update History.
The error is due to an Acrobat Flash removal issue and the update will fail since it couldn’t find the folders. To resolve the issue, you need to create the following folders with the same case.
Once the above empty folders are created, simply re-run the updates and after a restart, they will be successful. Voila!
I have created a stored procedure that does a BULK IMPORT. I wanted to add a bit of fault checking and added a BEGIN TRY and a BEGIN CATCH so that it sends an email with the error message if the T-SQL fails. The problem is that the BEGIN CATCH was being skipped and the procedure stops processing with the below error message.
Msg 4860, Level 16, State 1, Line 2
Cannot bulk load. The file "C:\temp\fileimport.txt" does not exist.
To fix the issue what I did is to add the BULK INSERT command in a variable and execute it. This way, the BEGIN CATCH is not ignored or skipped.
DECLARE @bulkimport varchar(1000)
SET @bulkimport = 'BULK INSERT mytable FROM ''C:\temp\fileimport.txt''
WITH (FIELDTERMINATOR = ''*'', ROWTERMINATOR = ''\n'')'
When running an integrity check on your databases, you may get the following error on some databases.
Description: Executing the query "DBCC CHECKDB(N'mydb') WITH NO_INFOMSGS " failed with the following error: "The In-row data myrow page count for object "my_table", index ID 0, partition ID 52794353778688, alloc unit ID 52794353778688 (type In-row data) is incorrect.
This is due to the fact that the database in question was imported from another or older version of your current SQL server. This can be fixed by running the below command on the databases in question.
DBCC UPDATEUSAGE (dbname)
dbname = The name of your database
When the database is indeed one which is failing the integrity check you will see the below sample message.
DBCC UPDATEUSAGE: Usage counts updated for table 'mytable' (index 'mytable', partition 1):
DATA pages (In-row Data): changed from (2) to (1) pages.
USED pages (In-row Data): changed from (25) to (24) pages.
RSVD pages (In-row Data): changed from (41) to (40) pages
If the database doesn’t need to update it’s usage you will simply get the message below.
DBCC execution completed.
Once you have executed the update-usage on all databases which are failing, run the integrity check again and swish, it works.