Error 2812 occurred when restoring the database: The Stored Procedure master could not be found. dbo. xp_fileexist: this is because all the dynamic connection databases in the extended storage process of the system are deleted for security reasons and the following solution is found through search: 1. Restore the stored procedures required for database restoration, and enable MSSQL query.
Error 2812 occurred when restoring the database: The Stored Procedure master could not be found. dbo. xp_fileexist: this is because all the dynamic connection databases in the extended storage process of the system are deleted for security reasons and the following solution is found through search: 1. Restore the stored procedures required for database restoration, and enable MSSQL query.
"Error 2812: The Stored Procedure 'master. dbo. xp_fileexist '" is not found when the database is restored '",
Cause: this is because all the dynamic connection databases in the extended storage process of the system are deleted for security reasons.
Search for the following solution:
Solution: 1,
Recover the stored procedures required for database restoration. Open the MSSQL query analyzer and run the following two database statements.
EXEC sp_addextendedproc xp_dirtree, @ dllname = 'xpstar. dll'
EXEC sp_addextendedproc xp_fileexist, @ dllname = 'xpstar. dll'
Solution: 2. reinstall SQL2000
SQL server dangerous Stored Procedure deletion and Restoration
Delete
Use master
Exec sp_dropextendedproc 'xp _ export shell'
Exec sp_dropextendedproc 'xp _ dirtree'
Exec sp_dropextendedproc 'xp _ enumgroups'
Exec sp_dropextendedproc 'xp _ fixeddrives'
Exec sp_dropextendedproc 'xp _ loginconfig'
Exec sp_dropextendedproc 'xp _ enumerrorlogs'
Exec sp_dropextendedproc 'xp _ getfiledetails'
Exec sp_dropextendedproc 'SP _ OACreate'
Exec sp_dropextendedproc 'SP _ OADestroy'
Exec sp_dropextendedproc 'SP _ oageterrorinfo'
Exec sp_dropextendedproc 'SP _ oagetproperties'
Exec sp_dropextendedproc 'SP _ oamethod'
Exec sp_dropextendedproc 'SP _ oasetproperties'
Exec sp_dropextendedproc 'SP _ oastop'
Exec sp_dropextendedproc 'xp _ regaddmultistring'
Exec sp_dropextendedproc 'xp _ regdeletekey'
Exec sp_dropextendedproc 'xp _ regdeletevalue'
Exec sp_dropextendedproc 'xp _ regenumvalues'
Exec sp_dropextendedproc 'xp _ regread'
Exec sp_dropextendedproc 'xp _ regremovemultistring'
Exec sp_dropextendedproc 'xp _ regwrite'
Drop procedure sp_makewebtask
Go
Restore
Use master
Exec sp_addextendedproc xp_cmdshell, 'xp _ cmdshell. dll'
Exec sp_addextendedproc xp_dirtree, 'xpstar. dll'
Exec sp_addextendedproc xp_enumgroups, 'xp log70. dll'
Exec sp_addextendedproc xp_fixeddrives, 'xpstar. dll'
Exec sp_addextendedproc xp_loginconfig, 'xplog70. dll'
Exec sp_addextendedproc xp_enumerrorlogs, 'xpstar. dll'
Exec sp_addextendedproc xp_getfiledetails, 'xpstar. dll'
Exec sp_addextendedproc sp_OACreate, 'odsole70. dll'
Exec sp_addextendedproc sp_OADestroy, 'odsole70. dll'
Exec sp_addextendedproc sp_OAGetErrorInfo, 'odsole70. dll'
Exec sp_addextendedproc sp_OAGetProperty, 'odsole70. dll'
Exec sp_addextendedproc sp_OAMethod, 'odsole70. dll'
Exec sp_addextendedproc sp_OASetProperty, 'odsole70. dll'
Exec sp_addextendedproc sp_OAStop, 'odsole70. dll'
Exec sp_addextendedproc xp_regaddmultistring, 'xpstar. dll'
Exec sp_addextendedproc xp_regdeletekey, 'xpstar. dll'
Exec sp_addextendedproc xp_regdeletevalue, 'xpstar. dll'
Exec sp_addextendedproc xp_regenumvalues, 'xpstar. dll'
Exec sp_addextendedproc xp_regread, 'xpstar. dll'
Exec sp_addextendedproc xp_regremovemultistring, 'xpstar. dll'
Exec sp_addextendedproc xp_regwrite, 'xpstar. dll'
START ---- run ---- "net start mssqlserver agent"
Control Panel -- Administrative Tools --- services --- MSSQLSERVERAGENT (right-click -- Property -- start or right-click -- start)
"The Stored Procedure master. dbo. xp_regread cannot be found" appears during database operations ". Cause: the Administrator deleted xp_regread during security processing.
Solution: create a new one.
