September 15, 2002 at 12:00 am
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
September 19, 2002 at 4:21 am
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
September 19, 2002 at 5:17 am
Thanks! DMO isnt always the answer of course, but good to know your options (and have some examples).
Andy
September 19, 2002 at 1:19 pm
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
September 19, 2002 at 1:22 pm
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
September 19, 2002 at 1:35 pm
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
September 20, 2002 at 5:17 pm
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
September 21, 2002 at 9:11 am
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
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply