I using SQL Server 2005 Express and Microsoft SQL Server Management Studio Express.
I have a database with several tables, which I'd like to export. I'm switching from Vista to Windows 7.
To export a table, I'm using
exec master..xp_cmdShell 'bcp "SELECT * from MyDB.dbo.Symbols Order By Symbol" queryout ''D:\Databases\Export\Symbols.txt'' -S Name\SQLEXPRESS -c -T'
(where Name is my computer's name)
I get "Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file".
Both SQLExpress and MSSQLSERVER are logged in as Local System.
I sure could use some help here! I'm over my head.