*i installed visual studio 2013 ultimate which includes sql 2012 express edition
* i made a database using the managemnt studio inside the visual studio
* now my problem is that i want to use bcp to back up one of database tables
*i googled through the internet and wrote my query as it stated but every time i get an error
* the query is
declare @sql varchar(8000)
select @sql = 'cd E:\>bcp pharmy_database2012.items out E:\bcptest3.txt -T -S (localDB)\V11.0'
exec master..xp_cmdshell @sql
** ERROR IS
output
Access is denied.
NULL
**SOME ADDITIONAL INFORMATIONS
*SERVICENAME------LOCALDB#F469D3DB
*SERVERNAME -----DESKTOP-2SORBMA\LOCALDB#F469D3DB
*the drive e security permissions is under full controll
what i want is to export datatble of very large size ----can u help me please
What I have tried:
http://www.sqlservercentral.com/Forums/Topic237238-8-1.aspx
http://dba.stackexchange.com/questions/31202/unable-to-open-bcp-host-data-file-error
http://softescu.com/blog/knowledge-centre/error-microsoftsql-server-native-client-100unable-open-bcp-host-data-file-sql