Community developer blogs

All about SQL Server

Recent Posts

• SQL Server Reporting Services issue: Unable to load client print control

  Posted: 30 Jun 2009 at 16:28 by SQL Master

  If you simply search on the error message within the subject then the best point of it is you get many references on how to resolve this issue. Going back to root cause of the problem is that number of people have reported problems using the ActiveX print control in the report viewer after installing Microsoft Update 956391 having users receive the error " Unable to load client print control " when clicking on the print icon in the report viewer toolbar.

• SQL Server 2005 default instance may not start when there is a SQL Server 2000 named instance and both instances are configured to listen on named pipes

  Posted: 30 Jun 2009 at 01:16 by SQL Master

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New SQL Server 2005 default instance may not start when there is a SQL Server 2000 named instance and both instances are configured to listen on named pipes New 6/26/2009 4:55:00 PM GMT...(read more)

• How to fix permission issues when moving MSDB database between different instances

  Posted: 29 Jun 2009 at 21:16 by SQL Master

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications How to fix permission issues when moving MSDB database between different instances New 6/26/2009 5:00:00 PM GMT...(read more)

• SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.

  Posted: 29 Jun 2009 at 10:16 by SQL Master

  There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning! The above error was presented to me recently when I'm trying to install SQL Server 2005 & 2008 versions on my Windows 7 RC VM. The exclusive specificatin of this error is it included SQL Express editions too, as the incompatibility was fixed in SQL Server 2008 Service Pack1 and SQL Server 2005 Service Pack 3.

• 32 bit application issues on 64 bit platform, vice-versa and SQL Server is no excuse?

  Posted: 25 Jun 2009 at 07:02 by SQL Master

  There is much more sayings on the blogs about 64 bit platform issues when you have 32 bit applications, so it bit noise to create there about the common problem that I have seen (virtually anywhere) that SSIS packages will suffer a lot between these platform differences, such as when you got to run a package in 64-bit mode, you might not be able to connect to as many data sources as you can when you run a package in 32-bit mode.

• Export to Excel - data length exceeds 255 characters

  Posted: 22 Jun 2009 at 13:14 by Madhivanan

  If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it more)

• Free stuff, course and software - SQL Server 2008, are you interested?

  Posted: 21 Jun 2009 at 19:26 by SQL Master

  Here is the interesting post that I would like to share to my community about free stuff such as courses and software by Andrew Fryer , for your joy is the link for you....(read more)

• SQL Server 2008 TSQL features, rather we spotlight on deprecated and discontinued features?

  Posted: 21 Jun 2009 at 19:12 by SQL Master

  As referred on the Pattern and Practices - deprecate and discontinued Transact SQL features we will now look into (my favs) on SQL Server 2008 TSQL features, rather we spotlight on deprecated and discontinued features! IT is one of the best practice that you need a persistent planning to change the issues in addressing the use of deprecated features.

• Unable to run SQL*PLUS. Make certain that a current version of the Oracle client code is installed at the distributor.

  Posted: 18 Jun 2009 at 11:46 by satyaskj

  The error subject line is caused due to issues with Oracle Client and Networking connection privileges. By default when you have SQL replication setup to an Oracle client then the account under which SQL Server instance runs on the Distributor must be granted read and execute permissions for the directory (and all subdirectories) in which the Oracle client networking software is installed.

• SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system.

  Posted: 17 Jun 2009 at 08:29 by SQL Master

  It has been a while that I posted any blog in this section and lately there has been problems within the x64 platform. One of them is SSIS packages and another is this "SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system".

• SSIS and 64 bit platform- Test connection failed because of an error in initializing provider. ORA-06413: Connection not open?

  Posted: 17 Jun 2009 at 05:01 by SQL Master

  The above error message might look familiar for the DBAs who manage 64 bit platforms, it is a simple connection error when SSIS connection (on 64 bit) attempted to Oracle database. In the past I have seen this error when it attempts to connect 32 bit driver of Oracle provider. Recently this was one of the daunting moments to resolve on a SQL 64bit platform where the complete work force from Developer to End user has been involved.

