Security

SQLServerCentral Article

Removing NT Administrators as Sysadmins

  • Article

By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.

1 (1)

2001-05-25

4,044 reads

Blogs

Checkpoint Analysis: Your Exclusive How-To with XEvents

By

Checkpoints are essential in SQL Server to help with the durability and reliability of...

Goals for 2022

By

I set goals at the beginning of last year, and I’m doing the something...

Daily Coping 14 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Power Query SSIS Error

By water490

Hi I am using SQL Server 2019 and Visual Studio 2019. There are two...

Adding Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Time

SQL Server Dacpac in Azure Data Studio

By Daniel Calbimonte

Comments posted to this topic are about the item SQL Server Dacpac in Azure...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding Time

See possible answers