I am having problems updating a system database in SQL Server 2008. Perhaps there is a different way to do it, but I basically need to change/remove growth restrictions on certain log files for a bunch of databases.
Being lazy, instead of doing this manually for each of the 100 databases using SSMS, I thought I could create a batch query.
First, this information is visible through the
select database_id, name, max_size from sys.master_files
And through this link ("How to update system tables in SQL 2008 R2"), I found out that the relevant database for this view is actually
But even after connecting with
sqlcmd and using
sp_configure 'allow updates', 1, querying the
"Invalid object name 'sys.sysbrickfiles'".
What am I missing here?