Pages

▼
Apr 2, 2018

Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621).

›
Cannot insert the value NULL into column '' ,   table '' ;    column does not allow nulls . INSERT fails ....
Mar 27, 2018

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dataset name'. (rsErrorExecutingCommand) Arithmetic overflow error converting nvarchar to data type numeric. (Microsoft SQL Server, Error: 8115)

›
Hi There, User reported this error occurring while executing the SSRS report. First thing you need to do is run it from your end. If you ...
Mar 26, 2018

Msg 1776, Level 16, State 0, Line 7 There are no primary or candidate keys in the referenced table '' that match the referencing column list in the foreign key ''.

›
Error: Msg 1776, Level 16, State 0, Line 7 There are no primary or candidate keys in the referenced table '' that match the referen...

OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" returned message "ORA-01033: ORACLE initialization or shutdown in progress". (Microsoft SQL Server, Error: 7303)

›
TITLE: Microsoft SQL Server Management Studio ------------------------------ The test connection to the linked server failed. --------...
1 comment:

Tracking long running SQL Server Agent jobs

›
Hi Guys, It is very important to monitor the long running SQL jobs in production environments and it is cannot miss task of every SQL DBA...
35 comments: