mssql database

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...

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 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...

Orphaned users can be mostly created while database migration when the database user is available on server but its login doesn’t available on server. You can run below query to check the orphaned users in MSSQL. USE USER DATABASE EXEC SP_CHANGE_USERS_LOGIN ‘REPORT’ GO We can fix this issue...

You can follow below steps to check the active connections of MSSQL database. Login to Windows server. Open SQL Management studio. Here right click on particular database and click on execute. Now you have to run the select query to check active database connection. SELECT DB_NAME(dbid) AS...

The SQL Server Error 35206 is common among server with high transactions. Most admins report of this error when transitioning from a Linux-based Oracle database to Microsoft’s SQL databases. The error dampens the entire process and creates unwanted delays. You’ll most likely receive the...

How to fix database MSSQL server error 4060 ? If you’re using a SQL database, then you might encounter the SQL Error 4060 after a database migration. This is one of the many SQL Errors admin have to deal with. SQL Error 4060 is a server-side error. Therefore, the client can do little about it...

Steps to shrink your MSSQL database log file Transaction log file (.IDF) keeps on increasing at all instances. When it exceeds after certain limit then you have to shrink the transaction log file like the database. There is a common question why the log file transaction keeps on increasing...