"ImpersonateClient" property in Yukon

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prasad - 07 Feb 2006 08:33 GMT

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

Reply to this Message

Dan Guzman - 10 Feb 2006 13:25 GMT

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/.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> Hi,
> Does anybody knows how to get the value for "ImpersonateClient"
[quoted text clipped - 6 lines]
> TIA
> Prasad

Reply to this Message