Accessing LinkedServer properties via SQL Server SMO API -


i have powershell script iterate through list of linkedserver objects in sql server code this:

foreach($linkedserver in $instance.linkedservers) {        ... code ... }    

i want find out information on default security of linked server. see mean, load sql server management studio , open linked server. if don't have any, create 1 remote server. click on security tab , see list of linked server login mappings (linkedserverlogins collection in smo). @ bottom of screen default setting in section called "for login not defined in list above...". cannot find anywhere in smo object model information. possible?

thanks, mark.

it seems in linked server login properties:

foreach($linkedserver in $instance.linkedservers) {        "linkedserver:" + $linkedserver.name      foreach($linkedserverlogin in $linkedserver.linkedserverlogins)     {         " linkedserverlogin:" + $linkedserverlogin.name         foreach($property in $linkedserverlogin.properties)         {             "  property:" + $property.name + " - " + $property.value         }     } }  

impersonate , remoteuser included in properties.


Comments

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -