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: 9441
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
-- To update the currently configured value for advanced options.
EXEC sp_configure 'xp_cmdshell', 1
Asked In: Many Interviews