Getting the user_name into the table

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  August 11, 2003 at 8:25 am

  #159753

  I have a table report.This table is used to write the hourly summary of the data.A stored procedure will be run for every one hour by a sql server USer.In this table i wanetd to display the time of running the SP and user_name of the user who has run the SP in two columns.How can i get the user_name into the report table.

  Thanks in advance

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  August 11, 2003 at 8:45 am

  #469421

  Hi Bruce,

  quote:

  ---

  I have a table report.This table is used to write the hourly summary of the data.A stored procedure will be run for every one hour by a sql server USer.In this table i wanetd to display the time of running the SP and user_name of the user who has run the SP in two columns.How can i get the user_name into the report table.

  ---

  recently there was a QOD on this topic. This will help you

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14674&FORUM_ID=120&CAT_ID=10&Topic_Title=QOD+7%2F29%2F2003&Forum_Title=Question+of+the+Day+%28QOD%29

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]