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

srinivas P

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prabhu Raja15y ago
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 Bhat15y ago
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.