| Dan Guzman 2006-02-10, 9:23 am |
| 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_prox
y_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
>
|