MSSQL2005 Express SP2 on Vista Professional does not support Extended SP?

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