Knowledgebase

This video tutorial catagory include videos about MSSQL related guides and tips.

Yes, you can. But in that case, you will need to have both your PC on different network. It won't...

Shared/Reseller Hosting: In Windows Shared/ Windows Reseller hosting you can create MS SQL...

If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to...

Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012. We don't...

Following is a brief comparison between MSSQL Server 2014 Express Edition and MSSQL Server 2014...

Following is a brief comparison between MSSQL Server 2016 Express Edition and MSSQL Server 2016...

Windows Shared HostingWe do not offer SQL server schedule job in our Windows shared hosting...

One of our Windows VPS customers received the following error while connecting to the MSSQL...

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...

Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities....

The MSSQL processes will give you the data of the load running on your database server. This is...

Open SQL Server Management Studio (SSMS), and connect to a server instance. Expand the...

If the Microsoft SQL server is overloaded due to SQL service, you will find the problematic...

MySQL and MariaDB are popular database management systems that various applications and websites...

Importing a large MySQL databasе into cPanеl can bе challеng duе to filе sizе limitations in...

Please refer to the following steps to close active connections in the MS SQL server. Open the...

This article will guide you on how to connect to MS SQL Server 2008 from SQL Server Management...

This article will guide you on how to connect to MS SQL Server 2012 from SQL Server Management...

All you have to do is to take a full backup of your database on your local machine and place a...

To take MS SQL database backup, first you need to connect to MS SQL Server through SQL Server...

This article describes how to change the recovery model of an MS SQL database through SQL Server...

This article will assist you to create MS SQL database through SQL Server Management Studio....

Error Message Could not allocate space for object 'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in...

MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds) a remote...

If you have chosen MS SQL Server to be installed in Windows VPS while placing an order, you'll...

Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if...

This article will assist you to shrink/truncate the transaction logs of the database in MS SQL...

SQL Server Management Studio provides tools for configuring, monitoring, and managing SQL Server...

Please refer to the following steps to verify the exact MSSQL edition. We have prepared these...

From Plesk version 12, MSSSQL users created from the Plesk panel will not have the db_owner...

We can restrict SQL database users to fire some critical queries, e.g., Update, Delete, etc.,...

Collation is a configuration-level setting in MSSQL. It directs how the character data will be...

Login to SQL Server with Database User Credential. Right Click on Database and select New...

The following article will guide you to change the database language in MS SQL 2012 server. 1....

The following tutorial will guide you to reset the MS SQL server sa user password. We assume that...

In Windows VPS, 1533 is the default port for MSSQL Server. Following steps will guide you to...

MSSQL Server provides a feature to restrict your Database access for users. It can be performed...

To check active database connection in the MS SQL server please follow the below steps. Step 1:...

Recently, we faced strange issue wherein one of our customers was capturing error messages coming...

If you have a Windows VPS / Dedicated server with MSSQL Server and WebsitePanel installed, you...

Login into the SSMS with the respective user Go to the Object Explorer section and click on...

In this article, we will guide you on creating a login, user, role, and assign permission from...

A BACPAC, short for Backup Package, is a comprehensive file format that encapsulates both the...

The Microsoft Drivers for PHP are the PHP extensions that allow for the reading and writing of...

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

If someone tries to connect to a computer running MS SQL but forgets to specify the login...

Sometimes you receive the following error while resetting the MS SQL sa password via SQL...

You may receive the below error while installing the SQL server on your windows system. This...

Orphaned user in MSSQL means that a user who is present at the database level but the relevant...

BACPAC (Backup package) contains schema and data for the SQL Server database. We can export the...

Microsoft® SQL Server® 2016 is the latest version of Microsoft's relational database management...

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...

In Microsoft SQL Server, a Linked Server allows you to connect and query remote data from within...

ODBC(Open Database connectivity) is used to create dynamic web apps. Sometimes these apps fail...

This article will guide you on how to restore MSSQL database from SQL Server Management Studio....

Rеstoring a Microsoft SQL Sеrvеr databasе from a highеr vеrsion to an oldеr vеrsion can bе a...

Please refer to the following steps to set the database size limit for Microsoft SQL Server....

Following are the steps to set up database mirroring using certificate-based authentication. You...

Important Note: We don't recommend to shrink your database. You can involve your Database...

Occasionally, there are scenarios where you need to relocate database files physically. However,...

If you have installed the MSSQL Evaluation edition, you can easily upgrade it to the Developer...

A slow and long-running SQL query execution consumes many processors, memory, and disk of your...

Yes, if you acquire a Windows VPS, you gain Remote Desktop Protocol access, enabling you to...

Depending on SQL server edition and environment, there will be limitation. Please refer to the...

MS-Access Database Connection ASP code: DSN Less Connection: Dim strConnSet strConn =...

This error occurs because the field name that you used in the query syntax does not exist. Often...

Microsoft SQL Server 2012 Express is a feature-rich yet FREE data management system. It is far...

The SQL Server 2014 Express is yet another feature-rich data management system from Microsoft....

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...

This error usually occurs when you try to insert or update data in MS Access database i.e. you do...

We may receive following error when login to our database from SQL Server Management Studio (2008...

You may receive the below image while you access the server configuration manager on your windows...

Mixed mode is an SQL Authentication mode that allows users to access the SQL Server instance...

SQL Server is a relational database management system developed by Microsoft. It comes in...

It is recommended that you take the help of your web developer to define the database connection...

'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder for .mdb...

You may receive the following error while installing MSSQL 2017 on Windows 2012 R2 Server VPS or...