An MPF provider that implements an abstraction layer to the direct T-SQL calls used to create SQL Server databases and other database-related objects through MPS. This Provider has the capability of executing low-level SQL calls without exposing anything outside of a basic call such as ExecuteSQL. Namespaces are layered on top of this Provider to create different layers of functional encapsulation. The higher layers provide support for integration with SQL Resource Manager and other hosting-specific business processes.
The update to this provider now enables you to manipulate database files by calling the ModifyDatabaseFile method to configure elements such as the file growth increment and file size specification. The following list includes most of the methods supported by the SQL Admin Provider:
Adding a SQL user account to the database server.
Adding a user to a database role.
Backing up a database to a file.
Changing the password for a SQL user.
Creating a database on a SQL server.
Deleting a database from a SQL server.
Removing a SQL user account from the database server.
Allowing a user to access a database.
Adding a Microsoft Windows NT/Windows 2003 Server account to the database server.
Listing all of the databases on a particular server.
Listing information about a backup file.
Modifying a database file (data or log) on a SQL Server.
Removing a user from a database role.
Restoring a database from a file.
Removing a user's ability to access a database.
Removing a Windows NT/Windows 2003 Server account from the database server.
Setting the password for a SQL user.
For more information about method call parameters for this component and important issues regarding the T-SQL Provider, see the .
Top of section