August 20, 2011 at 12:04 am
how can lock or readonly plans on sqlserver2000?
i want noboday cannot change plans info.can I lock plans on server2000?
August 20, 2011 at 3:34 am
If you mean execution plans, you can't do that on any version. Not that users can change plans, but SQL sure can.
Why don't you start by explaining what the problem here is?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 20, 2011 at 4:21 am
some people in my office ,have access to sqlserver as admin and can change execution plan.
today i found some ones add new databases to weekly plan and cause my plan result be fail.
and now i want lock plan for these people.
August 20, 2011 at 4:29 am
Users can not change execution plans. An execution plan also can't fail.
Are you talking about execution plans (plans created by SQL to tell how to run a query) or maintenance plans (database maintenance jobs) or something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 20, 2011 at 4:57 am
excuse me . my means was maitenance plan in sqlserver2000
August 20, 2011 at 5:15 am
Restrict their permissions. An admin can do anything and there is no way to deny an admin anything in SQL. If they're doing things they shouldn't be speak to them or remove their admin permissions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply