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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Proper upgrade path for out of date portal

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :SharePoint
I have a MOSS 2007 Portal that is woefully neglected.  A quick glance showed that its version was  The table below list all the current updates. Cumulative Update KB974989 & KB974988 Oct 2009 Cumulative Update KB973410 & KB973409 Oct 2009 Cumulative Update KB971538 & KB972569 Jul 2009 Cumulative Update KB968857, KB968850, &KB968851 Jun 2009 SP2 April 2009 Cumulative Update KB963654 & KB961755 Feb 2009 Cumulative Update KB960010 & KB960011 Dec 2008 Cumulative Update KB956056 & KB956057 Aug 2008 Infrastructure Update KB951695 & KB951297 Jul 2008 SP1 + KB948945 Feb 2008 SP1 + KB941274 Jan 2008 SP1 + KB941422 Jan 2008 SP1 October 2007 public update   Do I have to apply them all in order or can I simply jump straight to the cumulatives in order?  Are there any of other considerations I should be aware of?

View Complete Post

More Related Resource Links

Proper upgrade path for out of date SQL instance

I currently have a SQL backend that is feeding an out of date MOSS 2007 instance.  I have found the following: Version Information   Version 9.00.4053.00 Command: Select @@Version Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)   May 26 2009 14:24:20   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Version Number KB Article Link Release Date 9.00.4305 SQL Server 2005 SP3 CU10  June 2010 9.00.4294 SQL Server 2005 SP3 CU9 Apr 2010 9.00.4285 SQL Server 2005 SP3 CU8 Feb 2010 9.00.4273 SQL Server 2005 SP3 CU7 Dec 2009 9.00.4266 SQL Server 2005 SP3 CU6 Oct 2009 9.00.4230 SQL Server 2005 SP3 CU5 Aug 2009 9.00.4226 SQL Server 2005 SP3 CU4 June 2009 9.00.4220 SQL Server 2005 SP3 CU3 Apr 2009 9.00.4211 SQL Server 2005 SP3 CU2 Feb 2009 9.00.4207 SQL Server 2005 SP3 CU1 Dec 2008 9.00.4053 SQL Server 2005 SP3 GDR (Security Update) Oct 2009 9.00.4035 SQL Server 2005 SP3 Dec 2008 9.00.3356 SQL Server 2005 SP2 CU17 Dec 2009 Whats the best approach to updating the SQL instance?  Do them in order or can I use the latest cumulative?  Any other issues I should be concerned about?

sql server 2008 version upgrade failed access to path is denied

upgrading from 2008 r2 eval to 2008 r2 enterprise. Use the maintenance option from setup. Get pretty far along in the process.  But then the following error. ( an additional note. setup warns that I am running sql server on a domain controller server. ) The link the error message points to has nothing to say. Why would my sql server upgrade fail? If I have to reinstall, will I lose my database data? thanks,   TITLE: Microsoft SQL Server 2008 R2 Setup ------------------------------ The following error has occurred: Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_ENT_1033.rtf' is denied. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400xBB814387  

SharePoint Portal Server 2003 - email alert based on due date


Hello All,

Hoping someone can help us here.

Note:Workflow/3rd party solutions not an option-

We would like to send an email alert when a list items due date is eqaul to "today".

We are trying to manage some certificates of compliance by flagging the "due date of the particular certificate (list item)" and sending an alert email when that occurs.

Is this feasible in any manner without workflow?

Is it possible to send an alert based on a calculated field when that calculated data changes? .

Any direction would be appreciated.

Thank you

Mike Harvey
Software Solutions Architect


Portal Site Connection Missing After Upgrade


I have just upgraded to 2010 from 2007 and noticed that the portal site connection is not showing up on the different site collections it was setup on. If I go into site actions->portal site connections, the setting is still enabled and the URL is still correct. How can I get this back? This was a very useful feature..

Date Covertion from Char field to a proper format


Hi Gurus,

