Professional Web Applications Themes

Update error? - Microsoft SQL / MS SQL Server

One way or the other oldfield and oldaccount are defined with a different collation. This could be because the databases were created with different collations, or the tables specifically. Either way you can check via sp_help on each table and you should see that the collation clause is different. To get round it either alter one of the tables to match the other (It would seem doubtful that they should really be different) or add a COLLATE clause on the where clause specifying the collation you want it to use for the comparison. Mike John "Lee" <lalcantaraschools.org> wrote in message ...

  1. #1

    Default Re: Update error?

    One way or the other oldfield and oldaccount are defined with a different collation. This could be because the databases were created with different collations, or the tables specifically. Either way you can check via sp_help on each table and you should see that the collation clause is different.

    To get round it either alter one of the tables to match the other (It would seem doubtful that they should really be different) or add a COLLATE clause on the where clause specifying the collation you want it to use for the comparison.

    Mike John


    "Lee" <lalcantaraschools.org> wrote in message news:00a201c3470c$6516f990$a501280aphx.gbl...
    > Hi,
    >
    > Hi, do you know what this error means. I looked it up in
    > knowledge base, but could not find anything related.
    >
    > Error:
    > Server: Msg 446, Level 16, State 9, Line 1
    > Cannot resolve collation conflict for equal to operation.
    >
    > This is the SQL statement I ran:
    > update DB1.sysop.oldTable
    > set oldfield = newaccount
    > from DB1.sysop.oldtable oldfield
    > join DB2.dbo.newtable newaccount on oldaccount = oldfield
    >
    > Thanks
    > Lee
    Mike John Guest

  2. #2

    Default Update error?

    Thanks guys, your information was very helpful.

    Lee Guest

Similar Threads

  1. error after update
    By Anouk01 in forum Macromedia Flash Player
    Replies: 1
    Last Post: December 19th, 07:13 PM
  2. 6.0.1 update error
    By Paul_Streeto@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 3
    Last Post: September 1st, 12:07 AM
  3. Update 3.01 error
    By Timo_Gustafsson@adobeforums.com in forum Adobe Indesign Windows
    Replies: 0
    Last Post: April 30th, 02:54 PM
  4. Update Error - read only error
    By Peter in forum ASP Database
    Replies: 1
    Last Post: January 27th, 03:04 PM
  5. Update Error
    By Philip Schofield in forum Windows Networking
    Replies: 0
    Last Post: July 10th, 12:27 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139