system-databases Archives

Where are SQL Server catalog views persisted?

By adminPosted on November 3, 2022

Question : It seems that sys catalog views can be found under every database, either built in or user created. […]

By adminPosted on October 18, 2022

Question : I know that system databases hold logins, security info, jobs, etc. Assuming I have backup of all system […]

By adminPosted on September 4, 2022

Question : By chance, I happened to see that the autoclose feature on SQL dbs (I’m using SQL 2008) shouldn’t […]

By adminPosted on August 25, 2022

Question : Hi everyone i am getting an error trying to run the below query ERROR 1067 (42000): Invalid default […]

By adminPosted on June 25, 2022

Question : I know that system databases hold logins, security info, jobs, etc. Assuming I have backup of all system […]

By adminPosted on May 1, 2022

Question : I have just installed a new sql server 2014 server, migrated some databases there and connected some applications […]

By adminPosted on February 28, 2022

Question : I want to check whether all the sysadmin users in my sql server instance have a master database […]

By adminPosted on February 16, 2022

Question : This question already has answers here: hide system databases sql server management studio (2 answers) Closed last year. […]

By adminPosted on December 2, 2021

Question : Is it possible to safely change the drive letter for a volume which holds only system databases? What […]

By adminPosted on October 29, 2021

Question : I simulated a corruption of model database on test environment just for learning purposes. While reading others blogs […]