Permission to execute fn_get_sql

Dear All,

I want to assign privelege to execute the following in SQL Server 2000 SP4 + 2187

select * from ::fn_get_sql(0x01000700AC38820138A1786C0400000000000000)

I have tried the following:-

use master

go

grant select on fn_get_sql to <user>

I am getting error:

Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'fn_get_sql'.

I believe that ::fn_get_sql is an administrative use only function, and that permission is limited to either sysadmin or db_databaseowner. (I think the former...)

|||

You require VIEW SERVER STATE permission to use it. Please refer to BOL (http://msdn2.microsoft.com/en-us/library/ms189451.aspx) for detailed information.

-Raul Garcia

SDE/T

SQL Server Engine