MSSQL_打开xp_cmdshell

1...

--------------------------------------------------------------------------

EXEC master..xp_cmdshell 'BCP viewfocus..v1 in F:\sql\v1.txt -c -T'

报错.....

2.打开------------------------

--------------------------------------------------------------------------
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO

--------------------------------------------------------------------------

3.

EXEC master..xp_cmdshell 'BCP viewfocus..v1 in F:\sql\v1.txt -c -T'

OK

--------------------------------------------------------------------------

原文地址:https://www.cnblogs.com/vimmer/p/2717059.html