Navigation

Home
dasBlog
CodePlex
newtelligence AG

Search

Categories

 
 
 
 
 
 
 
 
 
 
 
 
 

On this page

Archive

January, 2010 (1)
December, 2009 (3)
October, 2009 (2)
September, 2009 (1)
January, 2009 (2)
September, 2008 (2)
August, 2008 (1)
April, 2008 (4)
March, 2008 (2)
January, 2008 (2)
December, 2007 (2)
October, 2007 (4)
September, 2007 (1)
July, 2007 (1)
May, 2007 (6)
April, 2007 (6)
January, 2007 (4)
December, 2006 (3)
October, 2006 (2)
September, 2006 (2)
August, 2006 (2)
July, 2006 (2)
June, 2006 (1)
May, 2006 (3)
December, 2005 (1)
November, 2005 (2)
October, 2005 (6)
September, 2005 (5)
August, 2005 (2)
July, 2005 (8)
May, 2005 (4)
April, 2005 (1)
February, 2005 (4)
January, 2005 (6)
December, 2004 (13)
November, 2004 (3)
October, 2004 (3)

Blogroll

[Feed] Omar Shahine
[Feed] Scott Hanselman

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 120
This Year: 1
This Month: 0
This Week: 0
Comments: 40

Sign In
Pick a theme:

# Monday, September 28, 2009
Get the current username and domain for the currently authenticated SQL Server user for Windows Integrated Authentication
Monday, September 28, 2009 1:58:31 PM (Mountain Daylight Time, UTC-06:00) ( )

The title of this post declares the intent of the code below

DECLARE @Domain VARCHAR(50);
DECLARE @Account VARCHAR(50);
SET @Domain = SUBSTRING(SYSTEM_USER, 0, CHARINDEX('\', SYSTEM_USER));
SET @Account = SUBSTRING(SYSTEM_USER, CHARINDEX('\', SYSTEM_USER) + 1, LEN(SYSTEM_USER) - CHARINDEX('\', SYSTEM_USER));
SELECT @Domain + '\' +@Account AS samAccountName;

Comments [0] | | # 
Comments are closed.