"Object is required" (DMO) ?

Dear all,
are you seeing something weird here?
Dim oServer As SQLDMO.SQLServer2
'Dim oServer As SQLDMO.SQLServer2
For Each oServer In oApplication.ListAvailableSQLServers
Debug.Print oServer.Name
Next
This snippet fails.
Let me know where failing is any clue...
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)sorry for bothering
For i = 1 To oApplication.ListAvailableSQLServers.Count
Debug.Print oApplication.ListAvailableSQLServers.Item(i)
Next
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Enric" wrote:

> Dear all,
> are you seeing something weird here?
> Dim oServer As SQLDMO.SQLServer2
> 'Dim oServer As SQLDMO.SQLServer2
> For Each oServer In oApplication.ListAvailableSQLServers
> Debug.Print oServer.Name
> Next
> This snippet fails.
> Let me know where failing is any clue...
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide informati
on
> without seeing the code. location: Alicante (ES)|||ListAvailableSQLServers returns a NaneList object, not a SQLServer
collection. Try something like:
Dim Name As String
For Each name in oApplication.ListAvailableSQLServers
Debug.Print name
Next name
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:FE7AF93D-0E90-4C6F-AF11-FC5DDD846BDB@.microsoft.com...
> Dear all,
> are you seeing something weird here?
> Dim oServer As SQLDMO.SQLServer2
> 'Dim oServer As SQLDMO.SQLServer2
> For Each oServer In oApplication.ListAvailableSQLServers
> Debug.Print oServer.Name
> Next
> This snippet fails.
> Let me know where failing is any clue...
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide
> information
> without seeing the code. location: Alicante (ES)

"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
PraThe 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
"Pra" <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
> Pra
>

"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
>

"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
>

"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
PrasadThe 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
>

"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
>

"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
PrasadThe 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
>