.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Applying SP2 for SQL 2008

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server

My company has some 2005 SQL Severs with SP3 and 2008 with SP1 applied. Now that SP4 for 2005 and SP2 for 2008 have been released, is that an option or a must to apply these new Service Packs?




View Complete Post

More Related Resource Links

Applying SQL 2008 SP1 CU 2 in MOSS environment


Hi all,

I have a dedicated SQL 2008 x64 std edtion with SP1  for MOSS 2007 SP2, I would like to apply the CU2 for activating the lock memory page feature, I would like to know if there any incidence on the sharepoint farm after applying this CU on my SQL server?

Thank you for your feedback about that.




All links in SSRS 2008 are not showing https after applying ssl certificate



I have applied ssl certificate to SSRS 2008.It does not show https url to few tabs & links like New data source,upload file under contents tab.Also it does not show https link for history & subscription tab.

Further I have modified the SecureConnectionLevel=3 in RSReportServer.config & change AuthenticationType to RSWindowsBasic.Now it shows the https link to all tabs.But it pop-up for user name & password for eachtime.How can I remove the pop-up for user name & password?

Any help will be appreciated.

Thank you.

Applying SP1 for 2008 Standard Server

Dear users, This morning I attempted to apply SP1 to a 2008 Enterprise SQL Server. I encounter this message. I wonder what I should do to resolve this problem. Could you advise me what to do? Meanwhile I will search for solution. Thank you in advance. TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_DTS_Full,Connectivity_Full,SQL_SSMS_Full,SQL_BIDS_Full,SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed. Error code 0x84B20001. ------------------------------ BUTTONS: OK ------------------------------

Error Applying SP1 to SQL Server 2008 Standard

Has anyone seen this error when applying SP1 to SQL Server 2008 Standard Edition.  It's on a Windows 2008 SP1 Server 64 bit machine.  Here is the error:

The process cannot access the file 'C:\Windows\SysWOW64\perf-SQLSERVERAGENT-sqlagtctr10.0.1600.22.dll' because it is being used by another process.

I've tried stopping the SQL Server agent and rebooting but I'm still getting that error.  Anyone ecounter that before?  What is that dll used for?

Applying SP1 to 2008 Enterprise SQL Server


Dear users,


I ran REPAIR and it ran successfully. After that I applied SP1 but got a below error at the first page


TITLE: SQL Server Setup failure.


 SQL Server Setup has encountered the following error:

 "A failure was detected for a previous installation, patch, or repair for instance 'XXXXXXXX' during configuration for features [MPT_AGENT_CORE_CNI,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed."

 Error code 0x84B20001.

Could you advise what to do?


Thank you,


Execute DDL Task logging disappears after applying SQL Server 2008 SP2


I am using various SSIS packages to manage different Analysis Services (SSAS) databases.  The packages create the necessary DDL for processing the dimensions and partitions in the SSAS databases and then run the DDL using Execute DDL tasks.

I've been using SSIS logging to capture the log information for the Execute DDL Tasks and directing that log data to a SQL Server table.  I've noticed that since the application of SP2 I only get the 'Started building processing schedule.' log message for the Execute DDL Tasks and none of the other event log entries.

This has happened at a couple of the sites that I support.  Install SP2 = no logging (with the one exception) from the Execute DDL Task steps.

Is this a known issue?  I did a couple of searches and didn't find anything.



"Unable to Load Client Print Control" after applying CU8 to 2008 SP1


In our environment, users are unable to Install ActiveX controls themselves. Primarily, this is particularly true in our Citrix environment. Upon applying CU8 to our 2008 SP1 SQL Server that we use to run reports, I'm no longer able to manually register the rsclientprint.dll to register the rll's and ActiveX control for users. Is this a known issue? Is there a new method to acheiving this same task?

Due to the size of our citrix environment, manually installing the activeX control through internet explorer on every one of our Citrix servers is NOT an option.

Any assistance is GREATLY appreciated.

question about applying 2008 SP1 on a active passive cluster


In the past (SS 2005), I was able to apply patches to to the virtual cluster host and it automatically detected both nodes and applied the patch.  This incurred downtime due to a reboot, but i did not care since this was a new cluster build.

Now, in 2008, the information I am finding implies that you should apply on passive node, perform a failover and then apply on other node.  

I am curious if it is still possible to apply the patch like i did for SS 2005, where I just run the install a single time from the virtual cluster host, thereby letting the installer figure out  it is a cluster and apply to both nodes?

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008


I am having problems with a user control. I want my solution to have a separate project for holding my user controls.

The main project can get a reference to this user control project and can import this user control dll into my main project. 

Thanks in advance,

Dheeraj Mittal


Visual Web Developer 2008


I'm getting th error "unable to connect to the asp.net development server 2008"

It's been working fine for months and all the sudden.I'm fairly new at this so if you have a fix I will need details.



Visual Studio 2008 Memory problems


My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.

is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project


my current project references




i have a very annoying iis problem

iis server stops working until app pool is recycled


i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem


Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend