Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding Linked Servers Using SQL-DMO Expand / Collapse
Author
Message
Posted Sunday, September 15, 2002 12:00 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 8:30 AM
Points: 6,794, Visits: 1,905
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/addinglinkedserversusingsqldmo.asp>http://www.sqlservercentral.com/columnists/awarren/addinglinkedserversusingsqldmo.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #6799
Posted Thursday, September 19, 2002 4:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, Visits: 6
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
Post #41580
Posted Thursday, September 19, 2002 5:17 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 8:30 AM
Points: 6,794, Visits: 1,905
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/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #41581
Posted Thursday, September 19, 2002 1:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
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
Post #41582
Posted Thursday, September 19, 2002 1:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, Visits: 6
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
Post #41583
Posted Thursday, September 19, 2002 1:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
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
Post #41584
Posted Friday, September 20, 2002 5:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 2, 2011 8:13 AM
Points: 19, Visits: 146
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
Post #41585
Posted Saturday, September 21, 2002 9:11 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 8:30 AM
Points: 6,794, Visits: 1,905
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/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #41586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse