trigger

SQLServerCentral Article

Block user objects from being created in a master database

  • Article

Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]

5 (7)

You rated this post out of 5. Change rating

2020-11-10

4,046 reads

Blogs

The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

By

Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...

A Prompt AI Experiment

By

Prompt AI released recently and I decided to try a few things with the...

SQL Server Is Slow (part 1 of 4)

By

How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...

Read the latest Blogs

Forums

statistics callection intervel in query store ?

By rajemessage 14195

Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...

Rounding Off issue in SQL Server

By vikramchander90

I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64)  Microsoft Corporation...

how to get notification that my database has corssed 8gb

By rajemessage 14195

i have sqlexpress on rds, is there any way i can get notifacation that...

Visit the forum

Question of the Day

SQL Server, Heaps and Fragmentation

A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?

See possible answers