sql server error

Discussion in 'Databases' started by Jamie18, Jul 25, 2008.

  1. #1
    I'm getting an error i don't understand while attempting to run a simple insert


    Server: Msg 2758, Level 16, State 1, Procedure Memberships_ITrig, Line 20
    [COLOR="Red"]RAISERROR could not locate entry for error 778504 in sysmessages.[/COLOR]
    Code (markup):
    the table is memberships
    with columns : group_id (int 4), contact_id (int 4), address_flag (bit 1), admin_flag (bit 1), private (bit 1), hold (bit 1), title (varchar 40), archived (tinyint 1)

    contact_id and group_id form the primary key

    Here's the statement
    insert into memberships (group_id, contact_id) values (16133, 370568)
    Code (markup):
    I can't find the procedure Memberships_ITrig anywhere, i'm assuming some system procedure is creating this while it's running or something of that sort.

    I've also tried insert statements assigning values for all of fields but got the same error.
     
    Jamie18, Jul 25, 2008 IP
  2. Julsniper

    Julsniper Peon

    Messages:
    52
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Ask server administrator or hire someone with sql knowledge
     
    Julsniper, Jul 25, 2008 IP
  3. pripatel93

    pripatel93 Peon

    Messages:
    276
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yea good luck in finding some one with SQL knowledge lol.
    server admin is your best bet though i agree. they should be able to sort that problem out
     
    pripatel93, Jul 26, 2008 IP