1

I am using SqlCmd for SQL Server 2008. I want to save all the commands that I have typed in SqlCmd into a text file or script file. Is it possible? If so how to do so?

aspiring
  • 1,557
  • 2
  • 20
  • 43
  • It's not too clear what you mean. You want an automated log of what you've typed into a sqlcmd session (not necessarily the results)? – JustinStolle May 25 '13 at 01:41
  • @JustinStolle sorry for getting back late. Yes an automated log like what we use in Oracle, `pool` command. And also how to use a pre-written script to create/insert tables? – aspiring Sep 15 '13 at 05:49
  • Do you mean the [`spool`](http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12043.htm) command? The question about "a pre-written script" should be written up as a new question if you can't find one that already answers that for you. – JustinStolle Sep 15 '13 at 15:43
  • Yup Spool... sorry s missing. – aspiring Sep 16 '13 at 15:23

0 Answers0