How to execute particular sql function in all databases of particular pC?

Question

How to execute particular sql function in all databases of particular pC?
using frontend application using c#.

I have written one function in one datbase,
My Requiremment is i want to execute that function in all databases of server
using frontend app.
select database(dropdown)
execute function for that database(here execute is button)

How to do this?
any idea?
thanks inadvance

Prabhu Raja · Answer

Hi First We have to give permission for all databases to call that function. Use following query to grant permission to the function. EXEC sp_msforeachdb 'USE ?; SELECT DB_NAME() OBJECT_ID(''dbo.functionname'')' or try this Click Here - ---------------------------------

Satish Bhat · Answer

1] Store all the databases and its login/connection informations in a master table. 2] Take the database names from the master table and display in a dropdown list. 3] When user selects a particular database you can get the login/connection information from master table for the selected database build a connection string connect and execute the function with required parameters.