Couple of days back I saw a question on MSDN forums where a user is not getting any warnings when using isql (commandline utility) and he is getting warnings when using isqlw (query analyzer GUI) for the same query. I’m just writing this article because many of them face this problem when they do batch processing data’s through isql.
Example:
Consider you are having a table with column char(3) and if you insert a value which has 4 characters then sql client utility should throw a error. When you connect SQL Server using query analyzer, then Ansi_warnings are on by default and you will receive this error & the transaction will not happen. However if you connect SQL server using isql command line utility then you won’t get this error, instead it will truncate the last character and insert it into the table. Lets check it out! Read the rest of this entry »
please wait...
Rating: 0.0/5 (0 votes cast)
Tags: Administration, SQL Server
After the release of CU1 for SQL 2008 a month ago now SQL Server team has released the next cumulative update for SQL Server 2008 on November 19, 2008. To know more about cumulative update 2 for SQL Server 2008 check the link “http://support.microsoft.com/default.aspx/kb/958186/en-us“. This build of the cumulative update package is also known as build 10.00.1779.00.
APPLIES TO
• Microsoft SQL Server 2008 Analysis Services
• Microsoft SQL Server 2008 Community Technology Preview
• Microsoft SQL Server 2008 Developer
• Microsoft SQL Server 2008 Enterprise
• Microsoft SQL Server 2008 Express
• Microsoft SQL Server 2008 Express with Advanced Services
• Microsoft SQL Server 2008 Reporting Services
• Microsoft SQL Server 2008 Standard
• Microsoft SQL Server 2008 Standard Edition for Small Business
• Microsoft SQL Server 2008 Web
• Microsoft SQL Server 2008 Workgroup
please wait...
Rating: 0.0/5 (0 votes cast)
Tags: Administration, SQL Installation, SQL Server 2008
I’ve posted a new article in our website on Filtered Index topic. You can check the article in the link “Filtered Index - SQL Server 2008” and provide your feedback.
please wait...
Rating: 0.0/5 (0 votes cast)
Tags: Administration, SQL Server 2008
I was reading PSS MSDN blogs and found an useful information about SQL 2008 installation and thought of sharing this with you. There is a know issue with SQL 2008 setup (refer KB article http://support.microsoft.com/kb/957453/) and they have fixed this in cumulative update 1. Lets see how to use CU1 to fix this installation issue.
- Before Installing SQL 2008 from CD \ DVD, download cumulative update 1(http://support.microsoft.com/kb/956717) and install it in the machine, this will install the newly updated setup support files alone with the version 10.00.1763.0.
- Once this is done, you can now proceed with SQL 2008 installation. When the installation starts it will use the newly installed setup support files bypassing the know issue with the KB article 957453.
- After successful installation of SQL 2008 you need to re-run cumulative update 1 to update all SQL 2008 components.
That’s it you have done with the installation!!
To know more on this topic you can refer this PSS blog link “How to fix your SQL Server 2008 Setup before you run setup…“.
please wait...
Rating: 0.0/5 (0 votes cast)
Tags: Administration, SQL Installation
Installing Cumulative Update 1
To install CU1 you need to download cumulative update 1 from the link “Cumulative update package 1 for SQL Server 2008“. Download link is not given in the KB article, you need to request for CU as shown in the below image.
Once you placed your request an download link with password will be sent to the email address given at the time of request. Extract the content of the exe file with the help of password provided in the mail. Once its done you are ready for installation.
Read the rest of this entry »
please wait...
Rating: 0.0/5 (0 votes cast)
Tags: Administration, SQL Installation
