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
Pra
The documentation states that the ImpersonnateClient property is a Settingsclass 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
"Pra
" <ekke_nikhil@.yahoo.co.uk> wrote in messagenews: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
> Pra
>
