Hosting Blog

Tag overview for: 'mssql'

Entries on this site with 'mssql'

• 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 :- #####################################################
• Check space for a particular table in the MSSQL Database
  Use go sp_spaceused Note : It works with MSSQL 2000/2005/2008/2012
• Connecting PHP with the MSSQL database on IIS7
  Sometimes we have to connect PHP with MSSQL - most of the webhosts don't offer this on a shared environment but it is possible to have this facility on a dedicated server
• Steps to install nopCommerce on your domain
  Please follow the steps below to install nopCommerce on your domain. 1- Please upload all the nopCommerce files under the domain root folder. 2- After that, create a subfo
• Steps to restart the MSSQL server services
  You can re-start the SQL server in 3 ways: 1. Management Studio - Open the Management Studio, connect to the server, right-click on the server name and click restart. 2. S
• Steps to reset/change the password of a MSSQL database user in the H-Sphere control panel
  Please follow the steps below: 1) Login to your H-Sphere control panel. 2) Select Database >>> MSSQL >> MSSQL logins. 3) On the next page that appears, you will be able to
• Transferring Data from One Table to Another
  This is to transfer data from one table to another within a single database To transfer all data from one table to another within the same database: "INSERT INTO TABLE2 SE
• Steps to increase the MySQL / MSSQL / PgSQL database quota in H-Sphere
  Please follow the steps below: 1) Login the H-Sphere control panel. 2) Select Database >> MySQL / MSSQL / PgSQL DBs. 3) On the page that appears, you can see the existing
• Problem in installation of DNN 7
  Issue with DNN 7 installation :- Note : I have seen that many users are facing problems with the installation of DotNetNuke Community Edition version 7 (DNN 7). I would li
• How to move your database onto a new server
  1) First take backups of the databases which are in your account. 2) Remove the databases one by one and then disable the MSSQL resource and then again "enable" it. This w
• Alternative IPs with ports to access the MSSQL and MySQL servers through external tools
  Below are the IP addresses and ports for the respective server for external management access :- ======================================================================== C
• How to create the special SQL view for a MSSQL database
  Steps to create the special SQL view for the MSSQL database: 1)? Login to the SQL Server for the database for which the SQL view is to be created. 2)? Open the SQL Server

Related tags

2000, 2000_2005_2008_2012, 2005, 2008, 2012, 7, access, active, alternative, asp.net, change, cluster, connections, controlpanel, data, database, databases, dedicatedserver, dnn, domains, dotnetnuke, external, file, hosting, hsphere, iis, iis7, iisrestart, install, installation, ip, microsoft, msc, mysql, native, nopcommerce, password, pgsql, php, php.ini, plesk, ports, problem, reset, restart, server, servers, services, space, sql, sqlsrv, table, tools, user, vps, windows, windowshosting

Flickr images for 'mssql'