I just had the same error, and it was down to a corrupted index.
Re-indexing the table fixed the problem.
More Related Contents:
- T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
- Check if table exists in SQL Server
- Sql Server string to date conversion
- Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
- Does T-SQL have an aggregate function to concatenate strings? [duplicate]
- Parameter Sniffing (or Spoofing) in SQL Server
- How to get Time from DateTime format in SQL?
- SQL Server String or binary data would be truncated
- Datatype for storing ip address in SQL Server
- How to change identity column values programmatically?
- Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
- How much size “Null” value takes in SQL Server
- best way to convert and validate a date string
- SQL Server ORDER BY date and nulls last
- How to remove accents and all chars a..z in sql-server?
- Find non-ASCII characters in varchar columns using SQL Server
- WHERE clause on SQL Server “Text” data type
- Aggregate bitwise-OR in a subquery
- SQL server schema and default schema
- Check if a string contains a substring in SQL Server 2005, using a stored procedure
- FOR XML PATH(”): Escaping “special” characters
- Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
- Does query plan optimizer works well with joined/filtered table-valued functions?
- What are row, page and table locks? And when they are acquired?
- @@ERROR and/or TRY – CATCH
- Comma separated results in SQL
- How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
- Query to list all stored procedures
- Can you call a webservice from TSQL code?
- Count number of records returned by group by