I want to run a shell script from a stored procedure as a workaround to achieve functionality not offered by tool by default.
Is it possible? Database is SQL Server, bash shell
I want to run a shell script from a stored procedure as a workaround to achieve functionality not offered by tool by default.
Is it possible? Database is SQL Server, bash shell
2条答案
按热度按时间fafcakar1#
Nope the approved answer is totally wrong. At the moment even with SQL Server 2022 xp_cmdshell isn't usable with the linux version.
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2022?view=sql-server-ver15#unsupported-features-and-services
dzjeubhm2#
Yes. Check out https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-cmdshell-transact-sql?view=sql-server-ver15 . To use xp_cmdshell you have to activate it, this is done with the commands: