SQL Server

white smartphone

SQL Server 101 – Extract Domain Name from Email Address

SQL Server 101 – Get the identity of inserted row

SQL Server Error Msg 6841 – FOR XML could not serialize the data for node ‘%.*ls’ because it contains a character (0x%04X) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.

SQL Server Error Msg 16 – 363

SQL Server Error Msg 14224 – Warning: The server name given is not the current MSX server (‘%s’).

SQL Server Error Msg 9607 – The conversation priority with ID %d is referencing the missing service with ID %d.

SQL Server Error Msg 12618 – The database has too many objects.

SQL Server Error Msg 41345 – The key size limit of %d bytes for nonclustered indexes on memory optimized tables has been exceeded. Please simplify the index definition.

SQL Server Error Msg 46652 – months

SQL Server Error Msg 23506 – A File Backed Item may not contain other Items.

SQL Server Error Msg 15591 – The current security context cannot be reverted using this statement. A cookie may or may not be needed with ‘Revert’ statement depending on how the context was set with ‘Execute As’ statement.

SQL Server Error Msg 33131 – Principal ‘%ls’ has a duplicate display name. Make the display name unique in Azure Active Directory and execute this statement again.

SQL Server Error Msg 15097 – The size associated with an extended property cannot be more than 7,500 bytes.

SQL Server Error Msg 8358 – Event Tracing for Windows (ETW) failed to send event. Event message size exceeds limit. The same send failure may not be reported in the future.

SQL Server Error Msg 13715 – System-versioned table schema modification failed because column ‘%.*ls’ does not have the same XML Schema Collection in tables ‘%.*ls’ and ‘%.*ls’.

SQL Server Error Msg 5844 – User Instances are not supported in this edition of SQL Server.

SQL Server Error Msg 3224 – Cannot create worker thread.

SQL Server Error Msg 1914 – Index cannot be created on object ‘%.*ls’ because the object is not a user table or view.

SQL Server Error Msg 4510 – Could not perform CREATE VIEW because WITH %ls was specified and the view is not updatable.

SQL Server Error Msg 6237 – %s ASSEMBLY failed because method “%.*ls” on type “%.*ls” in assembly “%.*ls” has an invalid custom attribute “%.*ls”.