bcp file size

I use bcp to copy a file and the bak it generated is 966637 KB. However, when I run sp_spaceused, it shows me the following size :

reserved data index_size unused
------ ------ ------ ------
550752 KB 395272 KB 155464 KB 16 KB

The difference doesn't make sense to me. Can anyone help pls?What file are you using to copy with bcp? mdf?|||Did you bcp the data out with the -c or -n switch? This is quite understandable with the -c switch, as all the numeric and datetime values will take up much more space than in the database.|||I use the bcp to copy 1 table and the command I use is :

bcp <table_name> out <output file> -N - S <server Name> -k -T -m 1 -e <error file>|||So, you are trying to correlate the size of the table to the size of the resulting file using BCP? Well, it shouldn't make sense, otherwise, what's the point of having a database, heh?!|||So, you are trying to correlate the size of the table to the size of the resulting file using BCP? Well, it shouldn't make sense, otherwise, what's the point of having a database, heh?! Atomicity, Consistency, Isolation, and Durability... just to name a couple.

Basic Report & Report is being generated

I followed the tutorial http://msdn2.microsoft.com/en-us/library/ms167305.aspx with no problem but when I tried to preview the report the green circle just kept spinning and spinning.

I'm able to execute the command under the data tab with no problems. I'm able to view built in reports for SQL Server 2005. I've tried restarting Visual Studio and the entire PC but the report will still no generate.

Thoughts or ideas about what my problem is?

SQL Server 2005 SP1

Thanks,
MikeTurns out if I move the solution to a location on my local machine as opposed to a UNC, the report generated just fine. I'm pretty sure it would eventually generate on the UNC it would just take forever!

Mike|||I have this same issue and I'm not writing to a UNC path, could there be any other reasons?