Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Location
    Germany
    Posts
    6

    Unanswered: 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

  2. #2
    Join Date
    Jan 2002
    Posts
    13
    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
    Pedro Henrique Nunes
    MCP-MCP+I-MCSENT4-MCSEW2K
    Sao Paulo - Brasil

  3. #3
    Join Date
    Oct 2001
    Location
    Germany
    Posts
    6
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •