HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Was 'ActiveX Scripting' step type secretly removed from SQL Server 2016?

Submitted by: @import:stackexchange-dba··
0
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 '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.