SQL Server Errors

Cannot drop a default constraint by DROP DEFAULT statement. Use ALTER TABLE to drop a constraint default.

Error Message:Msg 3717, Level 16, State 1, Line 1Cannot drop a default constraint by DROP DEFAULT statement. Use ALTER TABLE to drop a constraint default. Severity level:16. Description:This error message appears when you try to DROP a column-level DEFAULT constraint with a DROP DEFAULT statement. Consequences:The T-SQL statement can be parsed, but causes the error […]

Defaults cannot be created on columns of data type timestamp. Table ‘%.*ls’, column ‘%.*ls’.

Error Message:Msg 1755, Level 16, State 0, Line 1Defaults cannot be created on columns of data type timestamp. Table ‘%.*ls’, column ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a DEFAULT constraint for a column of the type timestamp. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

Conflicting locking hints specified

Error Message:Msg 1047, Level 15, State 1, Line 3Conflicting locking hints specified. Severity level:15. Description:This error message appears when you try to use incompatible locking hints. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 are generated by the user and can be fixed by the SQL […]

Invalid use of side-effecting or time-dependent operator in ‘%s’ within a function.

Error Message:Msg 443, Level 16, State 1, Procedure udfMyFunc, Line 5Invalid use of side-effecting or time-dependent operator in ‘%s’ within a function. Severity level:16. Description:This error message appears when you try to use an nondeterministic operator or an operator with side-effects within a user-defined function. Consequences:The T-SQL statement can be parsed, but causes the error […]

Line %d: Specified scale %d is invalid.

Error Message:Msg 1002, Level 15, State 1, Line 3Line %d: Specified scale %d is invalid. Severity level:15. Description:This error message appears when you try to specify an invalid value in a DECIMAL data type declaration. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 are generated by […]

Cannot open backup device ‘%ls’. Operating system error %ls.

Error Message:Msg 3201, Level 16, State 1, Line 1Cannot open backup device ‘%ls’. Operating system error %ls. Severity level:16. Description:This error message appears when you try to backup a database to a backup device that cannot be opened. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level […]

The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

Error Message:Msg 4208, Level 16, State 1, Line 1The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. Severity level:16. Description:This error message appears when you try to backup the log of a database that is in “Simple” recovery mode. Consequences:The […]

Each file size must be greater than or equal to 512 KB

Error Message:Msg 5174, Level 16, State 1, Line 1Each file size must be greater than or equal to 512 KB. Severity level:16. Description:This error message appears when you try to provide a file size less than 512 KB in a CREATE/ALTER DATABASE command. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

System databases master, model, msdb, and tempdb cannot be detached.

Error Message:Msg 7940, Level 16, State 1, Line 1System databases master, model, msdb, and tempdb cannot be detached. Severity level:16. Description:This error message appears when you try to detach one of SQL Server own system databases. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level 16 are […]

Error: SQL Server has encountered xxxx occurrence(s) of IO requests taking longer than 15 seconds to complete on file

Problem: On our SQL Server environment recently we are getting the following entries:“SQL Server has encountered 5877 occurrence(s) of IO requests taking longer than 15 seconds to complete on file “How serious is this? What would the steps be to troubleshoot this? Solution: From the outlook of the error it is clear that the Server […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |