Wednesday, March 7, 2012

Run an SQL function interdatabase.

Hi all,

I have a User function created within one SQL DB (an allways existing DB), but I want to run it on DB's (with same structure: tabels, views,...) that are dinamically created (one per mount), is this possible?

ThX

NeuralCyou can write the queries in the stored proc as a generalized ones using opendatasource etc and pass the server name,databsse name as parameters but it could be very slow..

hth

No comments:

Post a Comment