SQL Server: SESSION_USER Function

SESSION_USER function in SQL Servers

This SQL Server tutorial explains how to use the SESSION_USER function in SQL Servers (Transact-SQL) with syntax and examples.

Description

In SQL Server (Transact-SQL), the SESSION_USER function returns the user name of the current session in the SQL Server database.

Syntax

The syntax for the SESSION_USER function in SQL Servers (Transact-SQL) is:

SESSION_USER

Parameters or Arguments

identification_number

Optional. The identification number associated with a user in SQL Server.

Note

Applies To

The SESSION_USER function can be used in the following versions of SQL Server (Transact-SQL):

  • SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005

Example

Let’s look at some SQL Server SESSION_USER functions examples and explore how to use the SESSION_USER function in SQL Server (Transact-SQL).

For example:

SELECT SESSION_USER;
Result: 'dbo'

This Post Has 119 Comments

  1. Download Lagu Mp3

    Good day! I just would like to offer you a huge thumbs up for the great info you have right here on this post. I’ll be coming back to your site for more soon.

  2. Porn

    Oh my goodness! Awesome article dude! Many thanks, However I am encountering troubles with your RSS. I don’t know the reason why I am unable to join it. Is there anyone else getting similar RSS issues? Anyone that knows the solution can you kindly respond? Thanks.

  3. mp3juices

    I need to to thank you for this wonderful read!! I absolutely enjoyed every little bit of it. I’ve got you bookmarked to check out new things you post…

  4. This is a topic which is close to my heart… Best wishes! Exactly where are your contact details though?

  5. Avanda.id

    I could not resist commenting. Exceptionally well written!

  6. 무료야동

    Wow, great article post.Really looking forward to read more.

  7. Fakaza

    Howdy, I do believe your blog may be having browser compatibility issues. When I look at your website in Safari, it looks fine however, when opening in Internet Explorer, it has some overlapping issues. I just wanted to give you a quick heads up! Aside from that, wonderful website.

  8. Home Page

    Howdy, I believe your web site could be having web browser compatibility issues. When I take a look at your blog in Safari, it looks fine however when opening in IE, it has some overlapping issues. I simply wanted to provide you with a quick heads up! Aside from that, excellent website!

  9. Porn

    I seriously love your blog.. Very nice colors & theme. Did you build this amazing site yourself? Please reply back as I’m wanting to create my own personal site and would love to know where you got this from or what the theme is named. Cheers!

  10. Jobs in ogun

    Thanks for sharing, this is a fantastic blog article.Thanks Again. Much obliged.

  11. 카지노총판

    I cannot thank you enough for the post.Really thank you! Really Great.

  12. Fakaza

    When I initially left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on every time a comment is added I get 4 emails with the same comment. Is there a means you are able to remove me from that service? Kudos.

  13. Fakaza

    Hi! I could have sworn I’ve visited this website before but after browsing through some of the articles I realized it’s new to me. Nonetheless, I’m definitely pleased I discovered it and I’ll be bookmarking it and checking back often!

  14. I’m amazed, I have to admit. Rarely do I come across a blog that’s both educative and interesting, and without a doubt, you have hit the nail on the head. The issue is an issue that not enough men and women are speaking intelligently about. Now i’m very happy I came across this during my search for something regarding this.

  15. auto detailing

    I value the blog article.Really looking forward to read more. Want more.

  16. index

    Your style is really unique in comparison to other people I have read stuff from. I appreciate you for posting when you’ve got the opportunity, Guess I’ll just bookmark this web site.

  17. spa in pune

    Thanks again for the blog article.Much thanks again.

  18. totoro

    Thanks for sharing, this is a fantastic article post.Really thank you! Cool.

  19. skjerf

    Really informative article.Much thanks again. Awesome.

  20. MP3Juices

    I’m extremely pleased to uncover this page. I want to to thank you for your time for this wonderful read!! I definitely really liked every little bit of it and i also have you book marked to check out new stuff on your website.

  21. ring engraver

    Very good post.Really looking forward to read more. Awesome.

  22. pris på gull

    Great, thanks for sharing this blog article.Thanks Again.

  23. This is the perfect web site for anybody who wishes to find out about this topic. You realize a whole lot its almost tough to argue with you (not that I really would want to…HaHa). You certainly put a fresh spin on a subject that’s been discussed for years. Excellent stuff, just excellent.

  24. funny reddit

    Great, thanks for sharing this blog article.Thanks Again. Keep writing.

  25. Good post. I learn something totally new and challenging on blogs I stumbleupon everyday. It’s always useful to read articles from other writers and practice a little something from their sites.

  26. Oh my goodness! Impressive article dude! Thank you, However I am having troubles with your RSS. I don’t know the reason why I cannot join it. Is there anyone else having similar RSS issues? Anybody who knows the solution can you kindly respond? Thanx.

  27. resource

    I seriously love your site.. Very nice colors & theme. Did you develop this web site yourself? Please reply back as I’m attempting to create my own personal website and want to learn where you got this from or what the theme is named. Cheers!

  28. HijabyZakia

    There’s definately a lot to find out about this subject. I like all the points you have made.

  29. Aw, this was a really good post. Taking the time and actual effort to make a top notch article… but what can I say… I procrastinate a lot and don’t seem to get anything done.

  30. I needed to thank you for this wonderful read!! I definitely enjoyed every little bit of it. I have got you bookmarked to check out new things you post…

  31. mp3 quack

    I’m amazed, I have to admit. Rarely do I come across a blog that’s both equally educative and engaging, and let me tell you, you have hit the nail on the head. The issue is something not enough folks are speaking intelligently about. I’m very happy I found this during my search for something concerning this.

  32. toto 4d

    Im obliged for the article.Much thanks again. Cool.

  33. Clicking Here

    Hello! I could have sworn I’ve visited this blog before but after browsing through many of the articles I realized it’s new to me. Regardless, I’m definitely pleased I discovered it and I’ll be book-marking it and checking back regularly!

  34. It’s nearly impossible to find experienced people in this particular subject, but you sound like you know what you’re talking about! Thanks

  35. sms marketing

    Thanks again for the blog article.Really thank you! Cool.

  36. find out here now

    When I originally commented I seem to have clicked the -Notify me when new comments are added- checkbox and now whenever a comment is added I get four emails with the exact same comment. Perhaps there is an easy method you can remove me from that service? Thank you.

  37. blossoms

    I really liked your blog article.Really looking forward to read more.

  38. I cannot thank you enough for the blog article.Much thanks again. Fantastic.

  39. mp3quack

    I seriously love your blog.. Excellent colors & theme. Did you make this amazing site yourself? Please reply back as I’m looking to create my own blog and would like to learn where you got this from or just what the theme is named. Thank you.

  40. Spot on with this write-up, I seriously think this website needs much more attention. I’ll probably be back again to read more, thanks for the advice!

  41. A motivating discussion is worth comment. I do believe that you ought to publish more about this issue, it may not be a taboo subject but generally people don’t speak about these topics. To the next! Best wishes!!

  42. An interesting discussion is definitely worth comment. I think that you ought to write more on this issue, it may not be a taboo subject but usually people don’t speak about these topics. To the next! Cheers!!

  43. Tubidy

    This is one awesome blog article.Much thanks again. Want more.

  44. Tubidy

    Good article. I am dealing with a few of these issues as well..

  45. I was pretty pleased to discover this website. I want to to thank you for ones time due to this wonderful read!! I definitely savored every part of it and i also have you bookmarked to look at new things in your web site.

  46. useful site

    I used to be able to find good advice from your articles.

  47. Good post. I learn something totally new and challenging on sites I stumbleupon every day. It will always be useful to read through articles from other authors and practice a little something from their sites.

  48. best panty

    A round of applause for your blog. Really Cool.

Leave a Reply

WC Captcha 45 − 43 =