You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/relational-databases/errors-events/database-engine-events-and-errors.md
+13-13Lines changed: 13 additions & 13 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "Database Engine Events and Errors | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: 01/09/2019
4
+
ms.date: 01/11/2019
5
5
ms.prod: sql
6
6
ms.reviewer: ""
7
7
ms.technology: supportability
@@ -1030,10 +1030,10 @@ The table contains error message numbers and the description, which is the text
1030
1030
| 2117 | 16 | No | Cannot %S_MSG INSTEAD OF trigger '%.*ls' on %S_MSG '%.*ls' because the %S_MSG has a FILESTREAM column. |
1031
1031
| 2201 | 16 | No | %sDerivation from "anySimpleType" by restriction is not permitted, and derivation by restriction from a type derived from "anySimpleType" by extension is allowed only if no constraining facets are specified. |
1032
1032
| 2202 | 16 | No | %sAn error has occurred while compiling the query. To obtain more detailed information about the error, the query must be run by a user with EXECUTE permissions on the xml schema collection used in the query. |
1033
-
| 2203 | 16 | No | %sOnly 'https://www.w3.org/2001/XMLSchema#decimal?', 'https://www.w3.org/2001/XMLSchema#boolean?' or 'node()*' expressions allowed as predicates, found '%ls' |
1034
-
| 2204 | 16 | No | %sOnly 'https://www.w3.org/2001/XMLSchema#boolean?' or 'node()*' expressions allowed in conditions and with logical operators, found '%ls' |
1033
+
| 2203 | 16 | No | %sOnly 'http://www.w3.org/2001/XMLSchema#decimal?', 'http://www.w3.org/2001/XMLSchema#boolean?' or 'node()*' expressions allowed as predicates, found '%ls' |
1034
+
| 2204 | 16 | No | %sOnly 'http://www.w3.org/2001/XMLSchema#boolean?' or 'node()*' expressions allowed in conditions and with logical operators, found '%ls' |
1035
1035
| 2205 | 16 | No | %s"%ls" was expected. |
1036
-
| 2206 | 16 | No | %sNamespace prefix 'xml' can only be associated with the URI 'https://www.w3.org/XML/1998/namespace' and this URI cannot be used with other prefixes. |
1036
+
| 2206 | 16 | No | %sNamespace prefix 'xml' can only be associated with the URI 'http://www.w3.org/XML/1998/namespace' and this URI cannot be used with other prefixes. |
1037
1037
| 2207 | 16 | No | %sOnly non-document nodes can be inserted. Found "%ls". |
1038
1038
| 2208 | 16 | No | %sThe URI that starts with '%ls' is too long. Maximum allowed length is %d characters. |
1039
1039
| 2209 | 16 | No | %sSyntax error near '%ls' |
@@ -1116,7 +1116,7 @@ The table contains error message numbers and the description, which is the text
1116
1116
| 2309 | 16 | No | %sThe value of "%ls" is not a valid number. |
1117
1117
| 2310 | 16 | No | %sThe attribute "%ls" is declared more than once. |
1118
1118
| 2311 | 16 | No | %sThe attribute "%ls" is declared more than once within "%ls". |
1119
-
| 2312 | 16 | No | %sThe value of attribute '%ls' does not conform to the type definition 'https://www.w3.org/2001/XMLSchema#%ls': '%ls'. |
1119
+
| 2312 | 16 | No | %sThe value of attribute '%ls' does not conform to the type definition 'http://www.w3.org/2001/XMLSchema#%ls': '%ls'. |
1120
1120
| 2313 | 16 | No | %sThe attribute "%ls" cannot have a value of "%ls". |
1121
1121
| 2314 | 16 | No | %sThe attribute "%ls" cannot have a negative value. |
1122
1122
| 2315 | 16 | No | %sThe attribute "%ls" should have a string value. |
@@ -3039,7 +3039,7 @@ The table contains error message numbers and the description, which is the text
3039
3039
| 6869 | 16 | No | Attempt to redefine namespace prefix '%.*ls' |
3040
3040
| 6870 | 16 | No | Prefix '%.*ls' used in WITH XMLNAMESPACES clause contains an invalid XML identifier. '%c'(0x%04X) is the first character at fault. |
3041
3041
| 6871 | 16 | No | Prefix '%.*ls' used in WITH XMLNAMESPACES is reserved and cannot be used as a user-defined prefix. |
3042
-
| 6872 | 16 | No | XML namespace prefix 'xml' can only be associated with the URI https://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes. |
3042
+
| 6872 | 16 | No | XML namespace prefix 'xml' can only be associated with the URI http://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes. |
3043
3043
| 6873 | 16 | No | Redefinition of 'xsi' XML namespace prefix is not supported with ELEMENTS XSINIL option of FOR XML. |
3044
3044
| 6874 | 16 | No | Empty URI is not allowed in WITH XMLNAMESPACES clause. |
3045
3045
| 6875 | 16 | No | URI '%.*ls' used in WITH XMLNAMESPACES is invalid. '%c'(0x%04X) is the first character at fault. |
@@ -4171,11 +4171,11 @@ The table contains error message numbers and the description, which is the text
4171
4171
| 9304 | 16 | No | %sThis version of the server only supports XQuery version '1.0'. |
4172
4172
| 9305 | 16 | No | %sOnly type names followed by '?' are supported in the target of 'instance of'. |
4173
4173
| 9306 | 16 | No | %sThe target of 'replace value of' cannot be a union type, found '%ls'. |
4174
-
| 9308 | 16 | No | %sThe argument of '%ls' must be of a single numeric primitive type or 'https://www.w3.org/2004/07/xpath-datatypes#untypedAtomic'. Found argument of type '%ls'. |
4175
-
| 9309 | 16 | No | %sThe target of 'replace value of' cannot be 'https://www.w3.org/2001/XMLSchema#anySimpleType', found '%ls'. |
4174
+
| 9308 | 16 | No | %sThe argument of '%ls' must be of a single numeric primitive type or 'http://www.w3.org/2004/07/xpath-datatypes#untypedAtomic'. Found argument of type '%ls'. |
4175
+
| 9309 | 16 | No | %sThe target of 'replace value of' cannot be 'http://www.w3.org/2001/XMLSchema#anySimpleType', found '%ls'. |
4176
4176
| 9310 | 16 | No | %sThe 'with' clause of 'replace value of' cannot contain constructed XML. |
4177
4177
| 9311 | 16 | No | %sHeterogeneous sequences are not allowed in '%ls', found '%ls' and '%ls'. |
4178
-
| 9312 | 16 | No | %s'%ls' is not supported on simple typed or 'https://www.w3.org/2001/XMLSchema#anyType' elements, found '%ls'. |
4178
+
| 9312 | 16 | No | %s'%ls' is not supported on simple typed or 'http://www.w3.org/2001/XMLSchema#anyType' elements, found '%ls'. |
4179
4179
| 9313 | 16 | No | %sThis version of the server does not support multiple expressions or expressions mixed with strings in an attribute constructor. |
4180
4180
| 9314 | 16 | No | %sCannot implicitly atomize or apply 'fn:data()' to complex content elements, found type '%ls' within inferred type '%ls'. |
4181
4181
| 9315 | 16 | No | %sOnly constant expressions are supported for the name expression of computed element and attribute constructors. |
@@ -4195,7 +4195,7 @@ The table contains error message numbers and the description, which is the text
4195
4195
| 9330 | 16 | No | %sOnly comparable types are allowed in '%ls', found '%ls'. |
4196
4196
| 9331 | 16 | No | %sSyntax error near '%ls', expected '%ls' or '%ls'. |
4197
4197
| 9332 | 16 | No | %sSyntax error near '%ls', expected 'where', '(stable) order by' or 'return'. |
4198
-
| 9333 | 16 | No | %s'//' followed by 'self', 'parent' or 'descendant-or-self' axes is not supported when it encounters simple typed or 'https://www.w3.org/2001/XMLSchema#anyType' elements, found '%ls'. |
4198
+
| 9333 | 16 | No | %s'//' followed by 'self', 'parent' or 'descendant-or-self' axes is not supported when it encounters simple typed or 'http://www.w3.org/2001/XMLSchema#anyType' elements, found '%ls'. |
4199
4199
| 9334 | 16 | No | %sThe 'form' attribute cannot be specified on a local attribute or element definition that has the 'ref' attribute. Location: '%ls'. |
4200
4200
| 9335 | 16 | No | %sThe XQuery syntax '%ls' is not supported. |
4201
4201
| 9336 | 16 | No | %sThe XML Schema syntax '%ls' is not supported. |
@@ -4265,10 +4265,10 @@ The table contains error message numbers and the description, which is the text
4265
4265
| 9461 | 16 | No | XML %ls starting with '%.*ls' is %d characters long, which exceeds the limit. Maximum allowed length is %d characters. |
4266
4266
| 9462 | 16 | No | XML parsing: line %d, character %d, not all chunks of value have been read |
4267
4267
| 9463 | 16 | No | XML parsing: line %d, character %d, xml:space has a non-legal value |
4268
-
| 9464 | 16 | No | XML parsing: line %d, character %d, XML namespace prefix 'xml' can only be associated with the URI https://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes. |
4268
+
| 9464 | 16 | No | XML parsing: line %d, character %d, XML namespace prefix 'xml' can only be associated with the URI http://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes. |
4269
4269
| 9465 | 16 | No | XML parsing: line %d, character %d, XML namespace prefix 'xmlns' is reserved for use by XML. |
4270
-
| 9466 | 16 | No | XML parsing: line %d, character %d, XML namespace xml namespace URI (https://www.w3.org/XML/1998/namespace) must be assigned only to prefix 'xml'. |
4271
-
| 9467 | 16 | No | XML parsing: line %d, character %d, xmlns namespace URI (https://www.w3.org/2000/xmlns/) is reserved and must not be used. |
4270
+
| 9466 | 16 | No | XML parsing: line %d, character %d, XML namespace xml namespace URI (http://www.w3.org/XML/1998/namespace) must be assigned only to prefix 'xml'. |
4271
+
| 9467 | 16 | No | XML parsing: line %d, character %d, xmlns namespace URI (http://www.w3.org/2000/xmlns/) is reserved and must not be used. |
4272
4272
| 9480 | 16 | No | XML parsing: line %d, character %d, unsupported xml |
4273
4273
| 9500 | 16 | No | The data type '%.*ls' used in the VALUE method is invalid. |
4274
4274
| 9501 | 16 | No | XQuery: Unable to resolve sql:variable('%.*ls'). The variable must be declared as a scalar TSQL variable. |
Recommendations for achieving the very fast query performance that columnstore indexes are designed to provide.
@@ -135,7 +136,7 @@ FROM FactResellerSalesXL_CCI
135
136
```
136
137
137
138
### String predicate pushdown
138
-
When designing a data warehouse schema, the recommended schema modeling is to use star-schema or snowflake schema consisting of one or more fact tables and many dimension tables. The [fact table](https://en.wikipedia.org/wiki/Fact_table) stores the business measurements or transactions and [dimension table](https://en.wikipedia.org/wiki/Dimension_table) store the dimensions across which facts need to be analyzed.
139
+
When designing a data warehouse schema, the recommended schema modeling is to use star-schema or snowflake schema consisting of one or more fact tables and many dimension tables. The [fact table](https://wikipedia.org/wiki/Fact_table) stores the business measurements or transactions and [dimension table](https://wikipedia.org/wiki/Dimension_table) store the dimensions across which facts need to be analyzed.
139
140
140
141
For example, a fact can be a record representing a sale of a particular product in a specific region while the dimension represents a set of regions, products and so on. The fact and dimension tables are connected through a primary/foreign key relationship. Most commonly used analytics queries join one or more dimension tables with the fact table.
In the [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Management Objects (SMO) hierarchy, indexes are represented by the <xref:Microsoft.SqlServer.Management.Smo.Index> object. The indexed columns are represented by a collection of <xref:Microsoft.SqlServer.Management.Smo.IndexedColumn> objects represented by the <xref:Microsoft.SqlServer.Management.Smo.Index.IndexedColumns%2A> property.
@@ -203,7 +204,7 @@ Public Class A
203
204
Dim tb As New Table(db1, "XmlTable3")
204
205
205
206
Dim mySample As New XmlSchemaCollection(db1, "Sample4", "dbo")
0 commit comments