Microsoft reasons why SQL cannot load DLL

Microsoft cause of DLL loading failure: 126 (the specified module cannot be found ).

The introduction of the u890 set of books prompts: "unable to load DLL Microsoft prompts you to operate SQL database at will to avoid unnecessary trouble for the database or a DLL referenced by the DLL. Cause: 126 (the specified module cannot be found .)."

Because the SA password of SQL2000 is too simple, the system stored procedure is maliciously modified by viruses.
The following system stored procedure recovery is required.
Note: This solution only supports SQL2000

Use master

Go

-- Check whether xp_mongoshell is tampered

Select * from Master .. syscomments where object_name (ID) = 'xp _ javasshell' and text <> 'xp log70. dll'

Go

-- Check whether other stored procedures are tampered

Select object_name (ID), * from Master .. syscomments where object_name (ID) in

('Xp _ getfiledetails ', 'xp _ availablemedia', 'xp _ dirtree ', 'xp _ fixeddrives', 'xp _ s
Ubdirs ',
'Xp _ fileexist ', 'xp _ get_tape_devices', 'SP _ msgetversion', 'xp _ enumdsn ', 'xp _ Regr
Ead', 'xp _ regwrite', 'xp _ regdeletevalue ',
'Xp _ regaddmultistring', 'xp _ regremovemultistring ', 'xp _ regenumkeys', 'xp _ regenu
Mvalues ', 'xp _ regdeletekey', 'xp _ instance_regread ',
'Xp _ instance_regwrite ', 'xp _ instance_regdeletevalue', 'xp _ instance_regaddmulti
String ', 'xp _ instance_regremovemultistring ',
'Xp _ instance_regenumkeys ', 'xp _ instance_regenumvalues') and text <> n'xpstar. dll'
Go
-- If xp_mongoshell is tampered, execute the following statement to change it back.
-- Drop procedure xp_cmdshell
-- Go
-- Exec sp_addextendedproc n 'xp _ cmdshell', n'xp log70. dll'
-- Go
-- Then run the following statement to verify that xp_cmdshell is correct.
-- Xp_cmdshell 'dir C :/'
-- If the statement is abnormal, the SQL Server service activation account (generally System) does not
Access the system32/cmd.exe file and add the permission.

-- If other stored procedures are tampered with, execute the following statement:
-- Drop procedure stored procedure name
-- Go
-- Exec sp_addextendedproc n 'stored procedure name', n' xpstar. dll'