var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file
I need to be able to use BCP in SSMS to export to a text file.
Exec master..xp_cmdshell 'bcp "select name from sysobjects" queryout "C:\Nonah_Share\out.txt" -c -T -S'
is not working
I am getting
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file
The folder is shared with everyone and I have full admin rights to my local machine although I do not have the server installed just SSMS
I am running SSMS 2005
Can someone please assist?
Maybe the service account for ssms does not have permission to folder?
I got it... No it was I neeeded fully qualified \\myservername\Nona_Share\out.txt
Thanks for your help though
Tags for this Thread