Return to Question

code formatting

Source Link

edit approved Sep 11, 2015 at 8:13

I created a function, I and granted select on [dba].[ufn_track_dailies][dba].[ufn_track_dailies] to publicpublic. The function shows up under table valued functions, but when I try to use it I get thean error:

select [dba].[ufn_track_dailies]('Real Name','', '08-01-2015', '08-31-2015')

select [dba].[ufn_track_dailies]('Real Name','', '08-01-2015', '08-31-2015')

I created a function, I granted select on [dba].[ufn_track_dailies] to public. The function shows up under table valued functions, but when I try to use it I get the error:

select [dba].[ufn_track_dailies]('Real Name','', '08-01-2015', '08-31-2015')

I created a function and granted select on [dba].[ufn_track_dailies] to public. The function shows up under table valued functions, but when I try to use it I get an error:

select [dba].[ufn_track_dailies]('Real Name','', '08-01-2015', '08-31-2015')

Source Link

asked Sep 10, 2015 at 22:39

Denise Prendergast

Cannot find either column "dba" or the user-defined function or aggregate "schema.functionName", or the name is ambiguous

I created a function, I granted select on [dba].[ufn_track_dailies] to public. The function shows up under table valued functions, but when I try to use it I get the error:

select [dba].[ufn_track_dailies]('Real Name','', '08-01-2015', '08-31-2015')

functions