This udb.logging_table is a user defined table type.  Its specifically created to pass parameters into the udb.logInsertTableVariable stored procedure

Column name Data type Description
date_logged datetime2(7) The time the record was generated.
calling_sql_name varchar(257) The name of the calling process normally a procedure name normally in the format SchemaName.ProcedureName
user_name sysname The name of the user executing the step, suser_name, user_name, or original_login_name
step smallint The current step number
total_steps smallint The total number of steps in a given "calling_sql_name"
message varchar(1000) The message that is to be logged by this particular step



See Also


Last edited Jan 9, 2014 at 4:49 PM by sfibich, version 2


No comments yet.