xp-cmdshell – Tarik Billa

Getting execute permission to xp_cmdshell

November 26, 2023 by Tarik

For users that are not members of the sysadmin role on the SQL Server instance you need to do the following actions to grant access to the xp_cmdshell extended stored procedure. In addition if you forgot one of the steps I have listed the error that will be thrown. Enable the xp_cmdshell procedure Msg 15281, … Read more

Reading a text file with SQL Server

July 22, 2023 by Tarik

Just discovered this: SELECT * FROM OPENROWSET(BULK N'<PATH_TO_FILE>’, SINGLE_CLOB) AS Contents It’ll pull in the contents of the file as varchar(max). Replace SINGLE_CLOB with: SINGLE_NCLOB for nvarchar(max) SINGLE_BLOB for varbinary(max) Thanks to http://www.mssqltips.com/sqlservertip/1643/using-openrowset-to-read-large-files-into-sql-server/ for this!