Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: SQL Server 2005 Database is not updated after migration

    Hi all,

    We have migrated the databases from SQL Server 2000 to SQL Server 2005 in the production environment. All the databases ase working fine but the database is not updated after the migration process. We are able to update manually. Can anyone help me to resolve it as soon as possible.

    Thanks in advance.

    Regards,
    Lawanya

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    What do you mean by "updated"? What are you updating manually?

    Did you follow an upgrade checklist (update stats, rebuild indexes etc etc)?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2007
    Posts
    2
    Hi,

    Update manually means just updating a row.. Then Im not much familiar with SQL Server. Im working in businessobjects in offshore. Do I need to check any of the status in the db for activating it. Please help me.

    Regards,
    Lawanya

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ok - so explain the steps you take to update manually. Then explain the steps to update "not manually" and what happens (error messages etc).

    This also might be useful:
    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80138
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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