[SQL]Unable to Modify a Maintenance Plan

Status;
1. Unable to modify any Maintenance Plans

2. Error Message showed like below


TITLE: Microsoft SQL Server Management

Studio

Could not load file or assembly 'msddsp, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Microsoft.DataTransformationServices.Design)
 

[SQL]How to calculate "Julian day"

select julian_day(current_date)-julian_day('2011-12-31')

from any files

-or the first date of year and then + 1                                   

select julian_day(current_date)-julian_day('2012-01-01') + 1

from any files

If files have over 1 row to be appealed, added DISTINCT before Julian_day

select DISTINCT julian_day(current_date)-julian_day('2011-12-31')

from any files

-or the first date of year and then + 1                                   

select DISTINCT julian_day(current_date)-julian_day('2012-01-01') + 1

from any files

----------------------------------------------------------------------------------------------

Because Julian Day is representing a number of days from January 1, 4713 B.C.

[Server] Windows Server 2012 Evaluation Edition Converted to Legal Edition

Situation:

We used the trail edition to develop and test new product. Recently we have a valid and legal serial number. But when I tried to enter and activate it. It said "not valid" and not activated.
It's weird to me. So I dig Google and find a way to active it.