Home
Articles
Tips
FAQ
SQL Server FAQs
Categories :
Performance Tuning
|
DBA
|
Developer
|
Errors
Cannot create the clustered index “%.*ls” on view “%.*ls” because the index key includes columns that are not in the GROUP BY clause. Consider eliminating columns that are not in the GROUP BY clause from the index key.
Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns.
CREATE DATABASE permission can only be granted in the master database.
The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.
FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table.
Cannot bulk load. The file “%ls” does not exist.
Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.
Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because key column ‘%.*ls’ is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key or changing column to be precise.
ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.
Page 14 of 83
<
1
...
9
10
11
12
13
14
15
16
17
18
...
83
>
Popular
Latest
Tags
Setting up Transactional Replication in SQL Server 2008 R2.
November 30, -0001
Backing Up a SQL Server Database Directly Onto a Remote Server
November 30, -0001
Recovering a SQL Server Database from Suspect Mode
November 30, -0001
SQL Server T-SQL Tuning - NOT IN and NOT Exists
November 30, -0001
SQL Server T-SQL Tuning - Temp Tables, Table Variables and Union
November 30, -0001
TroubleShooting SQL Server Memory Consumption
April 11, 2018
Tuning your SQL Query – Generating a Proper Execution Plan.
April 10, 2018
Tips For Minimizing Deadlocks in SQL Server
April 8, 2018
Product Review: dbForge SQL Complete
April 7, 2018
SQL Server Hardware Optimization
March 27, 2018
Forum posts...
2008 R2
2012
Agent
AlwaysOn
Analysis Services
Backup
Clustering
Data Mining
deadlock
Denormalization
Disaster Recovery
Email
Entity Framework
Excel
Geo
high availability
Identity
Identity Column
index
Jobs
Log Shipping
mail
Monitoring
Oracle
Query
Query Plan
range
Replication
Reporting Services
Report Manager
Restore
Security
Spatial Data
SSIS
SSMS
SSRS
Stored Procedures
T-SQL
task
Temp Table
Transactional Replication
transactions
TSQL
Tuning
UNION