image-135.jpg

Open a Text File From SQL Server using xp_cmdshell

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

Image

 

 

 

 

 

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’

Image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Published by

abhilash

a gadget and internet addict , a red hat certified linux administrator with skills in dataware development and online technologies., follow me on twitter @abhilashsnair

One thought on “Open a Text File From SQL Server using xp_cmdshell”

  1. Pingback: abhilash

Comments are closed.