--
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 @sql nvarchar ( 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 )
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 @sql nvarchar ( 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 )