Can .BCP file open in text editor?

Hello!
I think I have asked this question eariler and I am asking it again. Can
a .BCP file (which is a binary file) be opened in any Text Editor (or
any program)?
Thanks for your help!
*** Sent via Developersdex http://www.examnotes.net ***> I think I have asked this question eariler and I am asking it again. Can
> a .BCP file (which is a binary file) be opened in any Text Editor (or
> any program)?
Yes. It is useful? No.|||Test Test (farooqhs_2000@.yahoo.com) writes:
> I think I have asked this question eariler and I am asking it again. Can
> a .BCP file (which is a binary file) be opened in any Text Editor (or
> any program)?
Yes, but if the file is binary it's better to open it in a hex editor,
at least in an editor which can show files in hex format. One example
is Textpad, http://www.textpad.com. Textpad looks at the file ending,
and defaults to text format, but this is configurable. You can also
opt to open a certain file as binary rather than text.
Whatever you do, be careful with editing binary files. The file could
be mashed completely if you are not careful.
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