Question : It seems that sys catalog views can be found under every database, either built in or user created. […]
Tag: system-databases
What is the practical purpose of backing up the system databases?
Question : I know that system databases hold logins, security info, jobs, etc. Assuming I have backup of all system […]
When is autoclose OK to be not OK
Question : By chance, I happened to see that the autoclose feature on SQL dbs (I’m using SQL 2008) shouldn’t […]
ERROR 1067 (42000): Invalid default value for ‘uploadedDate’
Question : Hi everyone i am getting an error trying to run the below query ERROR 1067 (42000): Invalid default […]
What is the practical purpose of backing up the system databases?
Question : I know that system databases hold logins, security info, jobs, etc. Assuming I have backup of all system […]
Permissions to be granted to developers to investigate jobs, queries, and packages
Question : I have just installed a new sql server 2014 server, migrated some databases there and connected some applications […]
How to check if sysadmin logins have a master database as a default database in T-SQL?
Question : I want to check whether all the sysadmin users in my sql server instance have a master database […]
SQL statement to hide all system databases in Server from a server login [duplicate]
Question : This question already has answers here: hide system databases sql server management studio (2 answers) Closed last year. […]
Change drive letter (which contains system dbs)
Question : Is it possible to safely change the drive letter for a volume which holds only system databases? What […]
What is difference between starting Instance with -T3608 and with -f?
Question : I simulated a corruption of model database on test environment just for learning purposes. While reading others blogs […]