How to spool sql output to a file?

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  January 29, 2009 at 11:55 am

  #77244

  Is there anyway I can spool or write the output of sql statements to a file? I would like to spool the output of the following commands:

  --Check concurrent sessions in DB.

  select count(*) from sessions where datediff(minute, timestamp, getdate())< 10

  --How many items are locking.

  sp_lock

  --Who is causing the locking. Use the spid from the sp_lock results

  --and link to the spid from the sp_who results.

  sp_who

  We have SQL Server 2000.

  Thanks in advance, Kevin

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 29, 2009 at 12:06 pm

  #934972

  you can run this from SQLCMD (command line) and that would do it.

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  January 29, 2009 at 1:42 pm

  #935044

  Are you talking about using isql or osql?

  Thanks, Kevin