MS SQL Server New Users - Security Access in Query Analyzer but not Enterprise Mgr

Author

Security Access in Query Analyzer but not Enterprise Mgr

James_101

2005-12-04, 8:23 pm

I can run stored procedures in SQL Query Analyzer but not in Enterprise Mgr.
One of the stored procedures runs a SELECT query that sorts a table displayed
in a view. Another procedure deletes rows in a table.

I can run all of these in SQL Query Analyzer. In Enterprise Mgr, however, I
can select a store procedure and right-click it but no "run" or "execute"
option appears.

I am the administrator of the desktop runing SQL Server 2000 developer
edition. The OS is Win XP Pro SP2.

When I open Query Analyzer, I get a dialog box entitleded "Connect to SQL
Server". When I open Enterprise Mgr, I get no dialog. In Enterprise Mgr, if
I select a stored procedure, right-click and select "All Tasks | Manage
Permissions", only one user appears. It is "public" and it has no
permissions granted. I'm reluctant to grant them, however, because I believe
that, as administrator, I should not need to seek permissions as a public
user.

Any next steps for me to try?

Thanks.

Jim

Sue Hoegemeier

2005-12-06, 3:23 am

You can't execute stored procedures from Enterprise Manager
in that manner. There is no run or execute option if you
select a stored procedure in Enterprise Manager. You should
use Query Analyzer for this anyway.
Enterprise Manager is automatically logging you into SQL
Server based upon whatever you set up when you registered
the server. To see how you have it set up, right click on
the SQL Server in Enterprise Manager and select Edit SQL
Server registration properties.

-Sue

On Sun, 4 Dec 2005 17:43:13 -0800, James_101
< James101@discussions
.microsoft.com> wrote:

>I can run stored procedures in SQL Query Analyzer but not in Enterprise Mgr.
>One of the stored procedures runs a SELECT query that sorts a table displayed
>in a view. Another procedure deletes rows in a table.
>
>I can run all of these in SQL Query Analyzer. In Enterprise Mgr, however, I
>can select a store procedure and right-click it but no "run" or "execute"
>option appears.
>
>I am the administrator of the desktop runing SQL Server 2000 developer
>edition. The OS is Win XP Pro SP2.
>
>When I open Query Analyzer, I get a dialog box entitleded "Connect to SQL
>Server". When I open Enterprise Mgr, I get no dialog. In Enterprise Mgr, if
>I select a stored procedure, right-click and select "All Tasks | Manage
>Permissions", only one user appears. It is "public" and it has no
>permissions granted. I'm reluctant to grant them, however, because I believe
>that, as administrator, I should not need to seek permissions as a public
>user.
>
>Any next steps for me to try?
>
>Thanks.
>
>Jim

James_101

2005-12-06, 11:23 am

Thanks Sue.

I am a developer. I design databases for customers so I only need a few
administrative tools. I just completed my first database on SQL Server 2000.

It sounds like I can use Enterprise Manager to create databases, create
tables and enter data in the tables. I can use Query Analyzer to write
queries, run them, view results and make modifications to queries (including
views and stored procedures).

Please let me know if I'm missing something.

Jim

"Sue Hoegemeier" wrote:

> You can't execute stored procedures from Enterprise Manager
> in that manner. There is no run or execute option if you
> select a stored procedure in Enterprise Manager. You should
> use Query Analyzer for this anyway.
> Enterprise Manager is automatically logging you into SQL
> Server based upon whatever you set up when you registered
> the server. To see how you have it set up, right click on
> the SQL Server in Enterprise Manager and select Edit SQL
> Server registration properties.
>
> -Sue

Sue Hoegemeier

2005-12-06, 8:25 pm

Hi Jim,
You can use Query Analyzer to do almost everything. For what
you need and designing databases, Query Analyzer should do
whatever you need.
You can still use Enterprise Manager to create objects, set
database settings and enter data - although you can run into
some odd issues when using Enterprise Manager for data
entry. Enterprise Manager can sometimes do some odd things
behind the scenes when changing objects that people aren't
always aware of - and that can sometimes cause some
problems.
In your case, depending more on Query Analyzer will give you
a better understanding of what is really being executed, you
can save the scripts you run in Query Analyzer and have a
script history to keep track of what you've done for
troubleshooting, tracking changes and just a general
reference of how you did something before for another
customer.

Hope that helps -

-Sue

On Tue, 6 Dec 2005 08:26:08 -0800, James_101
< James101@discussions
.microsoft.com> wrote:
[color=darkred]
>Thanks Sue.
>
>I am a developer. I design databases for customers so I only need a few
>administrative tools. I just completed my first database on SQL Server 2000.
>
>It sounds like I can use Enterprise Manager to create databases, create
>tables and enter data in the tables. I can use Query Analyzer to write
>queries, run them, view results and make modifications to queries (including
>views and stored procedures).
>
>Please let me know if I'm missing something.
>
>Jim
>
>
>"Sue Hoegemeier" wrote:
>

Sponsored Links