SqlServer-QA.net

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

SQL Master — Tue, 30 Jun 2009 16:28:00 GMT

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. The reason that Microsoft has deactivated...(read more)

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

SQL Master — Tue, 30 Jun 2009 01:16:00 GMT

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 http://support.microsoft.com/kb/2000255/en-US New 6/26/2009 4:55:00 PM GMT...(read more)

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

SQL Master — Mon, 29 Jun 2009 21:16:00 GMT

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 http://support.microsoft.com/kb/2000274/en-US 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.

SQL Master — Mon, 29 Jun 2009 10:16:00 GMT

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. Without further thinking I simply hit 'Run Program'...(read more)

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

SQL Master — Thu, 25 Jun 2009 07:02:00 GMT

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. Just to go back on platform compatibility, there are only two 64 bit...(read more)

Export to Excel - data length exceeds 255 characters

Madhivanan — Mon, 22 Jun 2009 13:14:00 GMT

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 http://support.microsoft.com/default.aspx?scid=kb;en-us;281517...(read more)

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

SQL Master — Sun, 21 Jun 2009 19:26:00 GMT

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 http://blogs.technet.com/andrew/archive/2009/06/09/free-stuff-sql-server-courses-software.aspx is the link for you....(read more)

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

SQL Master — Sun, 21 Jun 2009 19:12:00 GMT

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. One of the common criteria I have seen about using ALIAS that will enable logins to assume the identity of a user in a database, thereby gaining the...(read more)

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

satyaskj — Thu, 18 Jun 2009 11:46:00 GMT

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. Few times I have seen that this particular service account also requires REGISTRY permissions too and say if...(read more)

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

SQL Master — Wed, 17 Jun 2009 08:29:00 GMT

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". Going back to the problem one of the system support staff alerted about a problem on installation of SQL Server 2008, so the usual stuff of checking error logs was the first step and still the...(read more)

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

SQL Master — Wed, 17 Jun 2009 05:01:00 GMT

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. As per the Oracle's reference this might occur when attempting to...(read more)

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

SQL Master — Mon, 15 Jun 2009 06:42:00 GMT

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 http://beyondrelational.com/blogs/tc/archive/tags/Challenge/default.aspx post....(read more)

Release of BizTalk ESB Toolkit 2.0

SQL Master — Thu, 11 Jun 2009 16:10:00 GMT

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. Enabling maximum flexibility at run time, the BizTalk ESB Toolkit...(read more)

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

SQL Master — Thu, 11 Jun 2009 08:33:00 GMT

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. As the existence of that process was on a minimum time and hard to catch hold, also another practice is to refer to SQL Server error log to...(read more)

TSQL to disable all scheduled jobs

SQL Master — Thu, 11 Jun 2009 08:28:00 GMT

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..sysjobs (NOLOCK) WHERE enabled = 1 -- You can put more condition here to disable the required jobs SELECT @seq = MAX(seq) FROM @job WHILE ( @seq > 0 ) BEGIN SELECT @name = jobname FROM @job WHERE seq...(read more)

Quirky update in sql server

Madhivanan — Wed, 10 Jun 2009 18:36:00 GMT

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...(read more)

National Cyber Alert System

SQL Master — Tue, 09 Jun 2009 14:35:00 GMT

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. The NVD is sponsored by the Department of Homeland Security ( DHS ) National...(read more)

SQL Server Upgrade issues - How to evaluate potential issues?

SQL Master — Tue, 09 Jun 2009 07:36:00 GMT

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. Also the coverage towards the exhaustive list of all upgrade issues with an end-to-end coverage or in-depth drilldown of all SQL Server 2005 & 2008...(read more)

Handle Disk Fragmentation issues with effective methods within SQL Server enviornment

SQL Master — Mon, 08 Jun 2009 21:11:00 GMT

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. So it is a required practice to defragment...(read more)

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

SQL Master — Mon, 08 Jun 2009 08:46:00 GMT

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. Further to this I had an opportunity to meet Ola Hallengren , author of this so called adhoc...(read more)

"Best Thing I Learned at PASS” Contest and Summit 2009 desktop kits

SQL Master — Wed, 03 Jun 2009 12:15:00 GMT

Here is your chance to win one of 10 great prizes, including a free PASS Summit 2009 registration or 4 nights free hotel at PASS Summit 2009, free Pre/Post-Conference session registration, or a full set of PASS Summit 2008 session recording DVDs. Community Committee in PASS has taken best feedback from the community and running this exciting contest on you talk about all the great stuff you learned at PASS Summit that more than paid for your attendance. Now's your chance to turn talk into treasure!...(read more)

BizTalk Server 2009 Dev Center updates

SQL Master — Tue, 02 Jun 2009 14:30:00 GMT

Here is the update from Microsoft Development team for BizTalk Server 2009, they are located under the “Top Downloads” section in Dev Center page, and they are for the BizTalk Server 2009 Installation and Upgrade Guides , the BizTalk Server 2009 Code Samples and the BizTalk Server 2009 Documentation ....(read more)

Microsoft Security Bulletin Summary for May 2009 - Critical Security Bulletins

SQL Master — Tue, 02 Jun 2009 11:52:00 GMT

This bulletin summary lists security bulletins released for May 2009. The full version of the Microsoft Security Bulletin Summary for May 2009 can be found at http://www.microsoft.com/technet/security/bulletin/ms09-may.mspx . With the release of the bulletins for May 2009, this bulletin summary replaces the bulletin advance notification originally issued on May 7, 2009. For more information about the bulletin advance notification service, see http://www.microsoft.com/technet/security/Bulletin/advance.mspx...(read more)

SQL Server to address compliance needs of your environment

SQL Master — Tue, 02 Jun 2009 07:38:00 GMT

Common Criteria (CC) Certification is required for any environment and SQL Server is no compromise or exception in this case. I would like to highlight a brief introduction to this requirement (as per my experience), in the recent times many changes to the laws in Financial sector or any industry that operates on governments and commercial users of DBMS products, there is a big need to understand the security functionalities and the quality of those functionalities that they purchase and use. TO...(read more)

Save 35% on select Microsoft Press books - look for Sharepoint Services

SQL Master — Tue, 02 Jun 2009 07:03:00 GMT

It is a great news that Microsoft has re-confirmd about the changing the economic model for delivery of rich Business Intelligence (BI) functionality such as moving the dashboard, score-cards and analytic functionality from the stand alone produce PerformancePoint Server 2007 into Sharepoint Server. You can Watch this short video explaining the update and no doubt that it will help the BI suite and integration with Sharepoint technologies . A s I have already talked about the announcment on next...(read more)