Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cjpsx
Starting Member
34 Posts |
 Posted - 2006-05-26 : 16:37:13
|
| My reports call functions located in a particular database/data source.If a user needed to change the datasource to a different database then I assume the functions would no longer apply if they were not in that database. Is there a best practice protocol or procedure to assure that the functions are packaged with the report? I would hate to have to build functions in each database. That would make it difficult to update. I wonder if I can reference a function in the SQL by using a prefix? |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-06-02 : 13:59:22
|
| You should be able to use three part naming to reference the function.database.owner.object |
 |
|
|
|
|
|
Data Sources and Functions