Find Server Information by TSQL script

Display all Server Information by using TSQL script The below listed all SQL Server Information can be retrieved by a TSQL script. But before that, we need to Enable xp_cmdshell…

Read Full
31 views 17:48 0 Comments

Backup & Restore Multiple Databases

Backup and restore all databases from an old SQL server and restore it on new SQL server. The number of databases are approx 99+. Let's try to make backup and…

Read Full
46 views 09:40 0 Comments

Fixing Orphaned Users in SQL Server

Introduction In easier terms, a 'Login' is like an entry pass to get into a SQL Server, and a 'User' is like an entry pass to access a specific database…

Read Full
53 views 04:07 0 Comments

Find cached execution plan

An execution plan, simply put, is the result of the query optimizer's attempt to calculate the most efficient way to implement the request represented by the T-SQL query you submitted. Execution plans can tell you how a query will…

Read Full
33 views 19:04 0 Comments

Configuring Database Mail in SQL Server

SQL Server Database Mail facilitates email communication directly from the database engine. This capability is critical for transmitting query results, error alarms, and reports, as well as keeping you informed…

Read Full
54 views 06:32 3 Comments

SQL Network Interfaces, error: 26

SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often see “SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified” error message while connecting to SQL Server. Steps to…

Read Full
43 views 04:21 0 Comments