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: , , , , , ,
| Displaying entries 1-3 of 293 | Next page »