Posted by Chris Cheney on 06/20/06 21:31

"Alex" <alex_seymour@lineone.net> wrote in
news:1150813848.497464.171900@i40g2000cwc.googlegroups.com:

>
> Hi,
>
> I am new to the mysteries of SQLDMO.
>
> I have written a program whereby the user can select which SQL server
> to connect to on the Network and this works fine.
> I am using the SQLDMO.Application.ListAvailableSQLServers routine and
> this works fine.
>
> However, the Server on the users machine appears as 'Local'
>
> I need to display the server name as the actual server name instead of
> 'Local'
>
> Any ideas how to do this with SQLDMO.

Create an instance of the SQLServer object. You then have the choice of the
following properties:

Name this will give you the "(local)" name
HostName
TrueName
NetName

See SQLDMO in Books Online, Objects/S/SQLServer

• Next in forum: Re: Cannot remove dbo rights from a user
• Prev in forum: Re: One Database vs. Multiple Databases
• Thread view: Re: SQLDMO - Getting 'Local' Server name

[Reply to this message]