question

asim15891 avatar image
asim15891 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)
stored-proceduressql server 2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks John. I could not figure out at last what called it, so thought to give it a miss
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.