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

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 | No comments
Used tags: , , , , , , ,

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

Login to the mail server through SSH

[root@mailServer ~]# 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

How to make ASP.NET MVC 4 or 5 work

Read More

Shubham | Saturday 14 March 2015 - 11:39 pm | | Default | No comments
Used tags: , , , , ,

Deleting folders at various locations using Single Script on Windows

One may find a malicious folder created in mulitple domains under various folders/subfolders. It is hard to delete those folders one by one. So you can use the script below to delete those folders recursively

FOR /D /R D:\folder %%X IN (PUMA) DO RMDIR /S /Q "%%X"

In the "%%X" flie, you will need to write the folder name which you want to delete.

D:\folder %%X = path by which you want to search those folders.

Open Notepad and then paste that script and save as a .bat file.

Shubham | Tuesday 23 December 2014 - 11:05 pm | | Default | One comment

Plesk 12 FTP issue- FTP connecting but files not showing

A) We have to add a port on the Plesk server for passive FTP.

[root@plskl1 ~]#  cd /etc/proftpd.d/
[root@plskl1 proftpd.d]# cp -pvf 50-plesk.conf 50-plesk.conf_orig
[root@plskl1 proftpd.d]# vi 50-plesk.conf
Add the line below in the global section-

PassivePorts 57000 58000


B) Setup a custom firewall rule in the Plesk control panel.

Log in as "root" to the server shell over SSH.
Go to Modules > Firewall > Edit Firewall Configuration.
Click Add Custom Rule.

Specify the details below:

1. Rule name - Passive FTP
2. Direction: select Incoming.
3. Action: select Allow.
4. Ports: in the Add Port input box, enter the value 57000-58000. Leave the TCP option selected, and click Add.
5. Click OK.
6. Click Activate, and then click Activate again.

Manoj | Saturday 29 November 2014 - 11:37 am | | Default | No comments
Used tags: , , , , , , ,