SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified

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 SQL Server is tried and don’t know where to start to solve the problem. We get this error message only when we are trying to connect to a SQL Server…

SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server

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 server and you get a error a network-related or instance-specific error occurred while establishing a connection to sql server This error is seen in SQL Express installation as its installed…

SQL Server error 40 could not open a connection to sql server 2016

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 server named pipes provider could not open a connection to sql server 53 invoke sqlcmd provider named pipes provider error 40 could not open a connection to sql server named…

Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘

Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘ Details of Error: This error message occurs if we use GETDATE() like function as a parameter to Stored Procedure or Function Statement.…

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated Details of Error: String or binary data would be truncated. The statement has been terminated. This error message below occurs when part data is been truncated while loading a table. Actual error message: Msg…

Microsoft SQL Server Error: 53 or Microsoft SQL Server Error: 11001 or SQL Server error 53 and 40. SQL server error 53 and 17

Active Connections to SQL Server Database 2008, 2005 by Application or User

To Check Active Connections to SQL Server Database grouped by User Below query is very helpful in finding the Total CPU usage, Waiting Time, Elapsed Time, Number of Reads, Number of Writes, connections grouped by Login name related which are active in SQL Server Database. To check Active Connections to SQL Server Database grouped by…

How to check Log shipping status in SQL Server 2008

How to check Log shipping status in SQL Server 2008: SQL server recovery model has to be Full recovery mode for log shipping which allows log backups. sql server database log backup is shiped and restore from one server or Primary to another server Secondary/destination server. Reports can be run from Secondary server for business…

ASYNC_NETWORK_IO Waits SQL Server 2005 2008 2012 2014 2016

Adding Article to Transactional Replication Publisher without Snapshot Re-initialisation

Add article to Transactional Replication without Snapshot Re-initialisation To add a new article to a publisher efficiently without reinitializing whole replication but running the below scripts/procedure can be done without whole snapshot to be run again. This method only snapshots the new article added to the publisher. The Steps needs to be followed in same…