Mar 23, 2017 · Database administration tools Often, the DBMS software comes with certain tools to help DBAs manage the DBMS. Such tools are called native tools. For example, Microsoft …

Jan 26, 2021 · I am trying to set up Multi Server Administration so that I can easily update multiple instances of the same database across our network with ease. Where I am getting lost is how …

May 5, 2023 · In Sql Server 2000, is it possible to return, via SQL query, a complete list of database roles that exist in a given database? I know it is possible to see these roles by …

Sep 17, 2021 · However, I'm missing many of the SQL Server administration bits that I'm used to seeing in SQL Server Management Studio such as SQL Server Agent Jobs, Security, etc. Am …

Aug 29, 2023 · My attempt to disable it with command ALTER SERVER AUDIT [System Logins] WITH (STATE = OFF) ends up being blocked by something and won't let me delete it. My …

Apr 12, 2023 · macr_s, hi, I am trying to connect with 'connect object explorer' in SQL server express.

What are XA transactions? What are they used for? I want to enable XA transactions for SQL Server 2016 on Windows. Do you know the steps to enable this? Also is there any way to test …

Oct 15, 2010 · The account (windows or sql server) used to remotely connect to the sql server instance needs sysadmin permissions to retrieve the backup junks and store them onto your …

Oct 17, 2016 · What is the difference between Microsoft SQL Server and SQL Server Management Studio (SSMS) and how can I integrate SSMS in Visual Studio 2012 so I can use …

Oct 6, 2014 · What firewall rules are necessary for SQL Server Multi-Server Administration? This is for an environment where database servers are in different 'zones', with all traffic blocked by …