SQL: List Database Connections for specific user

-
Code (SQL Statement) starts here
select *
from master..sysprocesses
where loginame = ‘connexin.cim’ –and hostname=’COMPUTERNAME’
order by hostname
Code (SQL Statement) ends here

Yorumlar

Yorum Gönder

Bu blogdaki popüler yayınlar

TERMINAL SERVICES UNLIMITED

-
UNLIMITED TERMINAL SERVICES CONNECTIONS IN WINDOWS TERMINAL SERVICES 2000 AND 2003 1. INTRODUCTION Welcome to Terminal Services Unlimited. This document aims to help you get Microsoft Windows 2000 and Windows 2003 terminal services unlimited connections at unlimited time. Please note that this is not crack for windows or anythig like that. Nevertheless, to completely prepare your server, I recommend that you begin by taking the step by step as it is covered in this document. I also recommend that you install, configure terminal services and terminal services licensing for running. I have tested this solution with clients Windows 2000 Pro, Windows XP, Windows 2000 Server, various Windows 2003 servers and PocketPC and also I have feedback that this is also working on thin clients. 2. UNLIMITED TERMINAL SERVICES CONNECTIONS IN WINDOWS 2000 Acording to Microsoft it is not ilegal to use terminal server with temporary licenses. There is a paragraph that says: " There is no provision in ...
Devamı

Debugging Group Policy Processing

-
Resim
Group Policy Debug Log Settings The below article has got information about enabling different debug loggings which are required for troubleshooting various Windows issues. USERENV DEBUG LOGGING Userenv logging is useful when troubleshooting group Policy application related issues or User profile related issues. ENABLING USERENV LOGGING IN WINDOWS XP Use Registry Editor to add or to modify the following registry entry: Subkey: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Winlogon Entry: UserEnvDebugLevel Type: REG_DWORD Value data: 10002 (Hexadecimal) UserEnvDebugLevel can have the following values: NONE 0×00000000 NORMAL 0×00000001 VERBOSE 0×00000002 LOGFILE 0×00010000 DEBUGGER 0×00020000 The default value is NORMAL|LOGFILE (0×00010001). Note  To disable logging, select NONE (0×00000000). You can combine these values. For example, you can combine VERBOSE 0×00000002 and LOGFILE 0×00010000 to get 0×00010002. Therefore, if UserEnvDebugLevel...
Devamı

Windows 7: Optional update delivery is not working - “You may be a victim of software counterfeiting.”

-
Resim
  For several years now Microsoft started to fight non-genuine copies of Windows. Unfortunately still some legal copies are affected by the anti-piracy system. Once you see the message above (Windows Vista or 7) reboot your system as soon as possible and once you login again, Click the Start Menu type “activate windows”. However some users click “Get online and resolve now” link and they get a message Windows Activation: “An unauthorized change was made to Windows. You must reinstall or restore Windows system files to activate.” Proceed with the same procedure, reboot your PC and Activate windows. Microsoft also recommends to uninstall programs that checks your system files such as anti-spyware and third-party firewall. For me, anti-piracy is not needed in all version of Windows because sometimes this a good strategy for both both hardware and software manufacturer to popularize a product. Anyway, All of us have different views but most of the time we share the...
Devamı