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…
This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Register
Already a member? Log in here