Home Forums SQL Server 2008 SQL Server 2008 - General On the same server, can you use a TABLE-valued user-defined function from another database? RE: On the same server, can you use a TABLE-valued user-defined function from another database?

  • Also, FYI, depending on your database nomenclature, it may be better to create a synonym to this function instead of using a 3 part object name [db_name].[schema_name].[function_name]

    That way your queries can always reference the same name (the synonym) regardless of where the function actually lives.
    https://docs.microsoft.com/en-us/sql/relational-databases/synonyms/synonyms-database-engine