There is a field in a table with type and length as varchar(255).  It stores a value as follows 'Patch_Test_9_10_201012;00;00AM'.  I need to extract 9_10_201012;00;00AM and format it as 9/10/2010 12:00:00 AM.  I tried CONVERT and CONVERT+CAST it won't work.

Is there a way to do it? Please, any ideas , inputs are wellcome


Best upgrade path 2005 exp to 2008 standard, different boxes


What would you recommend as the best way to convert our databases from SQL 2005 Express to SQL Standard which are both up and running on different servers?  I'd prefer to leave the old server as-is so we can transfer one or two databases per weekend and leave the others as-is.  Would a backup and restore work when switching version, as in method one in this article?: http://support.microsoft.com/kb/314546

Or would there be a better way, such as using an import?

date not getting stored in proper format in vb 6.0 and sql server 2000

i have a form which accept date in dd/mm/yyyy format from the user but  when i am storing it into sql server , some time it is getting stored in
dd/mm/yyyy format and some time in mm/dd/yyyy format. When i try to retrive date from sql server  and fetch it into text box it is geting  displayed in other format . some time in dd/mm/yyyy  and  mm/dd/yyyy format .
my reginal date setting is in mm/dd/yyyy format .
will be great if i get a quick help on this issue

SQL Server 2008 enterprise upgrade failed: Illegal characters in path.


My production upgrade from SQL Server 2005 to 2008 just went down. This is a single x64 server installation the log reported the strange set of problems:


2011-04-13 10:14:48 AS: Result: (Utility) Success
2011-04-13 10:14:48 AS: Action: Set Admin Rights For Folder(F:\SSAS\AS_TEMP\|)
2011-04-13 10:14:48 Slp: Sco: Attempting to set directory full path
2011-04-13 10:14:48 Slp: Sco: Attempting to normalize directory path F:\SSAS\AS_TEMP\|
2011-04-13 10:14:48 Slp: Prompting user if they want to retry this action due to the following failure:
2011-04-13 10:14:48 Slp: ----------------------------------------
2011-04-13 10:14:48 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2011-04-13 10:14:48 Slp: Inner exceptions are being indented
2011-04-13 10:14:48 Slp: 
2011-04-13 10:14:48 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2011-04-13 10:14:48 Slp:   Message: 
2011-04-13 10:14:48 Slp:     Illegal characters in path.
2011-04-13 10:14:48 Slp:   Data: 
2011-04-13 10:14:48 Slp:    DisableRetry = true
2011-04-13 10:14:48 Slp:   Inner exc

Date Format error in enterprise portal



  I have installed ssrs in different server,ssas in different server and enterprise portal in different server.Configured and also done kerbores .Regional and language settings of all server are set to us english(dd/mm/yyyy).I have checked the regional and language settings of all server .I have checked the enterprise portal regional settings also.It is also set to us english.Iam getting date format error like

The value provided for the report parameter 'Dataset_ToDate2' is not valid for its type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportParameterTypeMismatchException: The value provided for the report parameter 'Dataset_ToDate2' is not valid for its type.

Instead of taking dd/mm/yyyy its taking mm/dd/yyyy.

I done know where Iam missing something...please help me.

Using a CompareValidator to check input is a valid date

The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

How To Set a Date Format In GridView Using ASP.NET 2.0

A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

jQuery Date picker Implementation in ASP.NET

I've posted a wrapper ASP.NET around the jQuery.UI Datepickercontrol. This small client side calendar control is compact, looks nice and is very easy to use and I've added it some time back to my control library.

This is primarily an update for the jQuery.ui version, and so I spend a few hours or so cleaning it up which wasn't as easy as it could have been since the API has changed quite drastically from Marc's original implementation. The biggest changes have to do with the theming integration and the resulting explosion of related resources.

If you want to use this component you can check it out a sample and the code here:

How to format datetime & date with century?

Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.


Date and Time Functions in SQLSERVER

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

Built-in Functions - Date and Time Functions

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.
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