Lepsik


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




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

Mike Wachal - MSFT


Hi Konstantin,

Have you enabled extended sprocs They are disabled by default.

Mike







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

Lepsik

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






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

Lepsik

is any body can halp me





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

Lepsik

Is there is anybody from Microsoft who knows how to enable ESP





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

Jens K. Suessmeyer

I guess, this is what Mike means:

Open SAC > ...for features ... Navigate your instance ... OLE Automation > enable

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---






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

Lepsik

Extended Stored Procedure is not ActiveX