Category: How tos

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 tools have a worked...

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

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 as your Email Server,...