Changes made in Query Analizer don't show in Enterprise Manager

If I run e.g. a table-creating sql statement then the changes won't show in
Enterprise Manager no matter how many times I refresh. They only show if I
restart Enterprise Manager.
1. Is there a way to get EM to reflect the changes made in Query Analizer?
2. I couldn't seem to find a way to run arbitrary sql statements in
Enterprise Manager (There are SQL panes when operating with tables or views,
but which is fine for running a select into, for instance?). Have I missed
something or should I use the Query Analizer?
Hi
1. EM normally does. Make sure you are running SQL 2000 sp3a on both the
server and on the machine you have EM installed.
2. EM is intended for a DBA to manager servers. QA is the tool to use to run
queries and other SQL statements.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Agoston Bejo" <gusz1@.freemail.hu> wrote in message
news:#Vv6eMvrEHA.2136@.TK2MSFTNGP14.phx.gbl...
> If I run e.g. a table-creating sql statement then the changes won't show
in
> Enterprise Manager no matter how many times I refresh. They only show if I
> restart Enterprise Manager.
> 1. Is there a way to get EM to reflect the changes made in Query Analizer?
> 2. I couldn't seem to find a way to run arbitrary sql statements in
> Enterprise Manager (There are SQL panes when operating with tables or
views,
> but which is fine for running a select into, for instance?). Have I missed
> something or should I use the Query Analizer?
>
>
|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:

>1. Is there a way to get EM to reflect the changes made in Query Analizer?
Hi Agoston,
Right-click any icon in the right pane. Most have an option "Refresh".
Note that this option will only refresh the direct sublist of that
specific icon; there is no "full refresh" option (as far as I know).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:

>no matter how many times I refresh
Hi Agoston,
It seems I missed this part of your message when I sent my previous
message. Please disregard it.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

Changes made in Query Analizer don't show in Enterprise Manager

If I run e.g. a table-creating sql statement then the changes won't show in
Enterprise Manager no matter how many times I refresh. They only show if I
restart Enterprise Manager.
1. Is there a way to get EM to reflect the changes made in Query Analizer?
2. I couldn't seem to find a way to run arbitrary sql statements in
Enterprise Manager (There are SQL panes when operating with tables or views,
but which is fine for running a select into, for instance?). Have I missed
something or should I use the Query Analizer?
Hi
1. EM normally does. Make sure you are running SQL 2000 sp3a on both the
server and on the machine you have EM installed.
2. EM is intended for a DBA to manager servers. QA is the tool to use to run
queries and other SQL statements.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Agoston Bejo" <gusz1@.freemail.hu> wrote in message
news:#Vv6eMvrEHA.2136@.TK2MSFTNGP14.phx.gbl...
> If I run e.g. a table-creating sql statement then the changes won't show
in
> Enterprise Manager no matter how many times I refresh. They only show if I
> restart Enterprise Manager.
> 1. Is there a way to get EM to reflect the changes made in Query Analizer?
> 2. I couldn't seem to find a way to run arbitrary sql statements in
> Enterprise Manager (There are SQL panes when operating with tables or
views,
> but which is fine for running a select into, for instance?). Have I missed
> something or should I use the Query Analizer?
>
>
|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:

>1. Is there a way to get EM to reflect the changes made in Query Analizer?
Hi Agoston,
Right-click any icon in the right pane. Most have an option "Refresh".
Note that this option will only refresh the direct sublist of that
specific icon; there is no "full refresh" option (as far as I know).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:

>no matter how many times I refresh
Hi Agoston,
It seems I missed this part of your message when I sent my previous
message. Please disregard it.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

Changes made in Query Analizer don't show in Enterprise Manager

If I run e.g. a table-creating sql statement then the changes won't show in
Enterprise Manager no matter how many times I refresh. They only show if I
restart Enterprise Manager.
1. Is there a way to get EM to reflect the changes made in Query Analizer?
2. I couldn't seem to find a way to run arbitrary sql statements in
Enterprise Manager (There are SQL panes when operating with tables or views,
but which is fine for running a select into, for instance?). Have I missed
something or should I use the Query Analizer?Hi
1. EM normally does. Make sure you are running SQL 2000 sp3a on both the
server and on the machine you have EM installed.
2. EM is intended for a DBA to manager servers. QA is the tool to use to run
queries and other SQL statements.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Agoston Bejo" <gusz1@.freemail.hu> wrote in message
news:#Vv6eMvrEHA.2136@.TK2MSFTNGP14.phx.gbl...
> If I run e.g. a table-creating sql statement then the changes won't show
in
> Enterprise Manager no matter how many times I refresh. They only show if I
> restart Enterprise Manager.
> 1. Is there a way to get EM to reflect the changes made in Query Analizer?
> 2. I couldn't seem to find a way to run arbitrary sql statements in
> Enterprise Manager (There are SQL panes when operating with tables or
views,
> but which is fine for running a select into, for instance?). Have I missed
> something or should I use the Query Analizer?
>
>|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:
>1. Is there a way to get EM to reflect the changes made in Query Analizer?
Hi Agoston,
Right-click any icon in the right pane. Most have an option "Refresh".
Note that this option will only refresh the direct sublist of that
specific icon; there is no "full refresh" option (as far as I know).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:
>no matter how many times I refresh
Hi Agoston,
It seems I missed this part of your message when I sent my previous
message. Please disregard it.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Changes made in Query Analizer don't show in Enterprise Manager

If I run e.g. a table-creating sql statement then the changes won't show in
Enterprise Manager no matter how many times I refresh. They only show if I
restart Enterprise Manager.
1. Is there a way to get EM to reflect the changes made in Query Analizer?
2. I couldn't seem to find a way to run arbitrary sql statements in
Enterprise Manager (There are SQL panes when operating with tables or views,
but which is fine for running a select into, for instance?). Have I missed
something or should I use the Query Analizer?Hi
1. EM normally does. Make sure you are running SQL 2000 sp3a on both the
server and on the machine you have EM installed.
2. EM is intended for a DBA to manager servers. QA is the tool to use to run
queries and other SQL statements.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Agoston Bejo" <gusz1@.freemail.hu> wrote in message
news:#Vv6eMvrEHA.2136@.TK2MSFTNGP14.phx.gbl...
> If I run e.g. a table-creating sql statement then the changes won't show
in
> Enterprise Manager no matter how many times I refresh. They only show if I
> restart Enterprise Manager.
> 1. Is there a way to get EM to reflect the changes made in Query Analizer?
> 2. I couldn't seem to find a way to run arbitrary sql statements in
> Enterprise Manager (There are SQL panes when operating with tables or
views,
> but which is fine for running a select into, for instance?). Have I missed
> something or should I use the Query Analizer?
>
>|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:

>1. Is there a way to get EM to reflect the changes made in Query Analizer?
Hi Agoston,
Right-click any icon in the right pane. Most have an option "Refresh".
Note that this option will only refresh the direct sublist of that
specific icon; there is no "full refresh" option (as far as I know).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||On Sun, 10 Oct 2004 20:00:39 +0200, Agoston Bejo wrote:

>no matter how many times I refresh
Hi Agoston,
It seems I missed this part of your message when I sent my previous
message. Please disregard it.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Change owner of Maintenance Plan

I know that you can change the owner of a job. How can I change the owner of
a maintenance plan?
As a follow up question, does it really matter from a technical or
functional perspective who owns the maintenance plan. The job owner can be
different and has technical implications per its owner. One of the reasons I
want to change the owner, is because the person that created these plans is
not longer in the role of managing databases. I would like to change the
owner to a generic account like 'sa' or to an appropriate active dba
individual.
Thanks
TimHi Tim,
A maintained plan is executed by means of SQL Server Job, so if you
change the owner in the Job it will reflect accordingly. An owner is
important because SQL Server Job needs proper authorization to expect steps
layer out in the plan/job.
Mohit K. Gupta
MCTS: SQL Server 2005
"timw86" wrote:
> I know that you can change the owner of a job. How can I change the owner of
> a maintenance plan?
> As a follow up question, does it really matter from a technical or
> functional perspective who owns the maintenance plan. The job owner can be
> different and has technical implications per its owner. One of the reasons I
> want to change the owner, is because the person that created these plans is
> not longer in the role of managing databases. I would like to change the
> owner to a generic account like 'sa' or to an appropriate active dba
> individual.
> Thanks
> Tim|||I don't believe you can - not in a support manner anyway.
And no...It doesn't matter. It's the job owner that matters.
-Sue
On Wed, 20 Jun 2007 06:11:01 -0700, timw86
<timw86@.discussions.microsoft.com> wrote:
>I know that you can change the owner of a job. How can I change the owner of
>a maintenance plan?
>As a follow up question, does it really matter from a technical or
>functional perspective who owns the maintenance plan. The job owner can be
>different and has technical implications per its owner. One of the reasons I
>want to change the owner, is because the person that created these plans is
>not longer in the role of managing databases. I would like to change the
>owner to a generic account like 'sa' or to an appropriate active dba
>individual.
>Thanks
>Tim

Change owner of Maintenance Plan

I know that you can change the owner of a job. How can I change the owner of
a maintenance plan?
As a follow up question, does it really matter from a technical or
functional perspective who owns the maintenance plan. The job owner can be
different and has technical implications per its owner. One of the reasons I
want to change the owner, is because the person that created these plans is
not longer in the role of managing databases. I would like to change the
owner to a generic account like 'sa' or to an appropriate active dba
individual.
Thanks
Tim
Hi Tim,
A maintained plan is executed by means of SQL Server Job, so if you
change the owner in the Job it will reflect accordingly. An owner is
important because SQL Server Job needs proper authorization to expect steps
layer out in the plan/job.
Mohit K. Gupta
MCTS: SQL Server 2005
"timw86" wrote:

> I know that you can change the owner of a job. How can I change the owner of
> a maintenance plan?
> As a follow up question, does it really matter from a technical or
> functional perspective who owns the maintenance plan. The job owner can be
> different and has technical implications per its owner. One of the reasons I
> want to change the owner, is because the person that created these plans is
> not longer in the role of managing databases. I would like to change the
> owner to a generic account like 'sa' or to an appropriate active dba
> individual.
> Thanks
> Tim
|||I don't believe you can - not in a support manner anyway.
And no...It doesn't matter. It's the job owner that matters.
-Sue
On Wed, 20 Jun 2007 06:11:01 -0700, timw86
<timw86@.discussions.microsoft.com> wrote:

>I know that you can change the owner of a job. How can I change the owner of
>a maintenance plan?
>As a follow up question, does it really matter from a technical or
>functional perspective who owns the maintenance plan. The job owner can be
>different and has technical implications per its owner. One of the reasons I
>want to change the owner, is because the person that created these plans is
>not longer in the role of managing databases. I would like to change the
>owner to a generic account like 'sa' or to an appropriate active dba
>individual.
>Thanks
>Tim

Change owner of Maintenance Plan

I know that you can change the owner of a job. How can I change the owner o
f
a maintenance plan?
As a follow up question, does it really matter from a technical or
functional perspective who owns the maintenance plan. The job owner can be
different and has technical implications per its owner. One of the reasons
I
want to change the owner, is because the person that created these plans is
not longer in the role of managing databases. I would like to change the
owner to a generic account like 'sa' or to an appropriate active dba
individual.
Thanks
TimHi Tim,
A maintained plan is executed by means of SQL Server Job, so if you
change the owner in the Job it will reflect accordingly. An owner is
important because SQL Server Job needs proper authorization to expect steps
layer out in the plan/job.
Mohit K. Gupta
MCTS: SQL Server 2005
"timw86" wrote:

> I know that you can change the owner of a job. How can I change the owner
of
> a maintenance plan?
> As a follow up question, does it really matter from a technical or
> functional perspective who owns the maintenance plan. The job owner can b
e
> different and has technical implications per its owner. One of the reason
s I
> want to change the owner, is because the person that created these plans i
s
> not longer in the role of managing databases. I would like to change the
> owner to a generic account like 'sa' or to an appropriate active dba
> individual.
> Thanks
> Tim|||I don't believe you can - not in a support manner anyway.
And no...It doesn't matter. It's the job owner that matters.
-Sue
On Wed, 20 Jun 2007 06:11:01 -0700, timw86
<timw86@.discussions.microsoft.com> wrote:

>I know that you can change the owner of a job. How can I change the owner
of
>a maintenance plan?
>As a follow up question, does it really matter from a technical or
>functional perspective who owns the maintenance plan. The job owner can be
>different and has technical implications per its owner. One of the reasons
I
>want to change the owner, is because the person that created these plans is
>not longer in the role of managing databases. I would like to change the
>owner to a generic account like 'sa' or to an appropriate active dba
>individual.
>Thanks
>Tim