MSSQL security settings to remove the SQL process with security issues. More comprehensive. Everything for safety!
Delete the call shell, registry, COM component's corrupted permissions
Copy Code code as follows:
Use master
EXEC sp_dropextendedproc ' xp_cmdshell '
EXEC sp_dropextendedproc ' sp_OACreate '
EXEC sp_dropextendedproc ' sp_OADestroy '
EXEC sp_dropextendedproc ' sp_OAGetErrorInfo '
EXEC sp_dropextendedproc ' sp_OAGetProperty '
EXEC sp_dropextendedproc ' sp_OAMethod '
EXEC sp_dropextendedproc ' sp_OASetProperty '
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
Copy all to SQL Query Analyzer
Clicking on the menu-"Query"-"execute" will remove the SQL process with security issues (above is the technical support of 7i24 's genuine users)
Change the default SA null password. Database links do not use the SA account. Single database use account alone. Only public and db_owner permissions are given.
The database should not be placed in the default location.
SQL does not install under the program file directory.
The latest SQL2000 patch is SP4
MSSQL2000 Security Settings Graphics and text tutorial http://www.jb51.net/article/26016.htm
WIN2003 MSSQL to run security settings for ordinary users http://www.jb51.net/article/23217.htm
