Test your technical skills online, appear in Virtual Interview and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Make friends on DotNetFunda.com and expand your network!
Winners

Win Prizes

Announcements
Like us on Facebook
Sponsor
Top Articles Author
Wed, 16-Apr-2014 Authors
All Time Authors
Rajkatie
20480
Vishal@Neeraj
19600
Bharathi Cherukuri
18040

Latest members | More ...


(Statistics delayed by 5 minutes)

Can we execute "BCP" command directly in the SQL Server Management studio?

 Posted by Virendradugar on 4/16/2010 | Category: Sql Server Interview questions | Views: 9966
Answer:

No, we can't not. BCP utility is a command line utility. To execute it within SQL Server Management studio, one has to enable the xp_cmdshell. We can execute bcp command through xp_cmdshell only. xp_cmdshell by default is false. We need to enable it.

Use below script to enable BCP


EXEC sp_configure 'show advanced options', 1

GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO


Asked In: Many Interviews | Alert Moderator 

Found interesting? Add this to:




Comments or Responses

Login to post response.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.