Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 .fmt

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2006-03-18 : 15:08:43
Hi,
How is it possible to create a .fmt file with the following informations if they are required?
server1
database1
table1

Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-03-18 : 18:57:45
if you are referring to the fmt of BCP, you can create the fmt file using a text editor or via the BCP. Just don't specify the -f parameter and run the bcp, it will prompt for all the columns definition (just accept the default) and at the end it will prompt for the fmt filename.



KH

Choice is an illusion, created between those with power, and those without.
Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant

Go to Top of Page
   

- Advertisement -