Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pszivos
Starting Member
10 Posts |
 Posted - 2006-02-23 : 03:29:50
|
| 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)? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-23 : 05:14:20
|
| Whereis your output to/from, i'm guessing this is from QA..Go to Tools -> Options, then navigate to the Results Tab, in there untick Print column headers..If you are intending to run this from DTS, you can specify not to print the headers in your output file.. |
 |
|
|
|
|
|
turning off the header