Search results

If you are not allowed to perform operations on online status then you have to take your database offline. You have to follow below steps to take your database offline. First login to SQL Server Management Studio. Click on “Database” and then choose particular database which you want to take...

If you have large MSSQL database then you can shrink it to free up some space on SQL server. This shrinking process will remove the unused space from database. You can follow below steps to shrink database via Microsoft SQL Management Studio Login to your SQL server. Now expand databases and...

If you want to login with multiple users n cpanel then you can use cPanel User Manager tool. With this you can create additional user in cpanel to login. Log in to your cPanel account. Click on “User Manager” option under “Preferences” section. You can create new account by clicking on “Add...

If you’ve set up a business website on WordPress, you must be having a contact form on your website so that visitors can get in touch with you if they want. Also, you must be having the Google Map in the contact form that displays your business’s location on the map. But what your contact form...

WooCommerce comes with an in-built search engine that allows users to search for specific products. While it is obviously helpful, there are some clear drawbacks. For example, the default search engine algorithm only looks at the title, content, and experts when returning a search result. It...

You can follow below steps to set the database size limit using SQL Management Studio. Login to your SQL Management Studio. Right click on particular database and choose “Properties” option. A new dialogue will open where you have to choose “Files” option. You have to click on three dots which...

When we try to upgrade your SQL server then sometimes it throws below error. "The report server database is not a supported compatibility level or a connection cannot be established." Sometimes the reason of this error is SQL Server name which was no longer existed in Reporting service...

To access MSSQL server data from PHP scripts you will need to enable two php extensions SQLSRV extension and PDO_SQLSRV extension. You can follow below steps to enable these extensiosn in SQL server 2008. First of all you have to check the compatible version of MSSQL drivers with your PHP, you...

AS we know Windows VPS default port number is 1533but if we want to change the default port then we have to follow below steps: Login to your Windows VPS. Navigate to Start >> All Programs >> Microsoft SQL Server 2008 R2 >> Configuration Tools >> SQL Server Configuration Manager. Now choose...

Here we are assuming that we have hoststud user and we need to change the password of hoststud user with below steps: First login to MS SQL management studio with current password. Now click on “Security >> Logins >> hoststud (user)” under “Object Explorer”. After that right click on user...

You can follow below steps: Login to SQL server database. Now right click on particular database and select “New Query” option. After that run this command: ALTER USER db_user WITH DEFAULT_SCHEMA = dbo; Here db_user is your database username.

You can easily disable PHP scripts from sending emails to, for that it is must to have root access of your server. You can check below steps: Login to WHM. Go to Server Configuration >> Tweak Settings >> Mail Here enable “Restrict outgoing SMTP to root, exim, and mailman (FKA SMTP Tweak)”...

Database user won’t have enough permission to access all the queries so here we can check how to assign permission to MSSQL database user. Login to SQL server Management studio. Now click on particular “Database” and select the table for which you need required permission. After that right...

WordPress is an excellent platform to run a blog and share information and your thoughts with the world. Most WordPress themes allow you to set a featured image and use it for all of the posts. This is great to save time and make your posts look professional. If you don’t know how to set a...

Collation indicates that how character data will be handled. Collation is a configuration level setting. You can follow below steps to change database Collation: Login to RDP server and open SQL Management Studio. Now right click on particular Database name and then click on “Properties”. A...

You can follow below steps to provide db_owner permission to user: Login to server via RDP. Click on Run and then enter “%plesk_dir%admin\conf\”. Now your panel.ini file will be open and you have to add below lines in that file. [databaseManagement] features.roles.mssql.readWrite =...

You can follow below steps to verify MSSQL edition. Login to Windows VPS server. Open “SQL 2019 Configuration Manager” and here click on “SQL Server Services”. Now right click on “SQL Server” and click on “Properties” option. A new dialoge box will open, you have to click on “Advanced” tab...

You can follow below steps to close active MSSQL connections. Login to your server. Go to SQL server management studio. Here you will find new “query” option, where you have to add below query. NOTE: You have to execute below script on MS SQL Server 2012 and higher versions. USE [master]...

Here are the steps to make connection with MS SQL Server 2012: Navigate to Run >> Type SSMS and click on Enter. Now SQL Server Management Studio will open and you have to enter below details in it. Server type: Database Engine Server name: Your_server_IP_address, with port number...

In this article we are going to describe the details of changing recovery model on MS SQL database. You can easily change it through SQL Server Management Studio for your database. There are three recovery models are available. Simple Full Bulk-logged As you know mostly MSSQL database use full...