Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

Home >Search > Articles & Samples > SQL Server > Error Handling

What's New - What's Hot
Microsoft Sql Server, Error : 10061  Version: 0.00     Price: $0.00  
Total Hits: 89  |  Today: 0Author: Dhananjay Kumar      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is very common error and can be caused due to many reasons. The way I solved it

1. Go to Start
2. Type Run
3. Type Services.msc
4. Then locate for SQL Server instance you are trying to connect. In my case this is SQL TEST. Right click and select Properties...

Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: Neeraj Nagpal      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the first article in the series, I explained the setup of a report that ensures that backups are happening as per the backup policy. In this article, I will explain how to monitor SQL Server errorlog, leveraging the capabilities of DTS. Just in case you have not read the first article, in this series, I am covering how to monitor three elements of Microsoft SQL Server:
1. Backup SLA (Service Level Agreement) Report — to find any database that has not been backed up in the last 24 hours....

Utility Belt: Error Handling Basics Demo     
Total Hits: 125  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.
The Search Code below deliberately contains bad SQL and connection info to indicate the way error handling is displayed when the Utility Belt library encounters runtime errors....

Fix: MS-SQL Server Restore Failed  Version: 1     Price: $0.00 / Free Trial  
Total Hits: 169  |  Today: 0Author: Ahsan Khan      Rating:  
Read Reviews | Write Review |  Your Rating: 

How to fix MS Sql Server Restore Failed Error....

Error - Windows cannot access the specified device, path or file.     
Total Hits: 249  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Every time I try to execute an executable (*.exe) file that I copied from a Windows 2003 File Server to my SQL Server running Windows 2003, I am unable to access the file. It works without a problem on the original Windows 2003 File Server and I am able to validate that nothing has changed. I just keep getting this error message - Windows cannot access the specified device, path or file. How can I resolve this issue? What am I doing wrong? I am just copying a file to my SQL Server....

Understanding Error Handling     
Total Hits: 306  |  Today: 0Author:      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is an interesting to talk. I've not been a big supporter of what happens in our error handling in SQL. And there are quite a lot of void spaces that needs to be addressed in the SQL documentation for the same. Here are some of the tips you can use in your application code. I know this is not an exhaustive analyssis of Error Handling in SQL. But here I do have something learn't the hard way....

SQL Server Trusted Error     
Total Hits: 5225  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Shows you how to configure to provent you from getting the following error when trying to connect to SQL Server using a Trusted Connection: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."...

Error Alert Script     
Total Hits: 536  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

To prevent databases from running into serious problems, DBAs typically setup alerts for specific errors; for example, the error "table corrupt" could lead to "database corrupted". The problem is there are a large number of alerts for the "table corrupt" error message (about 40), and while you probably don't want to set all 40 of the alerts on your server, you don't want to miss any of them either. The solution is to simply set this alert job instead....

PRB: SQL Server 2000 Installation or Local Connections Fail with "SSL Security error :ConnectionOpen (SECDoClientHandshake())" Error Message (Q309398)     
Total Hits: 1321  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you try to install Microsoft SQL Server 2000 on a computer that has certificates, installation can fail and you may receive the following error message:
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).SQL Server configuration failed.
When you add certificates to a server that already has SQL Server installed, local connections fail....

Error Handling Implementation in SSRS  Version: 0.00     Price: $0.00  
Total Hits: 19  |  Today: 0Author: V-rajbog      Rating:  
Read Reviews | Write Review |  Your Rating: 

In current IT world the concept of reporting plays a major role. Especially the top level management of any organization mostly relies on reports to enhance their business as well as analyse the customer behaviour.
Microsoft Corporation has provided the SQL Server Reporting Services (SSRS) is one of such tools which provide the high end features of reporting. But in this tool making error handling is somewhat complex as it needs lot of coding. So this document has initiated in order to make t...

