Posted by Alex on 06/20/06 14:30

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.

I know I could delve into the registry and get the name from there, but
I want to avoid this.

Cheers

Alex

• Next in forum: Error: 16954, Severity: 10, State: 1 and Timeout problem
• Prev in forum: Re: Creating Cursor from Stored Procedure
• Thread view: SQLDMO - Getting 'Local' Server name

[Reply to this message]