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

Question

Hi to all I have written one table valued function in one database. my requirement is i want to execute that function in all databases under server/Pc. i am using sqlserver2008? can any one help me? thanks inadvance

Syed Nayab Ali · Answer

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

Sam Hobbs · Answer

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