--- 1、2005版本以上SQL导入数据需要进行的配置
exec sp_configure 'show advanced options',1;
reconfigure;
go
exec sp_configure 'Ad Hoc Distributed Queries',1;
reconfigure;
go

--- 2、数据备份需要进行的配置
exec sp_configure 'show advanced options',1;
reconfigure;
go
exec sp_configure 'xp_cmdshell',1;
reconfigure;
go