All geek questions in one place

Primary SQL Server Database

When I used SQL Server 2008, I accidentally ran many scripts in the SQL Server master database.

Could this be problematic? What problems can arise as a result of this?

+4
source share
2 answers

To no avail

System objects are protected from DDL and DML, especially since SQL Server 2005 +

You may have been fortunate enough to overwrite some unprotected objects (a very subtle chance may not have occurred), but this is what we all did ...

+7
source

What scripts do you use against Master db?

This mainly refers to information at the system level about the database and does not contain user data. It must be copied regularly and you are not allowed to change certain parameters (for example, create indexes). See the TechNet Article for more information.

+1
source

Source: https://habr.com/ru/post/1385098/

More articles:


All Articles