Does anyone know why a sp would disappear after loging out & in of the Enterprise Manager in SQL Server 2000? When I execute the sp from the Query Analizer it seems to loop but it is still there after I cancel it. If I run just the code in the Query Anaylizer, it runs fine. Due that it involves tables in 2 sql servers, to create the sp I run :
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_DEFAULTS ON
set XACT_ABORT on
GO
Create procedure xyz as ...
The error reported in the log is :
Error: 15457, Severity: 0, State: 1
It's weird how after I close EM and go back again, the sp is not in the sp list anymore.
Any ideas? PLS HELP!The SPs displayed in EM are cached. If the SP is dropped or created e.g. from a script then the current state will not be displayed in EM. If you refresh the list by right clicking on Stored Procedures then you will get the correct state at that moment - this has the same effect as logging out and logging in.
If an SP is dropped or changes ID the EM will give an error if you try to display it.
Try select name from sysobjects where xtype = 'P' to get the list.
2012年3月8日星期四
2012年3月7日星期三
Disappearing Linked Server Stored Procedures
When I create a stored procedure like the one below and save it,
everything seems fine. But when I close Enterprise Manager and
re-open it, the stored procedure is gone.
everything seems fine. But when I close Enterprise Manager and
re-open it, the stored procedure is gone.
Any ideas?
SET ANSI_DEFAULTS ON
GO
CREATE PROCEDURE [dbo].[sp_Test] AS
SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT V.VENDOR_ID,
V.VENDOR_NAME FROM VENDOR V')
GO
Ted"Ted Calhoon" <tedcalhoon@.hotmail.com> wrote in message
news:fc57c4d8.0312121455.1e0677d8@.posting.google.c om...
> When I create a stored procedure like the one below and save it,
> everything seems fine. But when I close Enterprise Manager and
> re-open it, the stored procedure is gone.
> Any ideas?
>
> SET ANSI_DEFAULTS ON
> GO
> CREATE PROCEDURE [dbo].[sp_Test] AS
> SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT V.VENDOR_ID,
> V.VENDOR_NAME FROM VENDOR V')
> GO
>
> Ted
If you put only the CREATE PROCEDURE statement into the create procedure
dialogue, it will work:
CREATE PROCEDURE [dbo].[sp_Test] AS
SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT V.VENDOR_ID,
V.VENDOR_NAME FROM VENDOR V')
Presumably, this is a 'feature' in EM, which seems to have a number of
quirks. If you need full control over the CREATE PROC statement, you should
execute it in Query Analyzer instead, which is probably a better practice in
general.
Also, don't use sp_ as a procedure name prefix, that's reserved for system
stored procedures.
Simon|||Thanks, Simon. I will take your advice and:
1. Use Query Analyzer to create stored procedures
2. Avoid using sp_ when naming my stored procedures
Ted
disappearing "database maintenance plan"
When I try to view the properties of a database
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
disappearing "database maintenance plan"
When I try to view the properties of a database
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
2012年2月24日星期五
disabled fields, such as Upload File, in Report Manager
When I open Report Manager through IE on server 2003 installed with reporting
service and login as an admin through remote desktop connection, I can see
all the features but disabled. I can not Upload File, Add New Data Source
etc.. What is wrong? Please help.See what role-based security you have.
At the "Home" folder, go to Properties --> Security and see the roles
assigned to the admin. If you don't have "Content Manager" role
assigned to you, you can not upload the files.
Shang wrote:
> When I open Report Manager through IE on server 2003 installed with reporting
> service and login as an admin through remote desktop connection, I can see
> all the features but disabled. I can not Upload File, Add New Data Source
> etc.. What is wrong? Please help.|||Well, what i m used to do to upload rdls, is -
1 - go to the properties of reports virtual folder under IIS
2 - click directory security tab
3 - click edit button
4 - turn of anoymous access
it works for me|||I agree, it seems like the website has anonymous turned on. When anonymous
is turned on, even logged in as administrator does not give you the
administrators rights to do things in RS. This is because with anonymous
turned on everybody is treated the same, because they are anonymous.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Techotsav" <Utsav.Verma@.gmail.com> wrote in message
news:1134195509.900311.33640@.o13g2000cwo.googlegroups.com...
> Well, what i m used to do to upload rdls, is -
> 1 - go to the properties of reports virtual folder under IIS
> 2 - click directory security tab
> 3 - click edit button
> 4 - turn of anoymous access
> it works for me
>|||Hi Bruce,
Having similar problem.
Fresh install of Windows 2003 Standard, and IIS, SP1
Fresh Install of SQL 2005 w/ Reporting Services
Fresh install of Visual Studio 2005
Can not create new folder etc... Logged on as user with Administrative
privileges or Local Administrator or Domain Administrator, no difference?
Thanx in advance,
Greg Rowland|||Hi Siva,
It is Content Manager role for the admin login. Anonymous access is disabled
and Integrated Windows authentication is checked.
The server 2003 is just installed with IS6.0 and reporting services only.
Any hints?
"siva.jasthi@.gmail.com" wrote:
> See what role-based security you have.
> At the "Home" folder, go to Properties --> Security and see the roles
> assigned to the admin. If you don't have "Content Manager" role
> assigned to you, you can not upload the files.
>
> Shang wrote:
> > When I open Report Manager through IE on server 2003 installed with reporting
> > service and login as an admin through remote desktop connection, I can see
> > all the features but disabled. I can not Upload File, Add New Data Source
> > etc.. What is wrong? Please help.
>|||Greg,
Please inform me of any possible solutions since we share a similar problem.
"Greg Rowland" wrote:
> Hi Bruce,
>
> Having similar problem.
> Fresh install of Windows 2003 Standard, and IIS, SP1
> Fresh Install of SQL 2005 w/ Reporting Services
> Fresh install of Visual Studio 2005
>
> Can not create new folder etc... Logged on as user with Administrative
> privileges or Local Administrator or Domain Administrator, no difference?
>
>
> Thanx in advance,
>
> Greg Rowland
>
>
>|||I found a change to http://localhost/reports instead of
http://computername/reports
made the difference. But why?
"Greg Rowland" wrote:
> OK
>
>
service and login as an admin through remote desktop connection, I can see
all the features but disabled. I can not Upload File, Add New Data Source
etc.. What is wrong? Please help.See what role-based security you have.
At the "Home" folder, go to Properties --> Security and see the roles
assigned to the admin. If you don't have "Content Manager" role
assigned to you, you can not upload the files.
Shang wrote:
> When I open Report Manager through IE on server 2003 installed with reporting
> service and login as an admin through remote desktop connection, I can see
> all the features but disabled. I can not Upload File, Add New Data Source
> etc.. What is wrong? Please help.|||Well, what i m used to do to upload rdls, is -
1 - go to the properties of reports virtual folder under IIS
2 - click directory security tab
3 - click edit button
4 - turn of anoymous access
it works for me|||I agree, it seems like the website has anonymous turned on. When anonymous
is turned on, even logged in as administrator does not give you the
administrators rights to do things in RS. This is because with anonymous
turned on everybody is treated the same, because they are anonymous.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Techotsav" <Utsav.Verma@.gmail.com> wrote in message
news:1134195509.900311.33640@.o13g2000cwo.googlegroups.com...
> Well, what i m used to do to upload rdls, is -
> 1 - go to the properties of reports virtual folder under IIS
> 2 - click directory security tab
> 3 - click edit button
> 4 - turn of anoymous access
> it works for me
>|||Hi Bruce,
Having similar problem.
Fresh install of Windows 2003 Standard, and IIS, SP1
Fresh Install of SQL 2005 w/ Reporting Services
Fresh install of Visual Studio 2005
Can not create new folder etc... Logged on as user with Administrative
privileges or Local Administrator or Domain Administrator, no difference?
Thanx in advance,
Greg Rowland|||Hi Siva,
It is Content Manager role for the admin login. Anonymous access is disabled
and Integrated Windows authentication is checked.
The server 2003 is just installed with IS6.0 and reporting services only.
Any hints?
"siva.jasthi@.gmail.com" wrote:
> See what role-based security you have.
> At the "Home" folder, go to Properties --> Security and see the roles
> assigned to the admin. If you don't have "Content Manager" role
> assigned to you, you can not upload the files.
>
> Shang wrote:
> > When I open Report Manager through IE on server 2003 installed with reporting
> > service and login as an admin through remote desktop connection, I can see
> > all the features but disabled. I can not Upload File, Add New Data Source
> > etc.. What is wrong? Please help.
>|||Greg,
Please inform me of any possible solutions since we share a similar problem.
"Greg Rowland" wrote:
> Hi Bruce,
>
> Having similar problem.
> Fresh install of Windows 2003 Standard, and IIS, SP1
> Fresh Install of SQL 2005 w/ Reporting Services
> Fresh install of Visual Studio 2005
>
> Can not create new folder etc... Logged on as user with Administrative
> privileges or Local Administrator or Domain Administrator, no difference?
>
>
> Thanx in advance,
>
> Greg Rowland
>
>
>|||I found a change to http://localhost/reports instead of
http://computername/reports
made the difference. But why?
"Greg Rowland" wrote:
> OK
>
>
2012年2月19日星期日
Disable the use of Enterprise Manager
I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application' if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application'
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application' if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application'
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>
Disable the use of Enterprise Manager
I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application? if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application?
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>
|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application? if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application?
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>
|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>
disable the service manager
Is there anyway I can disable the service manager from running. I have a
sql server that several users connect to via terminal services and they all
get the service manager in the system tray. I want to remove this but don't
know how.It's probably in the Startup group for the Default User. Simply remove it's
shortcut from Startup
--
HTH
Ryan Waight, MCDBA, MCSE
"sarah" <sarahkingswell@.hotmail.com> wrote in message
news:OgtXgxBjDHA.3264@.TK2MSFTNGP11.phx.gbl...
> Is there anyway I can disable the service manager from running. I have a
> sql server that several users connect to via terminal services and they
all
> get the service manager in the system tray. I want to remove this but
don't
> know how.
>
sql server that several users connect to via terminal services and they all
get the service manager in the system tray. I want to remove this but don't
know how.It's probably in the Startup group for the Default User. Simply remove it's
shortcut from Startup
--
HTH
Ryan Waight, MCDBA, MCSE
"sarah" <sarahkingswell@.hotmail.com> wrote in message
news:OgtXgxBjDHA.3264@.TK2MSFTNGP11.phx.gbl...
> Is there anyway I can disable the service manager from running. I have a
> sql server that several users connect to via terminal services and they
all
> get the service manager in the system tray. I want to remove this but
don't
> know how.
>
2012年2月17日星期五
Disable MSX Functionality
How do you stop an MSX server being an MSX server?
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
DaveHi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegroups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 712 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||Nice one, thanks!
Dave
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
DaveHi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegroups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 712 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||Nice one, thanks!
Dave
Disable MSX Functionality
How do you stop an MSX server being an MSX server?
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
DaveHi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards :)
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegroups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 712 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||Nice one, thanks!
Dave
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
DaveHi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards :)
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegroups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 712 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||Nice one, thanks!
Dave
Disable MSX Functionality
How do you stop an MSX server being an MSX server?
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
Dave
Hi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegr oups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 712 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
|||Nice one, thanks!
Dave
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
Dave
Hi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegr oups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 712 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
|||Nice one, thanks!
Dave
2012年2月14日星期二
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...
>
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...
>
订阅：
博文 (Atom)