I have a central utility database in each SQL Server instance, called
Utility. In it, I have a bunch of centralized functions and procedures that I call from other databases.
A function I have in it is called
create function [dbo].[GetFqn](@objectId bigint) returns varchar(100) as begin declare @fqn varchar(100); select @fqn = quotename(object_schema_name(@objectId)) + '.' + quotename(object_name(@objectId)); return @fqn; end
When I call this function from another database it returns
select Utility.dbo.GetFqn([object_id]) from sys.tables
What should I do to make it work?