RE: Getting my Current Session ID

Lowell

SSC Guru

Points: 323504

March 17, 2010 at 9:06 am

#1135322

I didn't see your previous post, but are you looking for @@SPID?

select @@SPID will give you your current connection id, is that what you are looking for?

here's a collection of some of the functions you can use to get more information about your own login:

select @@spid,

user_name() AS [user_name],

suser_name() AS [suser_name],

current_user AS [current_user],

system_user AS [system_user],

session_user AS [session_user],

user AS

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!