DB properties cannot be changed with Enterprise Manager

Hello,

after the upgrade of MS SQL Server 7 to MS SQL Server 2000 on MS Windows 2000 Server and installation of MS SQL Server 2000 SP2 it is not possible to make changes to DB properties of user DBs with Enterprise Manager. MS SQL Server Instance properties and System DB properties are changeable with Enterprise Manager, but user DB properties can only be changed using Query Analyzer.

Has anybody an idea how to fix this problem?

Regards
Joe :rolleyes:Hi,

Do u trying to change by local Enterprise Manager or over Network?

Remember that are some new things in (2000) Permissions topic.

Explain more your schema.

[ ]'s|||Hi,

I tried to use the enterprise manager local and remote. Both doesn't work. I can display the user DB properties, but the ok button is grey. So I cannot use it.
What do you mean with new permissions at SQL 2000?

Regards
Joe