Are they all 'sa'? Are they all low session_id? If you query sys.dm_exec_sessions, what do they show for 'IsUserProcess'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
None of them are 'sa', they are all a sql account 'red' using an odbc connection.
here is one line from the select
session_idlogin_timehost_nameprogram_namehost_process_idclient_versionclient_interface_namesecurity_idlogin_nament_domainnt_user_namestatuscontext_infocpu_timememory_usagetotal_scheduled_timetotal_elapsed_timeendpoint_idlast_request_start_timelast_request_end_timereadswriteslogical_readsis_user_processtext_sizelanguagedate_formatdate_firstquoted_identifierarithabortansi_null_dflt_onansi_defaultsansi_warningsansi_paddingansi_nullsconcat_null_yields_nulltransaction_isolation_levellock_timeoutdeadlock_priorityrow_countprev_errororiginal_security_idoriginal_login_namelast_successful_logonlast_unsuccessful_logonunsuccessful_logonsgroup_id
10210/15/2013 8:25:37 AMxxxxSAPDCI01R3B12 [1]unc rd ODBC36606ODBC0x2D220E9B08C8284CB972665E2AC166CDredsleeping0x16399210/15/2013 8:25:46 AM10/15/2013 8:25:46 AM004681-1us_englishmdy7101011111-10000x010500000000000515000000CC98BBF9DA303149DE4CA1FFA2060000xxxx\SAPServiceRED2
Apologies for the mess - not sure how would be the best way to represent this information here.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
If I interpred your output correctly the value in column "original login" is xxxx\SAPServiceRED. This looks like a Windows account/AD-group to me. Can you check the value Red in column "login_name" is a really a login and not a credential?
the 'red' is a sql account.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply