Starting, connecting to MSDE from command line

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris Themi (ChrisThemi_at_discussions.microsoft.com)
Date: 09/17/04

  • Next message: Mike Epprecht (SQL MVP): "RE: Connection issues" 
    Date: Fri, 17 Sep 2004 00:23:05 -0700

    I am trying to start and connect to an MSDE instance on my PC using a
    sqlservr.exe and osql but I have no success. Anybody knows how to do this
    (the documentation does not say much on this). When I connect to the server
    through the Enterprice Mgr then the rest of the batch file (attaches db,
    creates login and user) works OK.

  • Next message: Mike Epprecht (SQL MVP): "RE: Connection issues"

    Relevant Pages

    • Re: osql txt file output problem
      ... I tried to add LTRIM and Convert without any success. ... It is strange because when I run it on QA with CTRL-T, I get a clean file. ... I need to use OSQL because I am creating a batch file that includes the OSQL ... > you could trim the result, or simply convert to a shorter varchar length ...
      (microsoft.public.sqlserver.programming)
    • How to detect BCP success/fail in batch file?
      ... We are calling BCP from a batch file but cannot figure out how to detect ... With osql we use EXITwith a ... value to indicate success or failure. ...
      (microsoft.public.sqlserver.tools)