score:0
You should use the SQL profiler to check if the SQL generated against the 2 databases is different.
We have only had two problems where something ran on SQL Server 2005 but not on SQL Server 2000. In both cases it was due to the lack of support for Multiple Active Result Sets (MARS) in SQL Server 2000. In one case it led to locking in the database, in the other case it led to a reduction of performance.
Source: stackoverflow.com
Related Query
- 'Invalid column name [ColumnName]' on a nested linq query
- Linq query giving Invalid column name "xyz" error
- LINQ Query Exception error Invalid column name 'courseId1' EFCore
- Linq query leading to invalid column name SqlException
- How to write LINQ query with column name as parameter still in a type safe way
- add where clauses to linq query with generic column name
- LINQ to SQL: Invalid column name 'DepartureGate', even though the column exists
- LINQ Error Invalid Column Name on Group by sum
- MVC Linq Query with dynamic column name in WHERE clause
- Getting 'Data source is an invalid type' when binding Linq query to Gridview
- Dynamically Set Column Name In LINQ Query
- Invalid column name. The name was never implemented in the code
- (Entity Framework) context.Database.SqlQuery return invalid object name for table but LINQ query works
- How do I create a linq query where the select column name is a variable
- Invalid column sqlException in Linq query after update to Core 2.0
- Nested "from" LINQ query expressed with extension methods
- LINQ query to perform a projection, skipping or wrapping exceptions where source throws on IEnumerable.GetNext()
- Linq To SQL: Sort Query by Arbitrary Property(Column) Name
- LINQ to SQL entity column name attribute ignored with guid primary key
- NHibernate uses wrong column type for LINQ contains query (varchar to nvarchar)
- LINQ group by query using reflected property name
- Dynamic Column Name in LinQ
- C# Linq Column Name as variable
- Get excel cell value with Row and Column Position through open xml sdk linq query
- Is there any way to create a LINQ query as a variable without having the data source (yet)?
- Need a linq to objects query for a nested collection
- Nested LINQ query to select 'previous' value in a list
- How to get Month Name from datetime column in Linq to SQL?
- LINQ member expression getting column name
- LINQ Source Code Available
More Query from same tag
- Updating database without grabbing all the rows
- A more refined version of this LINQ to SQL query
- Return index and object from list on a single query?
- Recursive call to compare object properties
- Entity Framwork Core + Linq: How do I get the entire entity that has the max value? Looking for a more elegant solution
- Visual Studio 2015 using Linq in conditional breakpoint
- Query children and its children until there are no children simplified
- Getting the sum of values in a nested dictionary
- Get results where multiple IDs are present in list (contains all)
- How to convert string array to string in Linq to entities?
- Return back all messages that contain specific users in LINQ
- Linq query to Parse XML
- Group List and Convert to IEnumerable
- SQL Query to delete a comment and all its children in MySQL and Entity Framework
- how to use left join in linq
- How to use LINQ to find a sum?
- Best way to remove duplicates from DataTable depending on column values
- concatenate a MethodCallExpression on MemberExpression
- Linq query to find average time difference per group
- Returning Groupedby distinct linq values
- LINQ to entities : cannot call a method
- How to query in LINQ & Entity Framework the unmapped property
- Trouble with getting linq values to display correctly in view using view model
- Linq to SQL insert stored procedure exclude first row from inserting
- LINQ Query search List within another List and return value
- How to use a LINQ : If there are several min and max values, just remove only one min and max value in List
- how to pass object's property (instead of object) into expression when building Linq2Sql query?
- Cast a column type for sorting in Linq2Sql
- C++ LINQ-like iterator operations
- Linq performance issue in loop
