Discussion in 'ALL SQL SERVER QUESTIONS' started by poorni, Apr 26, 2012.
i want to use user defined functions in multiple databases.
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
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
Can you please give a more concrete example of what you are trying to achieve?
Separate names with a comma.