SQL Server Performance

use user defined functions in multiple databases.

Discussion in 'ALL SQL SERVER QUESTIONS' started by poorni, Apr 26, 2012.

  1. poorni New Member

    i want to use user defined functions in multiple databases.
    poorni, Apr 26, 2012
    #1

  2. Shehap Moderator

    First , welcome to Forums ..

    You might use your UDF starting with the prefix of DB name like [DB_name].[dbo].[UDF_name] if used inside the same DB Server unless you have to add another prefix of linked server name like :

    [linked_Server].[DB_name].[dbo].[UDF_name]where linked server should refer to that DB server having UDF

    Or other help needed , please let me know
    Shehap, Apr 27, 2012
    #2

  3. poorni New Member

    I need to access multiple database table also in the UDF function is it possible to access table of other database from some other database
    poorni, Apr 27, 2012
    #3

  4. FrankKalis Moderator

    Can you please give a more concrete example of what you are trying to achieve?
    FrankKalis, May 1, 2012
    #4

Share This Page