Use Limits

Last updated: 2020-12-31 09:54:34
  • Do not use the Microsoft SQL Server Management Studio (SSMS) to create or delete databases, or create, delete, or modify database accounts, or else the message "An exception occurred while executing a Transact-SQL statement or batch processing" may be prompted. You can perform these operations in the TencentDB for SQL Server console.

  • TencentDB for SQL Server prohibits the sysadmin role by default. If your business has to use this role, please submit a ticket.
    When you try to manage databases in SSMS, the message "You must be a member of the sysadmin role to perform this operation" may be prompted.

  • For dual-server high availability or cluster instances, TencentDB for SQL Server prohibits the sysadmin role by default to avoid the risk of intrusion. If your business has to use this role, please submit a ticket.
    When you try to manage databases in SSMS, the message "You must be a member of the sysadmin role to perform this operation" may be prompted.

  • For basic edition instances, TencentDB for SQL Server allows the admin account to grant a user the permission to use the sysadmin role. This feature is currently in beta. To use it, please submit a ticket.

Was this page helpful?

Was this page helpful?

  • Not at all
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful
Send Feedback
Help