Viewing 3 posts - 46 through 48 (of 48 total)
I was in the master db. My first box did not store my spaces, so it was hard to read, sorry about that. (Having trouble getting this site...
January 8, 2004 at 2:07 pm
if exists (select 1 from dbo.sysobjects where id = object_id(N'[dbo].[sp_schedule_status_reset]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_schedule_status_reset]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[sp_schedule_status_reset]
AS
EXEC master..xp_cmdshell 'net start sqlserveragent',...
January 8, 2004 at 12:36 pm
Viewing 3 posts - 46 through 48 (of 48 total)