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.
  2. Shehap MVP, MCTS, MCITP SQL Server

    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
  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
  4. FrankKalis Moderator

    Can you please give a more concrete example of what you are trying to achieve?

Share This Page