|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Wednesday, June 05, 2013 3:08 PM
Points: 237,
Visits: 525
|
|
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?
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 38,028,
Visits: 30,334
|
|
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 2008, MVP 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
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Today @ 9:51 AM
Points: 98,
Visits: 659
|
|
| Can you look at the existing data in the log table to see what has been inserted in the past?
|
|
|
|