Adding Linked Servers Using SQL-DMO

  • Andy Warren

    SSC Guru

    Points: 119655

  • bmsjr

    Ten Centuries

    Points: 1199

    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

  • Andy Warren

    SSC Guru

    Points: 119655

    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/

  • Brian Lockwood

    SSCarpal Tunnel

    Points: 4028

    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

  • bmsjr

    Ten Centuries

    Points: 1199

    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

  • Brian Lockwood

    SSCarpal Tunnel

    Points: 4028

    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

  • Bill Wunder

    Old Hand

    Points: 317

    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

  • Andy Warren

    SSC Guru

    Points: 119655

    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