patternMinor
Was 'ActiveX Scripting' step type secretly removed from SQL Server 2016?
Viewed 0 times
activexscriptingremovedserversecretlysqltypestepwasfrom
Problem
Migrating our database from SQL Server 2012 to 2016, we can't recreate an SQL Agent job that involves an ActiveX Scripting step written in VBScript.
The error message suggests that
I know ActiveX Scripting is marked as "will be removed in a future version of SQL Server". However I cannot see anything about it actually being removed in this version of SQL Server.
SQL Server documentation seems to suggest it is still available in SQL Server 2016:
Was
The error message suggests that
'ACTIVESCRIPTING' is not an allowed value for the @subsystem parameter of sp_add_jobstep.I know ActiveX Scripting is marked as "will be removed in a future version of SQL Server". However I cannot see anything about it actually being removed in this version of SQL Server.
SQL Server documentation seems to suggest it is still available in SQL Server 2016:
- Create an ActiveX Script Job Step (SQL Server 2016)
- Documentation on
sp_add_jobstep, updated in March 2017, still lists@subsystem ='ACTIVESCRIPTING'as available.
Was
@subsystem ='ACTIVESCRIPTING' in fact secretly removed in an undocumented way, or did we miss an installable component that enables it?Solution
Discontinued Database Engine Functionality in SQL Server 2016 indicates
ActiveX subsytem is discontinued. Use command line or PowerShell scripts instead.Code Snippets
ActiveX subsytem is discontinued. Use command line or PowerShell scripts instead.Context
StackExchange Database Administrators Q#170715, answer score: 9
Revisions (0)
No revisions yet.