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’

You may also Interested in

• SQL Server Change Default Schema for User
• SQL Server insert values in to identity field
• Convert Date time in SQl server 2008/2012
• Sql Server Add unique constrint to a column of a table
• SQL server find nth Greatest row