BCP

Hi,
I am not able to export the result of sys.assemblies using BCP. The output
file is created but it is empty (the result of SELECT in SSMS is not empty).
BCP displays a message indicating that 0 rows were exported. It seems there
is no error!
Thanks,
LeilaLeila (Leilas@.hotpop.com) writes:
> I am not able to export the result of sys.assemblies using BCP. The
> output file is created but it is empty (the result of SELECT in SSMS is
> not empty). BCP displays a message indicating that 0 rows were exported.
> It seems there is no error!
Did you specify the database? I tried this on my machine:
bcp slasketti.sys.assemblies out e:\temp\slask.bcp -T -c -S .\NELJ
slasketti is my database, and .\NELJ is an instance that runs SQL 2005.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks Erland,
Yes I did :(
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns97252351C54Yazorman@.127.0.0.1...
> Leila (Leilas@.hotpop.com) writes:
> Did you specify the database? I tried this on my machine:
> bcp slasketti.sys.assemblies out e:\temp\slask.bcp -T -c -S .\NELJ
> slasketti is my database, and .\NELJ is an instance that runs SQL 2005.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx