Remove headers in SQL Query analyzer when making a query

Hi Friends...
I need to know how can i remove the colum headers when making a query with
sql query analizer, the query is:
select succeeded from sysdbmaintplan_history
i need that the field header 'succeeded' dissapear!!!
thanks alluse empty space as a column name
select succeeded as ' ' from sysdbmaintplan_history
--
Programmer
"Tinchos" wrote:

> Hi Friends...
> I need to know how can i remove the colum headers when making a query with
> sql query analizer, the query is:
> select succeeded from sysdbmaintplan_history
> i need that the field header 'succeeded' dissapear!!!
> thanks all|||Click on Tools/Options menu. Goto results tab. You will see the option for
column headers - just uncheck it.
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:0FD3406C-E8B0-4CE6-A9DE-9E7109213380@.microsoft.com...
> Hi Friends...
> I need to know how can i remove the colum headers when making a query with
> sql query analizer, the query is:
> select succeeded from sysdbmaintplan_history
> i need that the field header 'succeeded' dissapear!!!
> thanks all

Remotely connecting sql Server

Hi,
I'm Connecting to server on the internet. When I connect with the SQL Query analyzer it works fine.
but when I open the Enterprise Manager & Click on the database then It loads all the databases from the server. & it takes a lot of time. What I want that to load only specific databases or any other method by which I can improve its performance.
I hope you get that.
thanks in advance,
Das
I don't think you can change that behavior, but you can certainly increase
the timeout value for Enterprise Manager. For more informaiton, see:
http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Das" <anonymous@.discussions.microsoft.com> wrote in message
news:A50CF25F-A767-4BA9-BE5E-5E046346F362@.microsoft.com...
Hi,
I'm Connecting to server on the internet. When I connect with the SQL Query
analyzer it works fine.
but when I open the Enterprise Manager & Click on the database then It
loads all the databases from the server. & it takes a lot of time. What I
want that to load only specific databases or any other method by which I can
improve its performance.
I hope you get that.
thanks in advance,
Das

Remote query error

Hello, when I try a remote query in Query Analyzer from
serverA I am getting an error: Server 'serverB' is not
configured for DATA ACCESS.
ServerB is not defined as a Linked Server as it is already
defined as a remote server (it participates in
replication). I can run queries on it directly,
applications can access it, etc. Concurrent access is set
at unlimited.
I am using SQL 7
Any help is greatly appreciated.
RicSee sp_serveroption in BOL.
>--Original Message--
>Hello, when I try a remote query in Query Analyzer from
>serverA I am getting an error: Server 'serverB' is not
>configured for DATA ACCESS.
>ServerB is not defined as a Linked Server as it is
already
>defined as a remote server (it participates in
>replication). I can run queries on it directly,
>applications can access it, etc. Concurrent access is
set
>at unlimited.
>I am using SQL 7
>Any help is greatly appreciated.
>Ric
>.
>|||I put in the the sp_serveroption and gave it data access
but now i get this...Im using a remote server
connection...what am I doing wrong?
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.|||Many thanks Chris, that worked perfectly.
Ric
>--Original Message--
>See sp_serveroption in BOL.
>>--Original Message--
>>Hello, when I try a remote query in Query Analyzer from
>>serverA I am getting an error: Server 'serverB' is not
>>configured for DATA ACCESS.
>>ServerB is not defined as a Linked Server as it is
>already
>>defined as a remote server (it participates in
>>replication). I can run queries on it directly,
>>applications can access it, etc. Concurrent access is
>set
>>at unlimited.
>>I am using SQL 7
>>Any help is greatly appreciated.
>>Ric
>>.
>.
>|||I did this and gave it data access but now I get the error
that the login for user null failed...not associated with
a trusted SQL Server connection

remote debug problem

