locked
using functions across servers RRS feed

  • Question

  • is it possible to use a function from a linked server.

    my organization has several dozen database servers used by many a different people.  however there seem to be certain functions and stored procedures that are used by everyone. what I wanted to do is create a central DataBase to hold these so they don't need to be on every server.  I had intended to link every server to this server and call the functions and sps using 4 part naming.  it seems you can't do that. 

    does anyone have any suggestions on how I can get around this

    thanks

     

     

    Wednesday, September 7, 2011 8:24 PM

Answers

  • Hi kevcri,

    I don't believe there is a way to do this.  Your best bet may be to create a small database that contains all of the functions and simply host a copy of that database on each server.  This isn't quite the single management point you were looking for, but it certainly minimizes your management points.

    I hope that helps.  Please let me know if you have any other questions.

       Thanks,

           Steve

     

     

    • Marked as answer by Stephanie Lv Monday, September 19, 2011 8:49 AM
    Saturday, September 10, 2011 1:00 AM