Articles having tag: ERRORS

Retrieving failed records after an SqlBulkCopy exception

How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation

Error Logging to the Windows Event Log using ELMAH

One of the popular libraries for logging of unhandled errors in ASP.NET applications is ELMAH. But there is one thing which ELMAH cannot do - it's a saving to the Event Log. In our project we want that ELMAH stores errors in both database and EventLog.

Drop Failed for Login ‘User xxx’

By Dinesh Asanka

How To Drop Users Who Are Owners or Databases and Jobs When you want to drop users you need to en sure that those users are not owners databases SQL Server agent jobs, otherwise you will be confronted with the below error: To avoid this you will need to change...

A Study on Corruption

By Pablo Aliskevicius

Do you believe that memory corruption will generate an immediate, repeatable crash? Some programmers actually do...

SQL Server Reporting Services – Insufficient Rights Error

By Franco Lopes

Introduction At times when we successfully deploy the reports to the report server and try to view them through report manager we may encounter am insufficient rights error. This article focuses on resolving that error. Solution After deploying the reports...

SQL Server Agent Alter Column Error

By Dinesh Asanka

Replication Agent will fail when attempting to alter a column in the publisher which is part of an index. For example, let's say you have table like following: CREATE TABLE [dbo].[Employees]( [ID] [int] IDENTITY(1,1) NOT NULL, [FirstName] [nvarchar](50)...