Undocumented SQL Server 2017 Agent Procedures SQL Server 2017 supports the following useful undocumented SQL Server Agent stored procedures: sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info sp_MSgetalertinfo sp_readerrorlog Two of these stored procedures exist in the msdb database (sp_sqlagent_is_srvrolemember and sp_sqlagent_get_startup_info), other exist in the master database. sp_sqlagent_is_srvrolemember The sp_sqlagent_is_srvrolemember stored procedure indicates whether a SQL Server login is a member of the specified fixed...
Tag: sp_readerrorlog
Useful Undocumented SQL Server 2016 Stored Procedures (Part 1)
Useful Undocumented SQL Server 2016 Stored Procedures (Part 1) SQL Server 2016 supports the following useful undocumented stored procedures: sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_readerrorlog sp_MSforeachdb The sp_MSforeachdb database engine stored procedure is used to perform the same actions for all databases. Sometimes, you need to perform the same actions for all databases. You can create cursor for this purpose, or...
Four Undocumented SQL Server 2014 Agent Procedures
Four Undocumented SQL Server 2014 Agent Procedures SQL Server 2014 supports the following useful undocumented SQL Server Agent stored procedures: sp_MSgetalertinfo sp_readerrorlog sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info Two of these stored procedures exist in the master database (sp_MSgetalertinfo and sp_readerrorlog), other exist in the msdb database. sp_MSgetalertinfo The sp_MSgetalertinfo stored procedure is used to get information about alerts from Windows registry. Syntax sp_MSgetalertinfo […]
Useful undocumented SQL Server 2012 Agent Procedures
Useful undocumented SQL Server 2012 Agent Procedures SQL Server 2012 supports the following useful undocumented SQL Server Agent stored procedures: sp_MSgetalertinfo sp_readerrorlog sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info Three of these stored procedures exist in the master database (sp_MSgetalertinfo, sp_readerrorlog and sp_MSget_jobstate), other exist in the msdb database. sp_MSgetalertinfo The sp_MSgetalertinfo stored procedure is used to get information about...