Browse by Tags
All Tags »
error (RSS)
The following error is a frequent-faced issue by any SQL Server user : SQL Server is unavailable or does not exist or SQL Server does not exist or access denied In this regard we have already relevant post PotentialCauses_Resolution here, but still I
Read More...
Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings.
Read More...
One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the
Read More...
One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout
Read More...
Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual
Read More...
You may be aware default 4 SQL Server system databases master, model, msdb & tempdb are created automatically when the SQL Server is installed. Those databases files can be located under default directory assuming C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Read More...
Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default install
Read More...
Say you are executing a scheduled job using a batch file and output is stored to a file, then in that output file you will see Warning messages such as SQLSTATE. So how to suppress these messages on the output file. Simply using -i option in SQLCMD as
Read More...
On one of the SQL Server instance recently we have been getting the following error: SQL Server could not spawn FRunCM thread. Error: 17182, Severity: 16, State: 1. 2005-10-30 15:35:44.79 Server TDSSNIClient initialization failed with error 0xd, status
Read More...
Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ""Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>'
Read More...
If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects
Read More...
This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format.
Read More...
One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------
Read More...
--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001'
Read More...
Normally I wouldn't do much development using Reporting Services, but lately I was trying to play with it to get a flashy type of report for a monitoring information on set of SQL Servers we manage. In this scenario I have developed a report that works
Read More...