The ModifyDatabaseFile method modifies a database file (data or log) on a SQL Server.
The ModifyDatabaseFile method has no transaction rollback support.
Per Microsoft SQL Server documentation, only one of these values should be changed at a time.
There are T-SQL issues when modifying database attributes with the ModifyDatabaseFile method.
In SQL Server 2005 Standard Edition with SP2, T-SQL calls that alter the file growth size to unrealistic numbers, such as growing the log file of the database by 3TB, will result in a log file growth of 1MB. This is an inconsistency of the SQL Server since the SQL Admin Provider is merely passing through the statements to the server. Also, this is not an API issue, rather it is the result of the server not processing the "corrupt" value.
Values of file growth size over 1 TB will not generate an error message, but rather will report a completed transaction and leave the log file growth at the default of 1MB.
Example XML Request
The following is an example of an XML request for the ModifyDatabaseFile method:
Example XML Response
The following is an example of an XML response for the ModifyDatabaseFile method: