Adding Linked Servers Using SQL-DMO

  • Hi Andy,

    Nice article, I have learned a ton about SQLDMO from your articles. It is amazing what can be done using this object model.

    Bruce Szabo, MCSE+I, MCDBA, MCSD


    Bruce Szabo, MCSE+I, MCDBA, MCSD

  • Thanks! DMO isnt always the answer of course, but good to know your options (and have some examples).

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • damn you snitz! I just lost a post worthy of Billy Shakespeare ...

    anyway ... - the gist was thx for the great article. on this subject there is a big hole in sql books on line - you guys plugged it. normally MSDN etc is great but where it isn't you guys provide a great value added service.

    Brian Lockwood

    President

    LockwoodTech Software

    Brian Lockwood
    President
    ApexSQL - SQL Developer Essentials

    http://www.apexsql.com/blog

    Stand up for an Independent SQL Community - be Informed

  • Hi Brian,

    Wow, if I was ever included with Andy on SQL-DMO being one of the "guys." Thanks a lot! What I was guessing you meant was SQLServerCentral and I have to agree. There are a lot of holes plugged by these articles.

    Bruce

    Bruce Szabo, MCSE+I, MCDBA, MCSD


    Bruce Szabo, MCSE+I, MCDBA, MCSD

  • quote:


    Hi Brian,

    Wow, if I was ever included with Andy on SQL-DMO being one of the "guys." Thanks a lot! What I was guessing you meant was SQLServerCentral and I have to agree. There are a lot of holes plugged by these articles.

    Bruce

    Bruce Szabo, MCSE+I, MCDBA, MCSD


    yeah - these guys rock. You might too but I was talking about SQLServerCentral.

    I spent 3 hours searching for info. on this topic before asking Andy and he had the answer to me in about 10 minutes.

    I hope MSFT notices this site - these guys do a better job supporting the SQL Server community than Microsoft itself does.

    Brian Lockwood

    President

    LockwoodTech Software

    Brian Lockwood
    President
    ApexSQL - SQL Developer Essentials

    http://www.apexsql.com/blog

    Stand up for an Independent SQL Community - be Informed

  • Great article Andy! You make it seem so easy.

    One thing I notice with DMO is if there is a

    oLinkedServerLogin.LocalLogin = "" user (The Null user you write about) it is worthwhile to check the oLinkedServerLogin.Impersonate. If Impersonate is False then you correctly describe the "Be Made Without Using a Security Context" radio button in EM. If it is true, Then the setting is "Be made using the login's current security context" button. Additionally, if I'm not mistaking, I thing the latter is the default when you create a linked server.

    If there is no oLinkedServerLogin.LocalLogin = "" then I believe you have the equivalent to the "Not be Made" radio button.

    Thanks again for the article and keep 'em coming.

    Bill

    Bill Wunder

  • Damn you snitz! Gotta love it. We havent decided, but we are looking at asp.net alternatives.

    Anyway, we do like filling the gap where we can. Sometimes we know the answer, more often we just work like crazy to figure it out. Forum questions are a great place to identify those gaps.

    Bill, thanks for you comments as well. That makes what, 3 or 4 of us who use DMO?!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply