The following methods of the SQL Hosting Namespace are exposed as Web methods in the Web Service:
Public Method | Description |
---|---|
DropLogin | The DropLogin method removes a SQL login from the server. |
RevokeLogin | The RevokeLogin method revokes access to a Microsoft Windows NT or Windows 2000 account from a server. |
AddUserToRole | The AddUserToRole method adds a user account to a database role. |
RemoveUserFromRole | The RemoveUserFromRole method removes a user from a database role. |
BackupToDisk | The BackupToDisk method backs up a database to a disk file. |
ListBackupInformation | The ListBackupInformation method lists the header information from a backup file. |
RestoreFromDisk | The RestoreFromDisk method restores a database from a disk file. |
GrantDBAcccess | The GrantDBAccess method grants an account access to a database. |
RevokeDBAccess | The RevokeDBAccess method revokes an account's access to a database. |
SetPassword | The SetPassword method sets the password for a SQL account. |
ChangePassword | The ChangePassword method changes the password for a SQL user. |
Note
In the method definitions that follow, the sqlUserName and sqlUserPass parameters must be specified only if you enabled SQL authentication on the SQL server. If you are using Windows authentication and you specify these optional parameters, the request will fail.
Applies To |