Post reply

what to place in Stored Proc sysname parameter

  • January 28, 2013 at 8:23 am

    #269485

    I have a table that my company uses for logging. One of the columns is declared as:

    event (sysname(nvarchar(128)),not null)

    We have a stored proc for inserting a row to this table:

    sp_addlogentry sysname

    What do I place in the stored proc call for the sysname parameter?

  • January 28, 2013 at 8:40 am

    #1581663

    No idea. That's not a standard procedure, must be something that your devs wrote. Check the proc, see if there are any comments and ask your colleagues

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 29, 2013 at 8:15 am

    #1582160

    Can you look at the existing data in the log table to see what has been inserted in the past?

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

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