Skip to content

Commit 5032999

Browse files
authored
Merge pull request MicrosoftDocs#85805 from jovanpop-msft/patch-101
moved @query issue on top of known issues
2 parents 4750670 + b545611 commit 5032999

File tree

1 file changed

+6
-5
lines changed

1 file changed

+6
-5
lines changed

articles/sql-database/sql-database-managed-instance-transact-sql-information.md

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -525,6 +525,11 @@ The following variables, functions, and views return different results:
525525

526526
## <a name="Issues"></a> Known issues and limitations
527527

528+
### @query parameter not suppored in sp_send_db_mail
529+
530+
**Date:** April 2019
531+
The `@query` parameter in the [sp_send_db_mail](https://docs.microsoft.com/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql) procedure doesn't work.
532+
528533
### TEMPDB layout
529534

530535
The `tempdb` database is always split into 12 data files and the file structure cannot be changed. The maximum size per file can't be changed, and new files cannot be added to `tempdb`. `Tempdb` is always re-created as an empty database when the instance starts or fails over, and any changes made in `tempdb` will not be preserved.
@@ -553,14 +558,10 @@ SQL Server Management Studio and SQL Server Data Tools might have some issues wh
553558
- Using Azure AD server principals (logins) and users (public preview) with SQL Server Data Tools currently isn't supported.
554559
- Scripting for Azure AD server principals (logins) and users (public preview) isn't supported in SQL Server Management Studio.
555560

556-
### Incorrect database names in some views, logs, and messages
561+
### GUID values shown instead of database names
557562

558563
Several system views, performance counters, error messages, XEvents, and error log entries display GUID database identifiers instead of the actual database names. Don't rely on these GUID identifiers because they're replaced with actual database names in the future.
559564

560-
### Database mail
561-
562-
The `@query` parameter in the [sp_send_db_mail](https://docs.microsoft.com/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql) procedure doesn't work.
563-
564565
### Database Mail profile
565566

566567
The Database Mail profile used by the SQL Server Agent must be called `AzureManagedInstance_dbmail_profile`. There are no restrictions for other Database Mail profile names.

0 commit comments

Comments
 (0)