This is another one of those questions where more thinking needs to be put into it. EDIT: Should have read select 3

With out stating what version you were asking for...

Good question, had to do a touch of reading but got it in the end.

Good way to start a my Monday - after my third coffee 🙂

Nice question, good way to end off the week.

Thanks

easy but still had to confirm with a bit of reading.

Nice and easy Q, thanks

the 'red' is a sql account.

happycat59 (10/14/2013)

---

I first thought on this is that you are about to create a serious bottleneck in your system - at best you will experience a little bit of blocking....

Certainly makes sense I will try it out and let you know.

Appreciate the idea.

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...

security_settingnr_of_windows_loginsnr_of_sql_loginstotal_logins#

Windows 47 ...

Great article - well laid out and explains this clearly -- and works a peach on SQL Server 2014.

Easy one for Friday. Thanks

peterswe (10/8/2013)

---

Since I have worked with Oracle I have removed duplicates using the rowid column. SQL Server has something similar but its an undocumented feature (might be changed without notice).

delete

from...

Nice question, had to go do some digging again for this.