1. bslapshot New Member

   I found this posthttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4176 on google but I don't understand the directions. Sorry Im new to this but a little clarification would help alot.

   bslapshot, Feb 9, 2005

   #2
2. Madhivanan Moderator

   The concept is to read from table and write it into the text file.
   
   exec xp_cmdshell 'bcp "select * from databaseName..TableName" queryout "D:fileName.txt" -c'
   
   Madhivanan

   Madhivanan, Feb 9, 2005

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in