Sql server

xp command shell to create file on server

xp command shell to create file on serverExec Master.dbo.Sp_Configure ‘Show Advanced Options’, 1 RECONFIGURE WITH OVERRIDE Exec Master.dbo.Sp_Configure ‘XP_CmdShell’, 1 RECONFIGURE WITH OVERRIDE exec master..xp_cmdshell ‘bcp select * from sys.tabels -o > c:\file.txt’ master..xp_cmdshell ‘bcp ..sys.objects out c:\file.sql -S -U -P -c ‘