How to call an extended procedure from a function
Posted
by Alan Featherston Lago
on Stack Overflow
See other posts from Stack Overflow
or by Alan Featherston Lago
Published on 2010-03-10T16:39:06Z
Indexed on
2010/03/14
10:05 UTC
Read the original article
Hit count: 337
hi im having trouble trying to get the following function to work.
CREATE FUNCTION test ( @nt_group VARCHAR(128) )
RETURNS @nt_usr TABLE (
[name] [nchar](128) NULL
, [type] [char](8) NULL
, [privilege] [char](9) NULL
, [mapped login name] [nchar](128) NULL
, [permission path] [nchar](128) NULL
)
AS BEGIN
INSERT INTO @nt_usr
EXEC master.dbo.xp_logininfo 'DOMAIN\USER', @nt_group
RETURN
END
As far as i know i should be allowed to call an extended stored procedure, im getting the following error
Mes 443, Level 16, State 14
Could it be that xp_logininfo might return different result sets depending on the parameters? When i use openquery i can overcome this by setting this: SET FMTONLY OFF. Does anyone know if there's a similar workaround for my problem?
© Stack Overflow or respective owner