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
Post a Comment