This procedure modifies settings for a specified database.
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.
The Lightweight Directory Access Protocol (LDAP) path of the
The name of the database to be modified.
Logical name of the file.
The size to be allocated to the resource.
User name for connecting to the SQL Server via SQL
Authentication. If this node is present, the connection will be
made via SQL Authentication rather than Windows Authentication. The
existence of this node also requires that the <sqlUserPass/>
The password for connecting to the SQL Server via SQL
Authentication, using the username indicated by
<sqlUserName/>. If the <sqlUserName/> node is not
present, this node is ignored.