When your database or transaction log grows to fill all the space allocated with create database, you can use alter database to add storage. You can add space for database objects or the transaction log, or both. You can also use alter database to prepare to load a database from backup.
Permission for alter database defaults to the Database Owner, and is automatically transferred with database ownership. For more information, see “Changing database ownership”. alter database permission cannot be changed with grant or revoke.
alter database for proxy update drops
all proxy tables in the proxy database.
