How to run sql script file from Command prompt
By Junaid A   Posted on February-03-2019
How to run sql script file from Command prompt
if we run big file of sql script in query window it gives error of time out or short of memory.
Solution
Run the script file
- a) Open a command prompt window.
- b) In the Command Prompt window, type: sqlcmd -S myServer\instanceName -i C:\myScript.sql.
- c) Press ENTER.
Open command prompte
copy below lines and job done
sqlcmd -S WIN-RK94DR962EH -i C:\nesdb2019.sql
By asifjans   03-Feb-2019
Views 1197
Share This with your friend by choosing any social account
Comments
Your Comments
You may also read following recent articles
|
Top Software Testing Trends in 2023!
01-Feb-2023 52 |
![]() |
How To Make Money on YouTube in 2023!
31-Jan-2023 33 |
![]() |
The 6 Best Entry-Level Sales Jobs To Start Your Career!
31-Jan-2023 19 |
![]() |
Affiliate Marketing Program for Beginners!
31-Jan-2023 5 |
|
Top 20 Best Test Management Tools New 2023 Rankings!
31-Jan-2023 60 |
![]() |
23 Things To Do After High School!
30-Jan-2023 26 |
![]() |
Google, Meta, Amazon: Who Was Impacted by 2023 Tech Layoffs!
30-Jan-2023 19 |
![]() |
Can Earth change its direction rotation?!
30-Jan-2023 22 |
![]() |
How to Mine Crypto on Android?!
30-Jan-2023 30 |
![]() |
How to Use Competitive Intelligence to Grow Your Business?!
30-Jan-2023 27 |
![]() |
How do I get Google traffic data?!
28-Jan-2023 13 |
![]() |
How to get free traffic from Quora?!
28-Jan-2023 25 |