SQL Server errors: The Primary Filegroup is full “sql server error 1105 the ‘primary’ filegroup is full” or ” Event ID: 1105 MSSQL$SQLEXPRESS – primary… Read More »SQL Server errors: The Primary Filegroup is full
How to Resolve SQL Server Error 5172 – Fix SQL Server Header Error 5172 SQL Server stores its physical data in the primary database file,… Read More »How to Resolve SQL Server Error 5172 – Fix SQL Server Header Error 5172
How to create a subroutine in a stored procedure in SQL Server? You would seen procedures in Oracle that will call a subroutine within the… Read More »how to create a subroutine in a stored procedure in SQL Server?
The Two modes of Database Mirroring in SQL Server for HA/DR Solutions are Synchronous mirroring( High Availability / HA ) Asynchronous mirroring( Disaster Recovery / DR… Read More »SQL Server Database mirroring modes and patner timeout
Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “ when importing a database in your… Read More »SQL Server Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405
SQL Server error 18456 cannot connect – SQL Server 2017 LOGIN FAILED ERROR 18456 Normally error code comes up with a description that gives us… Read More »SQL Server error 18456 cannot connect – SQL Server 2017 LOGIN FAILED ERROR 18456
What is a SQL Server deadlock?What is a SQL Server deadlock? A deadlock in SQL Server occurs when 2 processes/sessions are competing for exclusive access… Read More »How to check Deadlocks in SQL Server
SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified Error Details: this error message is often encountered when connection to a… Read More »SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified
SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server Error Details or symptoms: Can not connect to a SQL… Read More »SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server
SQL Server error 40 could not open a connection to sql server 2016 Error related are: error 40 could not open a connection to sql… Read More »SQL Server error 40 could not open a connection to sql server 2016