/****** Object:  Stored Procedure dbo.tng_stop_service    Script Date: 12/1/2005 11:49:13 PM ******/

CREATE procedure tng_stop_service ( @servicename  varchar(64))

as
    declare @cmdline varchar(255)

    select @cmdline = 'net stop ' + @servicename

     exec tng_master..xp_cmdshell  @cmdline , NO_OUTPUT
GO
GRANT EXECUTE ON  [dbo].[tng_stop_service] TO [wvadmin]
GO