• TSQL Challenge - source of fun solving and fine tune your knowledge

  Posted: 15 Jun 2009 at 06:42 by SQL Master

  It brings me a great joy and actual skill of solving the TSQL challenge posts by fellow MVP Jacob Sebastian and this thime see the Aurelien and Matthieu have fun with TSQL Challenges post which is a mixture of fun & skill of solving the puzzle. For the list of TSQL Challenges so far see this post....(read more)

• Release of BizTalk ESB Toolkit 2.0

  Posted: 11 Jun 2009 at 16:10 by SQL Master

  The BizTalk ESB Toolkit 2.0 , formerly known as the ESB Guidance 2.0 - is being released June 9th to the web on the new ESB page in the BizTalk Developer Center on MSDN. This toolkit is a collection of tools and libraries that extends BizTalk Server 2009 capabilities of supporting a loosely coupled and dynamic messaging architecture. It functions as middleware that provides tools for rapid mediation between services and their consumers.

• SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048

  Posted: 11 Jun 2009 at 08:33 by SQL Master

  Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially the DBAs have thought it is a blocking problem and trying to catch up the SPID to kill with no success.

• TSQL to disable all scheduled jobs

  Posted: 11 Jun 2009 at 08:28 by SQL Master

  Here is the TSQL script that I received from one of the enthusiastic SQL user Prabhakaran on our site: SET NOCOUNT ON DECLARE @job TABLE ( seq SMALLINT IDENTITY, jobname SYSNAME ) ; -- Declare Table variable to hold job info DECLARE @name SYSNAME, @seq SMALLINT ; INSERT @job SELECT name FROM msdb..

• Quirky update in sql server

  Posted: 10 Jun 2009 at 18:36 by Madhivanan

  When you use variables in update statement and update the columns with the values of varaibles which keep on changing for each row , you can simulate many things that are done using Loop or a Cursor declare @temp table ( product_name varchar ( 100 ), Value int , sequence int ) insert into @temp values ( 'product1' , 25 , 0 ) insert into @temp values ( 'product2' , 25 , 0 ) insert into @temp values ( 'product3' , 100 , 0 ) insert into @temp values ( 'product4' , 100 , 0 ) insert into @temp values

• National Cyber Alert System

  Posted: 09 Jun 2009 at 14:35 by SQL Master

  Here is the interesting post Cyber Security Bulletin SB09-117 that I found from US-CERT (United States Computer Emergency Readiness Team). Here is the extract about the methods followed to generate the alert: The US-CERT Cyber Security Bulletin provides a summary of new vulnerabilities that have been recorded by the National Institute of Standards and Technology ( NIST ) National Vulnerability Database ( NVD ) in the past week.

• SQL Server Upgrade issues - How to evaluate potential issues?

  Posted: 09 Jun 2009 at 07:36 by SQL Master

  During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology, tools and planning, technical and non-technical considerations along with common issues, myths and mistakes.

• Handle Disk Fragmentation issues with effective methods within SQL Server enviornment

  Posted: 08 Jun 2009 at 21:11 by SQL Master

  When you talk about Performance problems then fragmentation & database integrity issues are dearest friends of DBA! As data is modified in the databases, the tables and indexes will become fragmented, which means the data is scattered everywhere in the database. So talking in DBA sense the moral is as more fragmented a clustered or non-clustered index becomes, it is nothing but database engine requires to add more pages to fulfil the same query request.

• Adhoc solution to perform SQL Server database maintenance tasks - more features

  Posted: 08 Jun 2009 at 08:46 by SQL Master

  I had been receiving a good feedback about the solution that has been posted previous about Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008 and inline link for SQL Server 2005 too. In fact I have tested the scripts thoroughly before posting them to the community,as it is another good practice to make sure that you are not simply passing the buck.