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

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

posted on 2012-10-09 16:58  Orz..  阅读(224)  评论(0)  编辑  收藏  举报

导航