SQL Comparison Tool

Best free and paid SQL Comparison Tools

Issue There is frequently the need to think about the two information and database structures from two databases either on a similar server or on various servers. Most sql comparison…

Read more »

How to downgrade SQL Server 2017 database to SQL Server 2005/2008/2012/2014/2016

It’s not possible to downgrade a database on SQL Server. However, there are several workarounds which you can use to migrate or downgrade SQL Server 2017 database to lower version of SQL Server database. One of the most popular (and easiest) method for doing this is ‘Script entire database and all database object’.

Read more »
How to send email from SQL Server

How to send email from SQL Server

Email functionality is integrated in almost every website and application now a days. Microsoft SQL Server also supports sending emails. Even though it is not recommended to use SQL Server…

Read more »

Find Version of SQL Server

There are various ways to find out version of SQL Server being used. I will list two of them which are commonly used.

Read more »