Results 1 to 2 of 2

Thread: [RESOLVED] Get Users Account Logon Info

  1. Nov 8th, 2005, 08:30 AM #1
    FishGuy
    FishGuy is offline

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Resolved [RESOLVED] Get Users Account Logon Info

    Hi,
    Sorry for asking this because I know its on here somewhere but cant seems to find it when I search.

    All I want is an SP that returns my logon name i.e jsmith

    but cannot remember the exact syntax.
    Last edited by FishGuy; Nov 8th, 2005 at 09:21 AM.
    Reply With Quote Reply With Quote
  2. Nov 8th, 2005, 08:35 AM #2
    FishGuy
    FishGuy is offline

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: Get Users Account Logon Info

    Found it

    select system_user as my_user_name

    Returns full domain/username

    Anyone know how to strip out the domain si it just returns the username?

    Used Substring
    Last edited by FishGuy; Nov 8th, 2005 at 11:31 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width