Search
Winners

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Advertisements
Top Articles Author
Fri, 06-Mar-2015 Authors
All Time Authors
vishalneeraj-24503
51040
Rajkatie
21960
Bharathi Cherukuri
18040

Latest members | More ...


(Statistics delayed by 5 minutes)
 Interview Question

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 

Share this to:

Bookmark It

Comments or Responses

Login to post response