sql server odbc: Hi,

I'm trying to test an SP with SQL Query Analyser from my client db an
it gives me this error :

[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission
denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

I'm using Microsoft SQL SE SP4 and i'm new to it. I read on gg forums
that you have to execute sp_sdidebug with the 'legacy_on' parameter and
you need EXECUTE permission on sp_sdidebug. How do you do that !

Need help ! Thanks !

Olivier

To grant permission, you can use:
GRANT EXECUTE ON sp_sdidebug TO <YourUser>
To enable it for legacy clients, use:
EXEC sp_sdidebug 'legacy_on'

-Sue

On 14 Feb 2005 06:24:02 -0800, "OliE" <olie.rej@gmail.com>
[quoted text, click to view]