asked
sql server stored procedure information
recently a report came that I ran the below query in a server, but I never ran it. can someone let me know what this query is or what it does or any information related to it and how did it get triggered., might be it gets triggered in the background by some activity, any help is appreciated: CREATE PROCEDURE dbo.sp_verify_subsystems @syssubsytems_refresh_needed BIT = 0 AS BEGIN SET NOCOUNT ON DECLARE @retval INT DECLARE @InstRootPath nvarchar(512) DECLARE @ComRootPath nvarchar(512) DECLARE @DtsRootPath nvarchar(512) DECLARE @DTExec nvarchar(512)
This procedure is a system procedure that from my understanding is called upon restart of SQL Server.
https://mattsql.wordpress.com/2012/02/15/sql-server-subsystems/ Of course there might be other methods that this gets called. Given that it's a system procedure, I'm not sure that I'd worry about it.
18 People are following this question.
