In this article, we’re going to look at a number of ways that you can uninstall a Microsoft SQL Server instance on a Windows computer. This article applies to all supported versions: Microsoft SQL Server 2019/2017/2014/2012.
You can change the owner of an MS SQL Server database using SQL Server Management Studio. Connect to your MS SQL instance, create a new query, and run the following Transact-SQL query:
In this article, we will look at several ways to find out the version and edition of the installed Microsoft SQL Server instance. For example, you are a DBA and you have been given the task of scheduling an upgrade on one of the SQL Server hosts. The first thought that comes to your mind is “How do I find out what version and edition of SQL Server is being used on a particular server?”.
The Database Mail component is used in Microsoft SQL Server to send an SMTP notification to an administrator’s mailbox. You can enable and configure Database Mail to receive various email notifications about events on the MSSQL server.