Install/Uninstall windows service manually

To uninstall your service manually

1. Windows Start menu or Start screen, choose Visual Studio, Visual Studio Tools, Developer Command Prompt.
2. Go to your service project folder
3. Find the service exe
4. command: installutil /u <yourproject>.exe  

To install your service manually

1. Windows Start menu or Start screen, choose Visual Studio, Visual Studio Tools, Developer Command Prompt.
2. Go to your service project folder
3. Find the service exe
4. command: installutil <yourproject>.exe  

Add Trace to SP

declare @tracedata varbinary(8000);
SET @tracedata = cast(@EncCCNumber AS varbinary(8000));
EXEC sp_trace_generateevent 82,
N'@EncCCNumber',
@tracedata ;

SET @tracedata = cast(@Token as varbinary(8000));
EXEC sp_trace_generateevent 82,
N'@Token',
@tracedata;