Windows 10: I need to excute a .SQL file from CMD line

Discus and support I need to excute a .SQL file from CMD line in Windows 10 Customization to solve the problem; The user that i run sqlcmd is the same who logging in sql server (AD005\z003aedu), but not the same who log in Windows (z0042hjv), so i changed in sql... Discussion in 'Windows 10 Customization' started by ramonquintana, Jun 6, 2019.

  1. I need to excute a .SQL file from CMD line


    The user that i run sqlcmd is the same who logging in sql server (AD005\z003aedu), but not the same who log in Windows (z0042hjv), so i changed in sql server to allows logging in both, sql server and Windows authentication, but once i run sql2.bat as administrator (AD005\z003aedu) in CMD line i got the error, i don´t know why..

    error:

    C:\BPC\Procesos_Almacenados>sql2.bat
    C:\BPC\Procesos_Almacenados>echo off
    Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'AD005\z003aedu'..
    Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Cannot open database "1RQ_BPCSQL1" requested by the login. The login failed..


    :)
     
    ramonquintana, Jun 6, 2019
    #1

  2. SQL Error

    Am trying to reinstall SQL express and am getting below Error message.

    Error 27506, Error executing SQL script CreateDB. Line 27. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (1802)
     
    AmosMacharia Kamau, Jun 6, 2019
    #2
  3. Windows and CMD- renaming a file in CMD

    Steps I've done

    Here what happens


    • turn on PC

    • start windows

    • get blue screen ( message NTFS file)

    • it reboots returns to diagnosing PC

    • Diagnose and repair fails

    • I move to advance options

    • will not reset windows , I click on CMD

    things I've tried
    commands:

    reagentc /disable

    reagentc /enable

    *************************FAILED
    not recognized
    **********************************

    Please advise


     
    RandallBrock, Jun 6, 2019
    #3
  4. I need to excute a .SQL file from CMD line

    SQL Server Files

    Hi RalphHead,

    Sorry for the inconvenience caused to you and thank you for your valuable question please, Before attempting reload of Windows 10 I would suggest you to please see the below mentioned article and see if it helps, If the issue persists kindly let me know,waiting
    for your kind reply please.

    https://docs.microsoft.com/en-us/sql/relational...

    Please let me know, if that helps and feel free to ask back any question.

    Kind Regards:

    Yasir
     
    MALIK YASIRNAWAZ, Jun 6, 2019
    #4
Thema:

I need to excute a .SQL file from CMD line

Loading...
  1. I need to excute a .SQL file from CMD line - Similar Threads - need excute SQL

  2. wuauclt.exe CMD command lines

    in Windows 10 Gaming
    wuauclt.exe CMD command lines: 04/22/2022 - 10:59Hello,I am studying in a computer science school, and I work in a telecommunication company sandwich course. I have a project to do to validate my year.I have a Windows server 2012 R2.My goal is to update my computer with command lines.I have the constraint...
  3. wuauclt.exe CMD command lines

    in Windows 10 Software and Apps
    wuauclt.exe CMD command lines: 04/22/2022 - 10:59Hello,I am studying in a computer science school, and I work in a telecommunication company sandwich course. I have a project to do to validate my year.I have a Windows server 2012 R2.My goal is to update my computer with command lines.I have the constraint...
  4. CMD line for unninstal KB

    in Windows 10 Installation and Upgrade
    CMD line for unninstal KB: Hi,how can be possible and in which way create command line for unninstal e.g. KB update "Update for Microsoft Office 2016 KB5002160 64-Bit-Edition", please?Thank you....
  5. CMD line for unninstal KB

    in Windows 10 Gaming
    CMD line for unninstal KB: Hi,how can be possible and in which way create command line for unninstal e.g. KB update "Update for Microsoft Office 2016 KB5002160 64-Bit-Edition", please?Thank you....
  6. CMD line for unninstal KB

    in Windows 10 Software and Apps
    CMD line for unninstal KB: Hi,how can be possible and in which way create command line for unninstal e.g. KB update "Update for Microsoft Office 2016 KB5002160 64-Bit-Edition", please?Thank you....
  7. Can I remove a cmd line entered by mistake

    in Windows 10 Installation and Upgrade
    Can I remove a cmd line entered by mistake: I have entered this cmd, thinking it was necessary "%ProgramFiles%\Oracle\VirtualBox\VBoxManage.exe" setextradata "windows98" VBoxInternal/USB/HidMouse/0/Config/CoordShift 0 but I didn't need to and it is preventing me using the program. Is there a way of undoing or...
  8. Need some Help with CMD and .bat files

    in Windows 10 Ask Insider
    Need some Help with CMD and .bat files: I have .bat file thats in a folder in my desktop (location). When i open the bat file i need it to run in the folder that's it's located (in the folder thats on my desktop) However, when i run the bat file it runs at the default location. So isn't there anyway I can change...
  9. I am getting a cmd line error

    in Windows 10 Support
    I am getting a cmd line error: I am getting a cmd line error on a command line that I found online to stop and disable "wuauserv" so I am not bothered by Win up dates. It is not a permanent fix and I have to re do it once in a while. The update message is bellow: --------------------------- Important...
  10. Needed: CMD to extract files from 'Winre.wim' using DISM?

    in Windows 10 Installation and Upgrade
    Needed: CMD to extract files from 'Winre.wim' using DISM?: Sorry to ask such a basic question. I want to extract *.* from Winre.wim into CWD. I've used DISM to extract .NET3.5 into a running system, but I don't want to change the system, so I'm unsure what the DISM arguments are. Also, I have some DISM documentation from...