I am trying to do remote debugging and doesn't seem to be working....I brin
g up query analyzer, select the datbase, select the sp, right click debug, e
nter a value and ok...when I do this it doesn't pass/break...it completes
the query and grays out the
buttons at the top....
steps I have done:got click happy
things I have tried...
1. i put in a local admin account under properties/security after you right
click on the sql instance
2. run dcomcnfg
a. edited the default access permission - gave everyone allow access permiss
ion
b. under applications tab - I went to properties ont he sqldbreg edited the
use custom access permission under security to allow everyone permission
c. on that same com(sqldbreg) - I changed the identity to use a the local us
er I setup with admin rights
what else can I try?|||got click happy
things I have tried...
1. i put in a local admin account under properties/security after you right
click on the sql instance
2. run dcomcnfg
a. edited the default access permission - gave everyone allow access permiss
ion
b. under applications tab - I went to properties ont he sqldbreg edited the
use custom access permission under security to allow everyone permission
c. on that same com(sqldbreg) - I changed the identity to use a the local us
er I setup with admin rights
what else can I try?|||got click happy
things I have tried...
1. i put in a local admin account under properties/security after you right
click on the sql instance
2. run dcomcnfg
a. edited the default access permission - gave everyone allow access permiss
ion
b. under applications tab - I went to properties ont he sqldbreg edited the
use custom access permission under security to allow everyone permission
c. on that same com(sqldbreg) - I changed the identity to use a the local us
er I setup with admin rights
what else can I try?|||Make sure the version of client tools is the same as the server. In Query
Analyzer look in Help/About.
That fixed the problem for me.
"Jamie Elliott" wrote:

> got click happy
> things I have tried...
> 1. i put in a local admin account under properties/security after you righ
t click on the sql instance
> 2. run dcomcnfg
> a. edited the default access permission - gave everyone allow acces
s permission
> b. under applications tab - I went to properties ont he sqldbreg ed
ited the use custom access permission under security to allow everyone permi
ssion
> c. on that same com(sqldbreg) - I changed the identity to use a the
local user I setup with admin rights
> what else can I try?

remote debug problem

I am trying to do remote debugging and doesn't seem to be working....I bring up query analyzer, select the datbase, select the sp, right click debug, enter a value and ok...when I do this it doesn't pass/break...it completes the query and grays out the
buttons at the top....
steps I have done:
got click happy
things I have tried...
1. i put in a local admin account under properties/security after you right click on the sql instance
2. run dcomcnfg
a. edited the default access permission - gave everyone allow access permission
b. under applications tab - I went to properties ont he sqldbreg edited the use custom access permission under security to allow everyone permission
c. on that same com(sqldbreg) - I changed the identity to use a the local user I setup with admin rights
what else can I try?
|||got click happy
things I have tried...
1. i put in a local admin account under properties/security after you right click on the sql instance
2. run dcomcnfg
a. edited the default access permission - gave everyone allow access permission
b. under applications tab - I went to properties ont he sqldbreg edited the use custom access permission under security to allow everyone permission
c. on that same com(sqldbreg) - I changed the identity to use a the local user I setup with admin rights
what else can I try?
|||got click happy
things I have tried...
1. i put in a local admin account under properties/security after you right click on the sql instance
2. run dcomcnfg
a. edited the default access permission - gave everyone allow access permission
b. under applications tab - I went to properties ont he sqldbreg edited the use custom access permission under security to allow everyone permission
c. on that same com(sqldbreg) - I changed the identity to use a the local user I setup with admin rights
what else can I try?
|||Make sure the version of client tools is the same as the server. In Query
Analyzer look in Help/About.
That fixed the problem for me.
"Jamie Elliott" wrote:

> got click happy
> things I have tried...
> 1. i put in a local admin account under properties/security after you right click on the sql instance
> 2. run dcomcnfg
> a. edited the default access permission - gave everyone allow access permission
> b. under applications tab - I went to properties ont he sqldbreg edited the use custom access permission under security to allow everyone permission
> c. on that same com(sqldbreg) - I changed the identity to use a the local user I setup with admin rights
> what else can I try?