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.
BCP.exe submits commands over the TDS (Tabular Data Stream) connection to the SQL Server. Using XEvent you can trace the various events (Connect, Disconnect, Transaction and Batch) and observe the behavior. What the customer was observing is the BULK INSERT command in dm_exec_requests.