conLocDb = New System.Data.SqlClient.SqlConnection cmdLocDb = New System.Data.SqlClient.SqlCommand conLocDb.ConnectionString = "Server=" + strLocDbDatasource + ";Database=" + strLocDbDefaultcoll + ";Trusted_Connection=True;" cmdLocDb.CommandTimeout = 0 conLocDb.Open() cmdLocDb.Connection = conLocDb
cmdLocDb.CommandText = "Select IcData From Iscode with(index(Iscode01))" + "Where IcCodt = 'GLSI' " + "and IcCode = '" + Format(intCity, "000") + " SCOASO' " + "and IcLang = 0 " + "and IcAudl = 0" Reader = cmdLocDb.ExecuteReader()
System.Data.SqlClient.SqlException: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN
SET FORCEPLAN
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)