Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    14

    Angry Unanswered: accept all directory in sql query analizer

    Well I try to find why I can not run dtsrun with xp_cmdschell
    but I try to put all the directory c:\program files\microsoft SQL\...
    and the procedure response that he don´t find c:\program command
    is there a instruccion for the large names on directories that make
    the correct functionality of the path?

    Regards. Mirtha.

  2. #2
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Re: accept all directory in sql query analizer

    I use double-quoted names in other places, maybe it works here... also, as a turn around you can use the ~ short names form.
    Hope it helps,
    César

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    There is a convention for shortening a long name to an 8.3 convention but I find it hard to remember.

    You can just put your pathname and executable in double quotes, i.e. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe"
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    Jan 2003
    Posts
    14

    Re: accept all directory in sql query analizer

    Originally posted by Cesar Fraustro
    I use double-quoted names in other places, maybe it works here... also, as a turn around you can use the ~ short names form.
    Hope it helps,
    César
    Yes , I do but it does not work. thanks.

  5. #5
    Join Date
    Jan 2003
    Posts
    14

    Thumbs up

    Originally posted by Paul Young
    There is a convention for shortening a long name to an 8.3 convention but I find it hard to remember.

    You can just put your pathname and executable in double quotes, i.e. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe"
    Yes it works, thanks and regards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •