Home Forums SQL Server 2008 SQL Server 2008 - General Get User Name from suser_name() and host_name() RE: Get User Name from suser_name() and host_name()

  • May 20, 2010 at 12:17 pm

    #1170391

    i think this is what you might be after:

    --results:

    TheDomainTheUser

    TheDomainlowell

    declare @MyDomainLogin varchar(30)

    SET @MyDomainLogin='TheDomain\lowell'

    --SET @MyDomainlogin = SUSER_NAME()

    SELECT

    --the -1 and +1 are to remov ethe char '\' itself fromt eh results

    SUBSTRING(@MyDomainLogin,1, CHARINDEX('\',@MyDomainLogin) -1) As TheDomain,

    --find the location of the slash, grab substring of the right of THAT.

    SUBSTRING(@MyDomainLogin,CHARINDEX('\',@MyDomainLogin) + 1,30) As TheUser

    WHERE CHARINDEX('\',@MyDomainLogin) > 0--don't crash on a non-domain name

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!