question

sudhi.tsql avatar image
sudhi.tsql asked

what is the replacement of xp_cmdshell in sql server 2014 or 2008

Hi, I needs to read the zip files and write create the same zip file using sql server (with out xp_cmdsehll),Please help me
sql-server-2008-r2sql-server-2014xp_cmdshell
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
The best solution to use instead of xp_cmdshell is PowerShell. There are lots of documents on how to read a .ZIP file from [within PowerShell][1]. PowerShell can be called directly from Agent too. [1]: http://www.howtogeek.com/tips/how-to-extract-zip-files-using-powershell/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.