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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

abhilash

abhilash, is a programmer by profession and a technology addict with a passion towards browsing , shopping and imaging . My views may be biased on reviews. all images and videos are copyrighted to respective owners.

1 comment

Your Header Sidebar area is currently empty. Hurry up and add some widgets.