Press enter to see results or esc to cancel.

Open a Text File From SQL Server using xp_cmdshell

For this we need to enable xpCMDShell enable in Surface Area Configuration







Goto Right Click on Server > Facets

Select Surface Area Configuration

Go to

xPcmdShell enable

Now go to New Query

EXEC master.dbo.xp_cmdshell ‘type d:test.txt’

















Comments are disabled for this post