Check how many users are logged into SQL Server

Have you ever wondered how to check how many users are logged in to the SQL Server? You must have right' so here is the solution to find it out. Execute any one of the below query in your SQL Server.

select * from sys.sysprocesses
or
EXEC sp_who
or
EXEC sp_who2

To know more about eh sysprocesses go to this link: http://msdn2.microsoft.com/en-us/library/ms179881.aspx

You can also check the active connections for each Database in your SQL Server. To do so execute the following query.

SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

Comments

Know your Lha Zha, Sog Zha, Shi Zha

There is believe in Buddhism, that an individual person have got their own lucky day and bad luck day in a week. They are derived from the twelve animals similar to chiness horscope. Your birth year tells you which Buddhism zodiac sign you below to. Lha Zha and Sog Zha are belived to be good day while Shi zha is consider bad day.

Remove Log files from Checkpoint

Here is how you can delete checkpoint old log files 1. Go to Gaia Terminal 2. Enter expert mode 3. echo $FWDIR to get the log file location 4. Go to the Log directory cd $FWDIR/log 5. rm 2013-10-01* to remove 1st Oct 2013 logs

IPTABLES

Under linux OS, we use iptables to secure the machine from any other external attack. In current scenario I am forwarding the packages from local interface to external interface and i have squid configured which will be acting as transparent proxy. Only selective port numbers are open for the network. 1. Save the script to a file. 2. Give permission to execute. chmod +x filename . 3. Execute the file as follows ./filename 4. save the output of the script to system iptables file, by running the command service iptables save 5. You are done, start/restart the iptables service. service iptables restart Script: #!/bin/sh # chmod +x file name to execute # eth0 LAN # eth1 WAN # Local IP range 192.168.0.0/25 # NATing # Transparent proxy iptables -F iptables -X iptables -t nat -F iptables -t nat -X iptables -t mangle -F iptables -t mangle -X iptables -P INPUT ACCEPT iptables -P FORWARD ACCEPT iptables -P OUTPUT ACCEPT iptables -A INPUT -i lo -j ACCEPT iptables -A...

Bhutan ICT

Search This Blog