Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    26

    Unanswered: Table index and view index

    Hi,

    I was just wondering when you migrate a database from SQLServer 2000 to SQLServer 2005 using the restore or attach/reattach method, do the table index and view index also get copied across??

    Thanks.

  2. #2
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Yes, everything in the database comes along when using restore or attach. One suggestion - rebuild your indexes or update statistics when you get the database onto SQL 2005.

Posting Permissions

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