ODBC ERROR in connecting user in database user id table

  • Hi there

    Any one can help me !!!!!

    If i add the user in the database userid table, it indicates the error as

    follows (given user name is not added in the userid table due to this error)

    [Microsoft][ODBC SQL Server Driver][SQL Server]

    The updatelineage function requires 2 arguments

    [Microsoft][ODBC SQL Server Driver][SQL Server]

    GETMAXVERS is not recognized

    [Microsoft][ODBC SQL Server Driver][SQL Server]

    The updatelineage function requires 2 arguments

    [Microsoft][ODBC SQL Server Driver][SQL Server]

    GETMAXVERS is not recognized

    Thanks in advance

    by

    yasin

  • This was removed by the editor as SPAM

  • If you are trying to add a record directly to a table and get this error, then I would look to see if there is a trigger on the table that is causing the problem.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • This question was asked quite a long time ago, but I've recently had the same problem and just found a solution. Getting information online for this was tough, so I thought I'd post for anyone else searching on this.

    Run sp_mergesubscription_cleanup @publisher = [Publisher Name], @publisher_db = [Publication name], @publication = [Publication name] against the database. This cleared up my issue.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply