Tag Info

New answers tagged


OK, so the problem was that the server where the SQL Server is running, all in a sudden was removed from the DNS. :-/ Not sure why, the server can ping to the rest of the data center, but the rest of the data center cannot ping or access this server. Rebooting the server resolved this issue.


To export: bcp "[MyDatabase].dbo.Customer" out "Customer.bcp" -N -S ServerName -T -E -U"xxxxxx" -P"xxxxxxx" To import: bcp "[MyDatabase].dbo.Customer" in "Customer.bcp" -N -S ServerName -T -E -b 10000 -U"xxxxxx" -P"xxxxxxx"

Top 50 recent answers are included