User Profile

Collapse

Profile Sidebar

Collapse
wess
wess
Last Activity: Sep 7 '06, 05:58 PM
Joined: Sep 3 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • wess
    replied to Can't Keep Primary Key Columns when moving db to SQL 2005 from 2000
    in SQL Server
    ramasp,

    Thanks, I appreciate your help.

    I have given this information to the developer I have working on this. He tells me he tried this and that it can not work because the two versions are different.

    Please let me know if this should work and the proccess to do so.

    Thanks,

    Wess
    See more | Go to post

      Leave a comment:

    • wess
      started a topic Can't Keep Primary Key Columns when moving db to SQL 2005 from 2000
      in SQL Server

      Can't Keep Primary Key Columns when moving db to SQL 2005 from 2000

      there are some primary key columns which are autoincrement in some tables.
      for exampl page_id, now we have deleted many pages in old server so there
      are many gaps between the page_id
      even the it doest start with 1 because during the testing many initial pages
      were deleted.

      but when we move it to the new server with sql2005 it gives them numbers from 1,2,3 and
      so on.

      I need to keep...
      See more | Go to post
      No activity results to display
      Show More
      Working...