How to execute one function in all databses under one server using sqlserver2008?

I think you need to enumerate the databases and then you can execute the function for each of them. Try using the following query to get the databases.

SELECT name FROM sys.databases

Hi Srinivas,

If you want to use ur function in different database then just mention server name before function name as prefix.
for example:
if ur function exist in sever1 and you want to use it in server2 then just write server1.dbo.function_name in server 2.

Please try it I think it will work

Thanks