Create Synonym for Function
Would You Prompt Me, Please, How to Create Synonym for Function in Sql Server? This Method: Create Synonym cDateMin for Server. Db. [Dbo]. cDateMin Doesn't...
Would you prompt me, please, how to create synonym for function in SQL Server?
This method: CREATE SYNONYM cDateMin FOR server.db.[dbo].cDateMin
Doesn't help.
Script:
select dbo.cDateMin()
leads to the error:
Msg 4121, Level 16, State 1, Line 9
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.cDateMin", or the name is ambiguous.
Script:
select cDateMin()
leads to the error:
Msg 195, Level 15, State 10, Line 9
'cDateMin' is not a recognized built-in function name.
Script:
select dbo.cDateMin
leads to the error:
Msg 4104, Level 16, State 1, Line 9
The multi-part identifier "dbo.cDateMin" could not be bound.
Script:
select cDateMin
leads to the error:
Msg 207, Level 16, State 1, Line 9
Invalid column name 'cDateMin'.
Guide from official source (to make a synonym by clicking the right button of the mouse on synonyms folder in SSMS (link) and creation the synonym 'by hand') created the same synonym and led tho the same errors.
Creation synonyms with the names different from the function name also didn't help.