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:
Category: SQL Server
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.
Continue reading “Configuring Database Mail in Microsoft SQL Server”
In this article, we’ll look at several ways to uninstall Microsoft SQL Server from a Windows computer.
Continue reading “How to uninstall Microsoft SQL Server on Windows?”