Results 1 to 2 of 2

Thread: how not to display header info

  1. #1
    Join Date
    Oct 2005
    Posts
    7

    Question how not to display header info

    Hello!

    I am writing a script which creates another script of T-SQL commands based on the current security of a DB server.

    So far, I was not able to turn off the header (column or filed names) of the result set of select statements.

    Whenever I issue a select statement to query something or produce commands I have the header info like:

    isaliased issqlrole isapprole
    ------ ------ ------------------
    ...

    Is it possible to turn it off as I do not need it in the output file (future script file)?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can turn it off. In Query analyzer go to Tools - Options - Results tab and uncheck print column headers.

    If you are using OSQL or BCP, there is a switch for that too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •