Disable EM ?

Is is possible to disable Enterprise Manager and still
retain query analyzer functionality?
If yes then how?
else
Thanks
TVO
"TVO" <anonymous@.discussions.microsoft.com> wrote in message
news:002801c46dc0$53377bb0$a301280a@.phx.gbl...
> Is is possible to disable Enterprise Manager and still
> retain query analyzer functionality?
You can use security to effectively prevent a user from mis-using Enterprise
Manager.

> If yes then how?
The most secure solution would only allow read or execute permissions on
designated views, or stored procedures.
Steve
|||I have permissions applied through AD Groups and SELECT
only rights are applied. However the locking semantics
of EM are different than that of QA. I want to disable
their ablilty to launch or use EM and yet still allow
them to query via written code using QA. Any ideas?
Thanks

>--Original Message--
>"TVO" <anonymous@.discussions.microsoft.com> wrote in
message
>news:002801c46dc0$53377bb0$a301280a@.phx.gbl...
>You can use security to effectively prevent a user from
mis-using Enterprise
>Manager.
>
>The most secure solution would only allow read or
execute permissions on
>designated views, or stored procedures.
>Steve
>
>.
>
|||Change the security settings for ...\Microsoft SQL Server\80\Tools\BinnSQL
Server Enterprise Manager.MSC
or delete it.
"TVO" <anonymous@.discussions.microsoft.com> wrote in message
news:00a001c46dc8$654f2930$a301280a@.phx.gbl...[vbcol=seagreen]
> I have permissions applied through AD Groups and SELECT
> only rights are applied. However the locking semantics
> of EM are different than that of QA. I want to disable
> their ablilty to launch or use EM and yet still allow
> them to query via written code using QA. Any ideas?
> Thanks
>
> message
> mis-using Enterprise
> execute permissions on
|||Of course that would not help if the user(s) have installed the SQL Server
tools on their devices. Security is the best way to go here, unless you want
to write a stored procedure that monitors sysprocesses, and terminate any
connection (via EM) that is not appropriate. Seems like a lot of work to
me...
Steve
"news.microsoft.com" <deo.is@.unknown.com> wrote in message
news:%230mn1NebEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Change the security settings for ...\Microsoft SQL Server\80\Tools\BinnSQL
> Server Enterprise Manager.MSC
> or delete it.
> "TVO" <anonymous@.discussions.microsoft.com> wrote in message
> news:00a001c46dc8$654f2930$a301280a@.phx.gbl...
>