Profile cover photo
Profile photo
Swapna S
6 followers
6 followers
About
Posts

Post has attachment
Public
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 . [SQLSTATE 23000] ( Error
515 )   The statement has
been terminated . [SQLSTATE 01000] ( Error
3621 ). Cause : This error occurs when you try to insert...
Add a comment...

Post has attachment
Public
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 are able to reproduce the error then open the report in Report Builder or VS to debug. Below steps show how to do it in ...
Add a comment...

Post has attachment
Public
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 referencing column list in the foreign key ''. This error occurred when trying to create the FK from table2 (column1) with reference ...
Add a comment...

Post has attachment
Public
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. ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Mi...
Add a comment...

Post has attachment
Public
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. I use below query to catch the long running jobs. SQL job is created with this query and scheduled to run every 3hrs. ...
Add a comment...

Post has attachment
Public
SQL Server (Starting with 2016): How Many Foreign Key Can You create on a Table?
A table can reference a maximum of 253 other tables and columns as foreign keys (outgoing references).  SQL Server 2016 increases the limit for the number of other table and columns that can reference columns in a single table (incoming references), from 25...
Add a comment...

Post has attachment
Public
Installing Oracle Provider for OLEDB in SQL Server
Initially we do not see this provider in the drop down, which
we open, create new linked server window. We can find the provider in
the below link, please find the appropriate version your system need. http://www.oracle.com/technetwork/database/enterprise-e...
Add a comment...

Post has attachment
Public
SQL Server: Database compatibility, what it is exactly!
Database compatibility is the feature of database comes along with the SQL server version. Database supports the new features of the current version and the previous versions with the help of backward compatibility of SQL Server. For example AlwaysOn, Repli...
Add a comment...

Post has attachment
Public
SQL Server: The database principal owns a database role and cannot be dropped. (Microsoft SQL Server, Error: 15421)
Error while deleting the orphan user. TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for User ''.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0...
Add a comment...

Post has attachment
Public
SQL Server: Error while alter the schema owner to dbo
This issue occurred during my orphan users  cleanup. ( https://sqlserverrandoms.blogspot.com/2018/03/cleaning-up-orphan-users-and-finding.html ) While deleting one of the orphan below exception happened.  Msg 15138, Level 16, State 1, Line 6 The database pr...
Add a comment...
Wait while more posts are being loaded