Can you explain please why Extended SP does not work under Vista ?
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )
UAC turned off. MSQSL runs under Administrator account.
Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.
If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.
select object_id('dbo.xp_mylog')
-- works.
EXEC('sp_helpextendedproc ''xp_mylog''')
xp_mylog c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LogEsp.dll
exec master..xp_mylog
die forever
Konstantin
Hi Konstantin,
Have you enabled extended sprocs? They are disabled by default.
Mike
|||No I did not. How to do this ? I know how to do in Stanard Edition. But this option not visible in Express edition.
There is a TSQL statement to change it or change it in the registry ?
|||is any body can halp me ?
|||Is there is anybody from Microsoft who knows how to enable ESP ?
|||I guess, this is what Mike means:
Open SAC > ...for features ... Navigate your instance ... OLE Automation > enable
Jens K. Suessmeyer
http://www.sqlserver2005.de
Extended Stored Procedure is not ActiveX
