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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Results Pane in Analyzer

Author  Topic 

cardgunner

326 Posts

Posted - 2009-02-17 : 14:54:26
Is there a setting to where I can eliminate the
' ------------------------------ '
That is above each column has well as

the number of results showing at the bottom such as

(56 row(s)affected)

CardGunner

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-17 : 15:10:33
You get rid of the rowcount via SET NOCOUNT ON. If you want to format the output, I'd suggest using bcp or SSIS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

cardgunner

326 Posts

Posted - 2009-02-17 : 15:28:04
Thanks Tara.

Inserted the nocount and that worked great.

I looked up bcp. Not knowing what it is. It's too much for what I want to do. I was hoping for something simple like unchecking something or writing down a simple code like set nocount on.

I did not find anything on what SSIS means. I'm assuming that that too will be more complicated then need be.

Your help has always been right on and I'm sure that bci or SSIS would work. Thank you for your time.

CardGunner
Go to Top of Page

cardgunner

326 Posts

Posted - 2009-02-17 : 15:35:07
Sql Server Intergration Services

http://www.accelebrate.com/sql_training/ssis_tutorial.htm

This may be good to know however not for this project.

Again thanks Tara.

CardGunner
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-17 : 15:39:43
You can not get rid of "--------" in the text result set.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -