Stored Procedures [dbo].[tng_start_service]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@servicenamevarchar(64)64
Permissions
TypeActionOwning Principal
GrantExecutewvadmin
SQL Script
/****** Object:  Stored Procedure dbo.tng_start_service    Script Date: 12/1/2005 11:49:13 PM ******/

CREATE procedure tng_start_service ( @servicename  varchar(64))

as
    declare @cmdline varchar(255)

    select @cmdline = 'net start ' + @servicename

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