Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

sp_configure 'show advanced options', 1 reconfigure
go
sp_configure 'Ole Automation Procedures', 1 reconfigure
go

declare @script_text varchar(8000), @object int, @hr int
Declare @Res Table(PID int, UserName VarChar)
Declare @output varchar(255)
Declare @source varchar(255)
Declare @description varchar(255)

set @script_text = '' -- тут собираюсь потом написать код

exec @hr = sp_OACreate 'MSScriptControl.ScriptControl', @object out
IF @HR <> 0 
BEGIN	
	print 'error create '+cast(@hr as varchar)+')'
	EXEC @HR = sp_OAGetErrorInfo @object, @source OUT, @description OUT
	IF @HR = 0 
	BEGIN
		SELECT @output = ' Description: '+@description
		PRINT @output
		RETURN
	END
END