-- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1 GO -- To update the currently configured value for advanced options. RECONFIGURE GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1 GO -- To update the currently configured value for this feature. RECONFIGURE GO ---xp_cmdshell 'cd C:Program FilesMicrosoft SQL Server90ToolsBin' xp_cmdshell 'dir *.exe' SELECT NAME,NAME FROM SYS.OBJECTS xp_cmdshell 'bcp northwind.dbo.orders out c:mytest -T -c' declare@sqlnvarchar(max) set@sql='' select@sql=@sql+' xp_cmdshell '+'''bcp northwind.dbo.'+quotename(name)+' out c:'+name+'.dat -T -c '+''''from sys.objects where type='u'; select@sql exec (@sql)