Login to Members Area

Choose the service you want to log in
     
24x7x365 Presence
1-888-289-2246
Live Chat

Hosting Blog

 

Check the total number of active connections on the MSSQL Database server

Please use the query below to check the total number of active connections at a time, on the MSSQL database server :-

#################################################################

SELECT
    DB_NAME(dbid) as elitemoving,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
GROUP BY
    dbid, loginame
#############################################################

Shubham | Wednesday 03 June 2015 - 8:30 pm | | Default | No comments
Used tags: , , , , ,

Check space for a particular table in the MSSQL Database

Use <Database Name>
go
sp_spaceused <Table Name>

Note : It works with MSSQL 2000/2005/2008/2012

Shubham | Wednesday 03 June 2015 - 09:43 am | | Default | Two comments
Used tags: , , , , , , ,

Setup a custom header for the H-Sphere Horde webmail client

Login to the mail server through SSH

[[email protected] ~]# vi /hsphere/shared/apache/htdocs/horde/imp/config/header.php

/* Add your custom entries below this line. */
$_header['X-Horde-User'] = Auth::getAuth();

Manoj | Wednesday 03 June 2015 - 07:02 am | | Default | No comments
Used tags: , , , , , ,
| |