Sunday, February 19, 2012

"ImpersonateClient" property in Yukon

Hi,
Does anybody knows how to get the value for "ImpersonateClient" property
which is on IntegratedSecurity Object in SQL - DMO for SQL Server 2005
(Yukon).
Documentation says that the functionality has been moved to "Server
Connection" class of SMO but I couldnt find the property that will return
the result for the above.
TIA
Prasad
The documentation states that the ImpersonnateClient property is a Settings
class property but I don't see it implemented there. As a workaround,
another method to retrieve the value:
string proxyAccount = (string) ServerConn.ExecuteScalar(
"SELECT credential_identity" +
" FROM sys.credentials" +
" WHERE name = N'##xp_cmdshell_proxy_account##'");
I'm not sure if this a documentation or product issue. I submitted feedback
at http://lab.msdn.microsoft.com/productfeedback/.
Hope this helps.
Dan Guzman
SQL Server MVP
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:uTPjvE8KGHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Does anybody knows how to get the value for "ImpersonateClient"
> property which is on IntegratedSecurity Object in SQL - DMO for SQL Server
> 2005 (Yukon).
> Documentation says that the functionality has been moved to "Server
> Connection" class of SMO but I couldnt find the property that will return
> the result for the above.
>
> TIA
> Prasad
>

No comments:

Post a Comment