Re: How can I obtain all the SQL SERVER's names in my domain

From: Enric (Enric_at_discussions.microsoft.com)
Date: 06/28/05 

Date: Tue, 28 Jun 2005 11:55:05 -0700

thanks a lot Hari

"Hari Prasad" wrote:

> Hi,
>
> Try the below command from command prompt.
>
> OSQL -L
>
> Thanks
> Hari
> SQL Server MVP
>
> "Enric" <Enric@discussions.microsoft.com> wrote in message
> news:85E1BA68-3430-4807-BCC0-FD77AB8698A9@microsoft.com...
> > Dear all,
> >
> > Regarding the aforementioned question I don't know if launching one script
> > in VB
> > and retrieving all the names is compulsory.
> >
> > Is there any way or method for obtain that info via job/sp?
> >
> > I hope have been sufficiently explicit.
> >
> > Thanks in advance and regards,
>
>
>

Relevant Pages

  • Re: MSDE 2000 help please
    ... > databases by using osql in a command prompt but is there an easier way? ... The data and objects are stored in MDF files on your hard drive. ...
    (microsoft.public.sqlserver.server)
  • Service Pack 3
    ... MSDN tells me to go to a Command Prompt ... >and enter osql -U sa and then enter the password. ... >Hal Fliegelman ...
    (microsoft.public.sqlserver.security)
  • Cannot connect to SQLEXPRESS via MS Enterprise Library??
    ... Windows XP ... ..NET 2.0 {for SQLExpress} ... This works from a command prompt ... osql -E -S localhost\SQLEXPRESS ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Copying Stored Procedures from One Database To Another
    ... with msde you can use command line utility osql to run script file. ... Go to command prompt and run "osql /?" ...
    (microsoft.public.sqlserver.programming)
  • Service Pack 3
    ... Service Pack 3 will not run unless I create a "strong" ... MSDN tells me to go to a Command Prompt ... and enter osql -U sa and then enter the password. ...
    (microsoft.public.sqlserver.security)