1 Effective date searches are available only for US area codes. 2  Our sources for non-US NPA-NXX data do not provide this information. 3  If you want to search an entire area code regardless of activity, leave both the next and past days fields set to zero. Effective date searches are available only for US area codes. 2  Our sources for non-US NPA-NXX data do not provide this information. 3  If you want to search an entire area code regardless of activity, leave both the next and past days fields set to zero.
If you press Y (for yes) in response to this message, the batch program ends and control returns to the operating system. Therefore, you can insert the pause command before a section of the batch file you may not want to process. While pause suspends processing of the batch program, you can press CTRL+C and then Y to stop the batch program.
Assuming that your trace ID is still equal to 1, the following commands, run in this order, stop the trace and delete the definition from the server: -- This command stops the trace and must be -- run first. EXEC sp_trace_setstatus 1 ,0 -- This command deletes the trace from the server. EXEC sp_trace_setstatus 1 ,2. BOL also fails to note that you won't get an error message if you run the EXEC sp_trace_setstatus 1 ,2 command before stopping the trace.