Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Kentucky
    Posts
    12

    Unanswered: Image Data type in a table

    We have a table with Image column in it appx. #rows 0.6 millions, on a default Segment. Now I want to move the table to a new user define Segment. I tried through BCP but it error out after certain rows.

    Does Any one know, how to move the Table to a new segment.

    thnaks in Advance

    Regrds
    Ashok

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hi Ashok,

    You have not posted what sort of errors that you get, which means I can assume that the bcp is working and after sometime you get some error message.

    Why don't you try a SELECT INTO a dummy table
    Drop the original table, and then use sp_rename to rename the dummy to original.

    Cheers
    Willy

Posting Permissions

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