[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Credentials

Posted on 2009-12-30
2
Medium Priority
?
367 Views
Last Modified: 2012-05-08
I have written an application that connects to the SQL server and accesses a few tables.  I am using ms credentials to access the SQL server.  Is there any way that I can pull the user name that I am connecting with?  So if I am connecting as Bob...   I can write bob connected in the logs?
0
Comment
Question by:the_b1ackfox
2 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 2000 total points
ID: 26151967
select SUSER_NAME()
0
 
LVL 9

Author Closing Comment

by:the_b1ackfox
ID: 31671507
Wow!!! Thank you!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question