|
|
|
|
|
| | Total Hits: 29 | Today: 0 | Author: Dhananjay Kumar | 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... |
| | Total Hits: 157 | Today: 0 | Author: Ahsan Khan | Rating: |
| |
How to fix MS Sql Server Restore Failed Error.... |
| | Total Hits: 238 | Today: 0 | Author: Edgewood Solutions Engineers | 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.... |
| | Total Hits: 441 | Today: 0 | Author: Shiva @Compile blog | 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).... |
| | Total Hits: 290 | Today: 0 | Author: ExtremeExperts.com | 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.... |
| | Total Hits: 5210 | Today: 0 | | Rating: |
| |
Shows you how to configure ASP.net 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."... |
| | Total Hits: 519 | Today: 1 | | 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.... |
| | Total Hits: 1297 | Today: 0 | | 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.
-or-
When you add certificates to a server that already has SQL Server installed, local connections fail.... |
| | Total Hits: 11 | Today: 0 | Author: V-rajbog | 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... |
| | Total Hits: 8 | Today: 0 | Author: Neeraj Nagpal | 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.... |
| | Total Hits: 12 | Today: 0 | Author: Saumendra Poddar | 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.... |
| | Total Hits: 97 | Today: 0 | Author: Erland Sommarskog | 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... |
| | Total Hits: 120 | Today: 0 | Author: Erland Sommarskog | Rating: |
| |
This is one of two articles about error handling in SQL Server. This article gives you recommendations for how you should implement error handling when you write stored procedures, including when you call them from ADO. The other article, Error Handling in SQL Server – a Background, gives a deeper description of the idiosyncrasies with error handling in SQL Server and ADO. That article is in some sense part one in the series. However, you can read this article without reading the background arti... |
| | Total Hits: 196 | Today: 0 | Author: Ron Talmage | 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.... |
| | Total Hits: 114 | Today: 0 | Author: Charles Carroll | 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.... |
| | Total Hits: 143 | Today: 0 | Author: Charles Carroll | 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.... |
| | Total Hits: 149 | Today: 0 | Author: John Paul Cook | 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.... |
| | Total Hits: 126 | Today: 0 | Author: Narayana Vyas Kondreddi | 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.... |
| | Total Hits: 134 | Today: 0 | Author: Calvin Hsias WebLog | Rating: |
| |
We received a bug report:
STEPS TO REPRODUCE:
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.... |
| | Total Hits: 182 | Today: 0 | | 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... |
|
|
|
|
|
|
|
|
|
|
|
|
|