I have run the bcp command in query window to generate the tsv file. In between I cancelled the query. I tried to kill the SPID. But it is killed/rollback.
I tried to delete the tsv file in server. It is throwing error as 'the file cant be deleted because it is open in bcp.exe'. please assist to resolve