SQL Server Transactions and Error Handling  Version: 0.00     Price: $0.00  
Total Hits: 21  |  Today: 0Author: Saumendra Poddar      Rating:  
Read Reviews | Write Review |  Your Rating: 

The examples used in this article uses the Pubs database that comes as a sample database when you install SQL Server. If you need to rebuild the Pubs database, follow the steps to install a fresh copy :

1. Run the osql command prompt utility and detach the Pubs database from SQL Server by using the sp_detach_db system stored procedure....

Error Handling in SQL Server – a Background     
Total Hits: 113  |  Today: 0Author: Erland Sommarskog      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is one of two articles about error handling in SQL Server. This article focuses on how SQL Server – and to some extent ADO – behave when an error occurs. The other article, Implementing Error Handling with Stored Procedures, gives advice for how you should check for errors when you write stored procedures. Logically, this article is part one, and Implementing... is part two. However, you can read the articles in any order, and if you are relatively new to SQL Server, I recommend that you st...

Handling SQL Server Errors in Nested Procedures     
Total Hits: 207  |  Today: 0Author: Ron Talmage      Rating:  
Read Reviews | Write Review |  Your Rating: 

Basic error handling in SQL Server's programming language, Transact-SQL, is straightforward.But when you nest calls to stored procedures, and the procedures have SQL transactions, error handling becomes much more complex. In this article I'll show you some tried-and-true models for how to handle errors in nested stored procedures with transactions....

Utility Belt: Xray To Page Demo     
Total Hits: 156  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.
The enhanced Tracing functions is one demo of Array "Utility Belt" functionality including tracing of arrays, hashtables, datatables and dataset....

Removing the Fault from Default When Installing     
Total Hits: 178  |  Today: 0Author: John Paul Cook      Rating:  
Read Reviews | Write Review |  Your Rating: 

Installing SQL Server has become so routine it is all too often taken for granted; however, accepting the defaults during installation can lead to trouble. Understanding the installation options is necessary to ensure a secure installation. In this article, you will learn about the implications of various installation options so you can make informed decisions....

SQL Server 2005 Replication Error : The Distributor has not been installed correctly     
Total Hits: 140  |  Today: 0Author: Narayana Vyas Kondreddi      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is a short article to make you aware of an error returned by "Expired subscription clean up" job, when you setup replication in SQL Server 2005 (Yukon). Though the "Expired subscription clean up" job fails with the below error, there is nothing wrong with your replication setup. It is a bug in one of the replication system stored procedures. I wanted to highlight this, just to spare you from reinstalling replication, thinking you set it up incorrectly....

Error Solution: Fix for 'The database principal owns a schema in the database, and cannot be dropped' Error in SQL Server 2005     
Total Hits: 451  |  Today: 0Author: Shiva @Compile blog      Rating:  
Read Reviews | Write Review |  Your Rating: 

In SQL Server 2005, if you try to drop a database user by right-clicking the user name and clicking Delete, you may encounter an error as follows.
"The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)....

Why does the component gallery give an error     
Total Hits: 148  |  Today: 0Author: Calvin Hsias WebLog      Rating:  
Read Reviews | Write Review |  Your Rating: 

We received a bug report:
1) At the command window, issue the following:
Choose Tools->Gallery from the main menu
2) If the Visual FoxPro Catalog isn't open, then open it. Click on that
node in the left pane....

Troubleshooting database errors when using Crystal Development tools     
Total Hits: 205  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This document provides troubleshooting resources for solving database connectivity related errors when using Crystal Reports development tools including Crystal Reports 9,8.5,7,6,5,.net...

Handling errors within Stored Procedures in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 22  |  Today: 0Author: vijay kumar      Rating:  
Read Reviews | Write Review |  Your Rating: 

The robust Transact-SQL (T-SQL) syntax in SQL Server provides developers with an efficient way to handle errors within stored procedures. This article discusses the @@ERROR, SP_ADDMESSAGE, and RAISERROR functions within SQL Server....

1  2  Next >> 

Disclaimer - Privacy
© 2002-2017