Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is any database options to disable any changes try to make on it
- Thread starter masds
- Start date
When you log into EM, is it asking you for a password?
If not, have you verified your SysAdmin SQL login is mapped to your Windows User name? That might be where the problem is.
Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"
If not, have you verified your SysAdmin SQL login is mapped to your Windows User name? That might be where the problem is.
Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"
- Thread starter
- #3
The problem is that when you open the dialogue, the OK button will be gray, when you change any setting other than change the recovery mode by selecting one of option from combo box, the ok button is enabled, but change the recovery mode won't make this button enabled, it's like a SQL Server bug to me.
And just to make sure we understand you....
In Enterprise Manager, you are right clicking on a database, selecting Properties, and going to the Options tab. Correct so far?
Now the confusing part, you say the OK button is disabled? What do you mean 'disabled'? Do you mean that when you change the Recovery Mode and click OK nothing changes?
If that's true, then I will guess you are trying to change the Recovery Mode of a system database. You can not change Master, TEMPDB, and I believe you can't change MSDB.
-SQLBill
Posting advice: FAQ481-4875
In Enterprise Manager, you are right clicking on a database, selecting Properties, and going to the Options tab. Correct so far?
Now the confusing part, you say the OK button is disabled? What do you mean 'disabled'? Do you mean that when you change the Recovery Mode and click OK nothing changes?
If that's true, then I will guess you are trying to change the Recovery Mode of a system database. You can not change Master, TEMPDB, and I believe you can't change MSDB.
-SQLBill
Posting advice: FAQ481-4875
- Thread starter
- #6
Now I need to verify something. In your first post, you said you have SysAdmin privledges. In the last post, you're saying "when the user makes any changes".
Is this happening for more then one user?
Have you checked the Fixed Server roles for the users in question, along with the mapping of their windows accounts? Sorry to ask this question again, but you don't say whether or not this is something you checked yet.
Lastly, it might be something going on with Enterprise Manager. Have you tried re-installing it? Only do this if you've checked the permissions issue first. Check the FAQ section of this newsgroup and you'll see where I posted one for the repair of a corrupted Enterprise Manager.
I'm not sure corrupted EM is your problem, though.
Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"
Is this happening for more then one user?
Have you checked the Fixed Server roles for the users in question, along with the mapping of their windows accounts? Sorry to ask this question again, but you don't say whether or not this is something you checked yet.
Lastly, it might be something going on with Enterprise Manager. Have you tried re-installing it? Only do this if you've checked the permissions issue first. Check the FAQ section of this newsgroup and you'll see where I posted one for the repair of a corrupted Enterprise Manager.
I'm not sure corrupted EM is your problem, though.
Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"
Let me try this again since you didn't answer all my questions:
1. What database is this happening with?
2. What version of SQL Server?
3. In Enterprise Manager, you are right clicking on a database, selecting Properties, and going to the Options tab. And that is where you are having the problem. Is that correct?
-SQLBill
Posting advice: FAQ481-4875
1. What database is this happening with?
2. What version of SQL Server?
3. In Enterprise Manager, you are right clicking on a database, selecting Properties, and going to the Options tab. And that is where you are having the problem. Is that correct?
-SQLBill
Posting advice: FAQ481-4875
- Thread starter
- #9
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question