From what directory? Note that if you do not specify a file extension on the spool file name like. Show 2 more comments. John D John D 2, 15 15 silver badges 28 28 bronze badges. I was gonna add the set pages 0 , set trimspool on , etc. But then the question changed and I had to chase down something else! Good suggestions though. Shine Shine 3 3 silver badges 16 16 bronze badges. Mohamed Dernoun Mohamed Dernoun 3 3 silver badges 11 11 bronze badges.
Having the same chore on windows 10, and windows server Dudi Boy Dudi Boy 2, 1 1 gold badge 11 11 silver badges 23 23 bronze badges. It's better to spool inside the. Redirecting standard output to file may result in unwanted SQL feedback output in your file. Also, you could just quit or exit inside the. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.
There are many database diagramming tools that are not only incredibly useful but also free. After launching and connecting to SQL Server Management Studio, create a new login and select the database that is connected to Chartio. Download our free cloud data management ebook and learn how to manage your data stack and set up processes to get the most our of your data in your organization.
Data Tutorials. Learn the importance of a great data stack. Asked 5 years, 5 months ago. Active 3 years, 1 month ago. Viewed 22k times. Improve this question. Rui F Ribeiro Srikanth Yadake Srikanth Yadake 2 2 gold badges 4 4 silver badges 11 11 bronze badges.
Add a comment. Active Oldest Votes. Improve this answer. You may do the same inside the script. SrikanthYadake Does it not work in any particular way? Do you get an error message? What is the symptom?
0コメント