Maintenance Tasks didn't install

SQL Server Setup & Upgrade

Index ‹ SQL Server
- Archive
  - Dotnet
  - VC++
  - Game
  - IE
  - SQL Server
  - Office
  - VS 2008
  - Architecture
  - Windows Forms
  - Smart Device
  - SharePoint
  - Windows Vista
  - ISV
  - Visual C#
  - VB
  - Windows Live
  - Visual Studio
  - VS Express
  - VFP

- Previous
  - 1
    - Guidelines for choosing collation If I am doing a fresh installation of SQL 2005 for a new application which will utilize database engine, report server and analysis services is my best choice Latin_General_BIN2 Thank you, Alex Ivanoff Tag: Maintenance Tasks didn't install
  - 2
    - SQL Server 2005 Install fails on Vista During the install, I get the following message: Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it. I tried downloading 2.0 and installing it, but it says that its allready installed. I was able to install Visual Studio with Sql Server 2005 express. I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista Tag: Maintenance Tasks didn't install
  - 3
    - New features of Reporting Service in SQL 2008 Where can i find the new upcoming features in reporting service for 2008 Tag: Maintenance Tasks didn't install
  - 4
    - roll back in for each container Hi, I'm using data flow as flat file source -> derived column ->Data Conversion-> oledb destination I have a fifty thousand record in a delimited file. while processing i got error in 45000th row. In database only 40000 records are there(why is there no all 45000 records). Is there any way to roll back all the 40000 records. Tag: Maintenance Tasks didn't install
  - 5
    - SSRS 2005 probplem with mdx prameter passsing hi , i am trying generate a report using following query. but the parameter is nt properly passing. (OLEDB). i need to correct it. pls help me. ="WITH "+ "MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'"+ "SET [FilteredBUList] AS 'descendants((STRTOSET ( '{" & Join(Parameters!BU.Value,",") & "}', CONSTRAINED),[Account—BillingCodeDsc].[Billing Code Description],leaves) ' "+ "SET [CustomTimeSet] AS Descendants([Date—Fiscal].[2006].[Quarter 1]:"+ "[Date—Fiscal].[2007].[Quarter 4],[Date—Fiscal].[month],Leaves)"+ "SELECT "+ "{[Measures].[Amount]} ON COLUMNS,"+ "{ [FilteredBUList] "+ "}on rows"+ " FROM Profitability" That BU parameter is multi value parameter. query should accept multi values . Tag: Maintenance Tasks didn't install
  - 6
    - SSIS SCript Transform Parallelism Hi, I need some urgent help on a conceptual question. Requirement: I have a simple package with one dataflow task. In that I need to read from a sql table and for every row in that table loop through n times and generate new output rows based on certain conditions (which are best evaluated in custom script as they are rather complex). Hence, if I have 100 rows in the table as my input, I may end up with 100*n rows as output. My Design: To implement this I have used an OLE DB Source which outputs to a Script Transform (ST). In the ST I intend to loop through in custom code and generate new rows using the .AddRow feature when I need new rows. This ST then feeds into another OLE DB Destination which writes the data to the table. Simple! I am using the default buffer settings. All I have tweaked is the Synchronous... property on the script transform (otherwise I do not get to the Output0Buffer within the script!). Problem: I wish to do as much as possible in parallel. So I would expect the OLE DB Source to provide more than one row at a time to the script transform and that should process more than one input row simultaneously. It seems the script componenet is serializing input, so it seems to take one row at a time from the OLE DB source, loop through and process in the script transform). AM I RIGHT IN THINKING THAT THE SCRIPT TRANSFORM IS EXECUTING THE INPUT IN A SEQUENTIAL MANNER CAN I PARALLELISE THIS If so, how Thanks, Tirthankar Tag: Maintenance Tasks didn't install
  - 7
    - SQL Server Express authentication mode greyed out Having problems connecting to SQL Server Express using 'sa' account and having read threds re problem and MS, advice is that Authenticaion mode needs to be set to both Windows and SQL. I have studio express installed and go to Security from the properties of the Server to change this option to use both authentication modes, however the options are greyed out! Can anyone advise pse. And will amending this option help me to enable the sa login which is refused at the moment, error as follows: Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection Thank you in advance Tag: Maintenance Tasks didn't install
  - 8
    - how to call a stored procedure in SSIS I have to transfer data from source to destination using stored procedures result set. There might be some more transformation needed to store the final result in the destination table. Appreciate an early feedback. Qadir Syed Tag: Maintenance Tasks didn't install
  - 9
    - change the background color in table in report I have a table that i need to display data for each row I want the background color to be diff anybody knowhow to do it color blank color blank Tag: Maintenance Tasks didn't install
  - 10
    - WebRequest over HTTPS fails under SQLCLR, but works elsewhere I have some code in a SQL CLR stored procedure that calls out to a web service at UPS to obtain tracking information for a package. The code fails on the last line, in the call to WebRequest.GetRequestStream(), with the following exception: "System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it\r\n at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)\r\n at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)\r\n at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)\r\n --- End of inner exception stack trace ---\r\n at System.Net.HttpWebRequest.GetRequestStream()\r\n at UPSTracking.TrackShipment(String TrackingUri)" Here is the relevant code: WebProxy proxyObject = new WebProxy(); WebRequest request = WebRequest.Create(" https://www.ups.com/ups.app/xml/Track "); request.Proxy = proxyObject; request.Method = "POST"; request.ContentLength = strXMLData.Length; request.ContentType = "application/x-www-form-urlencoded"; StreamWriter sw = new StreamWriter(request.GetRequestStream()); This same code works just fine when not running in the SQL CLR assembly. The assembly is marked as External, but I've also tried marking it as Unsafe, which did not work either. Any suggestions on what the problem might be or how to troubleshoot this further would be greatly appreciated. Thanks, Steve F. Tag: Maintenance Tasks didn't install
  - 11
    - Table design question - subject matter expert database I would like to create a database that keeps track of our companies subject matter experts. I have roughed out some of the tables. I would appreciate any feedback on if this is the right approach and if there might be any issues when I start writting a front-end (probably VB 2005). What makes this interesting (at least for me) is that a subject has an owner and at least 1 "expert", possibly up to 3. Here is what I am thinking for tables: tblEmployee EmployeeID (PK) LastName FirstName etc...... tblSubject SubjectID (PK) Description tblOwner SubjectID (FK) EmployeeID (FK) tblExpert1 SubjectID (FK) EmployeeID (FK) tblExpert2 SubjectID (FK) EmployeeID (FK) tblExpert3 SubjectID (FK) EmployeeID (FK) Does this make sense Would I run into any issues when trying to display this on a form in VB Thanks in advance for any help!!!!! Cal Tag: Maintenance Tasks didn't install
  - 12
    - Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on... Is there an expression syntax that will do this Does it have something to do with ROWNUMBER(). Any help is greatly appreciated! Thanks in advance! Probably an easy one for you gurus out there! Tag: Maintenance Tasks didn't install
  - 13
    - Activation I was testing around with a sample service broker app using activation, and came across an interesting question. The little app sends a series of four messages to a queue, either on the same conversation or on seperate ones. Each message invokes one stored procedure in my activation procedure. All the procedure does is enter a record into a test table and then wait for an allotted amount of time. In my example, the first message called a proc that waited 20 sec, the 2nd one that waited 10 seconds, the third 5 seconds, and the 4th 1 second. I am using internal activation on the queue. It seemed that in both scenarios (sending on 4 separate conversations and on one conversation) the procedures executed "almost" sequentially. "Almost" meaning that the first procedure was done before the last one started executing. It makes sense to me that this would happen where I sent them on the same conversation, but not really when I sent them on 4 seperate ones. Is it because when I call a procedure from my activation procedure it locks the queue so that another message cannot be processed (I'm processing a message at a time) How could I make it so that the 4th procedure (the one that only waits 1 second) returns before the 1st procedure (the one that waits 20 seconds) Tag: Maintenance Tasks didn't install
  - 14
    - Disable Save Changes prompt Is there a way in SQL Mgt Studio to disable the "Save changes to the following items " prompt that comes up every time I close a query window Tag: Maintenance Tasks didn't install
  - 15
    - Programatically adding a Timeout value for BulkInsertTask? I've searched around for a while and can't seem to find out how/where I set the timeout on a bulk insert task programmatically. Here is a snippet of code that works as long as the input file is pretty small....when I attempted to pump 1.3 million rows through the default timeout value was not big enough and a timeout exception occurred. Package loadPackage = new Package (); Stopwatch timer = new Stopwatch (); timer.Start(); ConnectionManager conMgr = loadPackage.Connections.Add( "FLATFILE" ); conMgr.ConnectionString = @"C:\BWR.txt" ; conMgr.Name = "FileInput" ; conMgr = loadPackage.Connections.Add( "ADO.NET:ODBC" ); conMgr.ConnectionString = @"Data Source=FOO;Initial Catalog=DestinationDb;Integrated Security=True;" ; conMgr.Name = "DestinationDB" ; TaskHost task = loadPackage.Executables.Add( "STOCK:BulkInsertTask" ) as TaskHost ; BulkInsertTask biTask = ( BulkInsertTask )task.InnerObject; biTask.UseFormatFile = true ; biTask.FormatFile = @"C:\BWR_1.fmt" ; biTask.SourceConnection = "FileInput" ; biTask.DestinationConnection = "DestinationDB" ; biTask.DestinationTableName = "StageBWR" ; biTask.BatchSize = 100; DTSExecResult result = loadPackage.Execute(); timer.Stop(); Console .WriteLine( string .Concat( "Process took(ms): " , timer.ElapsedMilliseconds.ToString())); Console .WriteLine(result.ToString()); if (loadPackage.Errors.Count > 0) { foreach ( DtsError error in loadPackage.Errors) { Console .WriteLine(error.Description); } } Again, the code above works just fine until we hit a timeout. There is no Timeout property on the BulkInsertTask class, nor can I see a way to set it on the Sql Connection. I don't even see them in the Connectionmanager.Properties collection for either the file connection or the database connection. Am I overlooking the obvious somewhere Tag: Maintenance Tasks didn't install
  - 16
    - MDX Query Help...Please Hi, I have a fact table containing the following columns: CustomerID RegionID CategoryID ItemID Price Relationships: A customer belongs to only one particular region and category Each customer can buy the same item at different prices The measures are LowPrice and AveragePrice Query For a particular customer, what was the customer price, average price and low price for some other combination of region and category ( this not the region and category,the customer belongs to) For ex: CutomerId RegionID CategoryID ItemID Price 1 1 2 1 2.00 2 2 3 1 6.00 3 2 3 1 4.00 Report should display for Customer 1 , Region 2 and Category 3 as ItemID Price LowPrice AveragePrice 1 2.00 4.00 5.00 Iam stuck with this query for a long time now...Any help on the query will be appreciated. Also, how would find the above result for all combinations of (regions and categories) Thanks, Prash Tag: Maintenance Tasks didn't install
- Next
  - 1
    - AMO: Can't update dsv when delete a column Hi, friends, please have a look at this: I am using AMO, and I do this: 1 step: I drop a column from the source table by SQL: ALTER TABLE TargetTable Drop COLUMN ColumnName 2 step: I try to update the dsv by AMO: Dim adapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter( _ "SELECT * FROM [dbo].[" + tableName + "] WHERE 1=0", connection) Dim i As Integer For i = 0 To dsv.Schema.Tables.Count - 1 If dsv.Schema.Tables(i).TableName = "dbo_" & tableName Then MessageBox.Show("Before dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count) Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped) MessageBox.Show("After dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count) End If Next But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column. 3 step: I save the dsv to the server. If Mainform.tDatabase.DataSourceViews.Count > 0 Then Mainform.tDatabase.DataSourceViews(0).Update(Microsoft.AnalysisServices.UpdateOptions.ExpandFull) End If Then I check the server, the dsv still include the columnname I have deleted. Why and how to update the dsv after I delete a column Thanks! Tag: Maintenance Tasks didn't install
  - 2
    - File System Error after Restore Hi Guys, I have issues in restoring our Analysis Services database. Any help will be great. I took backups of our production olap database and Unfortunately, I had to restore next day and it didn't worked out very well. Restore process was successful but when I tried to Query database I was getting error - "File system error: The following error occurred while the \\ \F:\Program File( x86)\ Microsoft SQL Server\MSSQL.2\OLAP\Data\<Olap db name>.0.db\<Cube name>.0.cub\...........\4.fact.data' ... My cubes have 4 partitions. I used SSMS to back and restore. Used compressed option only. Let me know if I need to put more information. Thank you - Ashok Tag: Maintenance Tasks didn't install
  - 3
    - Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly: When I access http://<server>/ReportServer , I see the server name of my SharePoint site. When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007). The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue. How does one create a data source that will allow reporting over SharePoint content with the setup described above And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information. Tag: Maintenance Tasks didn't install
  - 4
    - Parameter Valid Values I am deploying an rdl that is being deployed in a server.But i am encountering a problem regarding the valid values of the parameter.My parameters have dependencies,and one of my parameter comes out with two dependencies. Scenario : User needs to input his userID to access Book A. Book B needs Book A because the output will be depending on the its content. And Book C depend on Book B. Problem: when deploying, only Book A will have the initial value.The dependency in Book B is only one,which is fine.It shows its valid values. But how about for Book C which have 2 dependencies Because it doesnt show it's valid values.. Tag: Maintenance Tasks didn't install
  - 5
    - Upgrading to SQLServer2005 hi, I'm using custom authorization in reporting services 2000 to restrict the users. To do this we created a dll customauthorization.dll and placed it in reportserver bin folder and performed changes in rsreportserver.config, rssrvpolicy.config, and web.config files. Now its time to upgrade our servers to SQLServer 2005. Now in SQLServer2005 what new enhancements were done with respect to security and what all extra steps should i follow to perform the upgradation with custom authorization. Please give me suggestions how to upgrade my reports to SQL2005 so that my custom authorization still works. waiting for ur valuable inputs uday Tag: Maintenance Tasks didn't install
  - 6
    - String Type Multi-Valued Parameter Issue Hi There. I have a Multi-valued parameter that is a string type and it freaks out when a do a select all from my drop down list. I suspect it has something to do with size as it works great if a pick a reasonable amount of items. My parameter list is populated by 1463 items of 12 characters each. Is there a threshold I should have to worry about Thanks, Mike Tag: Maintenance Tasks didn't install
  - 7
    - Problem attaching DB from Network Share Hello All, I 'm trying to attach a database to my sql server 2005 using the following syntax: Code Snippet DBCC TRACEON(1807, -1) GO EXEC sp_attach_single_file_db 'MyNetworkDB', '\\leaf7\dbs\MyNetworkDB.mdf' GO Also, the folder dbs and the mdf file MyNetworkDB.mdf has full permission for Everyone .And when executing the above statement, i get the following error: Code Snippet DBCC execution completed. If DBCC printed error messages, contact your system administrator. Msg 5133, Level 16, State 1, Line 1 Directory lookup for the file "\\leaf7\dbs\MyNetworkDB.mdf" failed with the operating system error 5(Access is denied.). Tag: Maintenance Tasks didn't install
  - 8
    - Algorithm used to encrypt password in sysxlogin Hi, Does anyone know which algorithm is being used to encrypt the passwords in the sysxlogins for SQL Server 2000 I've been googling for some time..but I can't seem to find this information. Please help. Many thanks, Leona Tag: Maintenance Tasks didn't install
  - 9
    - Help!- Image display problem with SSRS report in IE 6 I have a report that has both data and graph. I call the SSRS API to get the report in MHTML format and use Response.BinaryWrite to output the resultant byte array. I also set the Response.ContentType = "message/rfc822". The browser renders the data correctly but shows the image as blank I have also tried setting the above to "multipart/related".. but this doesn't work as well. The above problem is replicated in IE 6. Things work fine in IE 7.0. Can someone please help out Thanks in advance. Naresh Tag: Maintenance Tasks didn't install
  - 10
    - Line location as expression Is it possible to move lines based on the values from dataset(trying to draw graph kinda thing by joining points using lines) Let me know if I am not clear here. Thanks Tag: Maintenance Tasks didn't install
  - 11
    - Capacity Of SQL Server Hi, Could you please advise below: 1. storage capacity of SQL server in terms of : a) No. of records b) In terms of memory 2. Licencing fees for 1 pc for single user Thanks Amir Tag: Maintenance Tasks didn't install
  - 12
    - "Select all" as default for a multi-value parameter which source is non-query Hi, I have report parameter and its values are static lik (ABC, DEF, GHI ) etc. I want to select all as a default for this parameter. How I can do this Tag: Maintenance Tasks didn't install
  - 13
    - Performance issues with aggregations at lowest level using DESCENDANTS with LEAVES flag I ran into what appears to be a rounding issue in a calculated member, where at the leaf level the calculation would be correct but at any level higher would not sum up correctly to the amount of the invidiual members below. The code looked like this: Code Snippet CREATE MEMBER CURRENTCUBE.[Measures].[Price Per Unit] AS ROUND((([Measures].[Units Sold] / [Measures].[Price Per Unit]) - [Measures].[Item Price]), 5) , VISIBLE = 1; I tried this with and withough the ROUND, and could never get it to aggregate up correctly. What I resorted to was forcing the calculation to go to the leaf level of every relevant dimension in the cube and aggregate up from there: Code Snippet CREATE MEMBER CURRENTCUBE.[Measures].[Price Per Unit LEAVES TEST] AS ROUND( SUM( ( { Descendants([Products].[Products].CurrentMember, , LEAVES) }, { Descendants([Channel].[Channel Level].CurrentMember , , LEAVES) }, { Descendants([Time].[Calendar].CurrentMember, , LEAVES) } ), ROUND((([Measures].[Units Sold] / [Measures].[Price Per Unit]) - [Measures].[Item Price]), 5) ), 5) , VISIBLE = 1; Note that the above example is only a few of the dimension in my cube; my real statement has ALL of them which is ~ 20. As expected, this performs very slowly but gives me accurate results at the aggregated and leaf levels when browsing the cube. I'm looking for a way to make this more performant, either through a different approach or something I could do on the design side to improve query response time. There is a reference at ( http://www.mosha.com/msolap/articles/mdxperformanceofaggregation.htm ) that indicates a possible solution to improve performance would be something like: ({[Measures].[Dollars Sold]}, Leaves()) = [Measures].[Units Sold] * [Measures].[Last Update of Price]; However I can not figure out how to structure this as a calculated member statement. Your help / insight is much appreciated! Tag: Maintenance Tasks didn't install
  - 14
    - Time Series only predicts one step I have a relational table with daily sales for 364 days (52 week span) for 60 stores. I have created a Microsoft Time Series model using store as the case and the historical/actual line charts appear in the Charts viewer for each store. But only one prediction step is shown no matter how many prediction steps I select. I have tried this with an OLAP-based model and also tried a simple DMX query, all with the same result. Thank you in advance for any help with this. P Taylor Tag: Maintenance Tasks didn't install
  - 15
    - How to execute a SQL query only once in a data flow task Hi Everyone, In the data flow task, i have thosands of rows flowing, now just before inserting these rows into a table, i want to delete some rows in the destination table. For this, if i use the oledb command, then it will run several times. I think a script can do it but I want to avoid it because it would be an inefficient affair. Please post your suggestions on this. Regards, Manu Tag: Maintenance Tasks didn't install
  - 16
    - Custom Data Extension - Connection Problems Target: RS2000, Oracle-DB I build a CDE on the base of the FSi-Example. Deploying worked fine here is the problem: I build a new shared data source, but can't edit the connection string. the button disables itself. why Therefore I copied the string from an existing datasource. I supplied the auth-data and all seemed to be fine. when i want to build a dataset with this datasource, I get something like this: "no connection to database possible check connection string and test connection. " But this is not possible because of the disabled edit button. Can anyone help please What's wrong dev-pc and server are not the same machine. I made the following changes to the config-files: rspreviewpolicy.config Code Snippet <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="CDECodeGroup" Description="Code group for my Custom data processing extension"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Programme\Microsoft SQL Server\80\Tools\Bin\Microsoft.Samples.ReportingServices.CustomDataExtension.dll" /> </CodeGroup> RSReportDesigner.config Code Snippet <Extension Name="CDE Test Ext" Type="Microsoft.Samples.ReportingServices.CustomDataExtension.CustomConnection,Microsoft.Samples.ReportingServices.CustomDataExtension"/> <Extension Name="CDE Test Ext" Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.ReportingServices.Designer"/> rssrvpolicy.config Code Snippet <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="CDECodeGroup" Description="Code group for my Custom data processing extension"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomDataExtension.dll" /> </CodeGroup> RSReportServer.config Code Snippet <Extension Name="CDE Test Ext" Type="Microsoft.Samples.ReportingServices.CustomDataExtension.CustomConnection,Microsoft.Samples.ReportingServices.CustomDataExtension"/> Tag: Maintenance Tasks didn't install

tim.graham&#64;sydneysymphony.com

Hi There

I have just done my first clean install of SQL 2005. I have previously upgraded several boxes from SQL 2000 without incident.

The clean install seemed to go fine but the Maintenance Tasks didn't install I have looked on the web but have been unable to unearth any information. Has anyone encountered this before and if so I how do I add Maintenance Tasks to the Management folder

Re: Maintenance Tasks didn't install

Deepak Rangarajan

Have you installed Integration services SSIS is it shown in configuration manager. I think you neeed ot as all the maintenance plans in sql 2005 is configured to run as a SSIS package !

Re: Maintenance Tasks didn't install

Madhu K Nair

Which Edition is this. SQL Server Express does not have SSIS mind it. If its not Express, make sure that SP2 is installed to finction MP properly. If you create Maintenance Plan its stores as SSIS Package.

Madhu

Re: Maintenance Tasks didn't install

tim.graham@sydneysymphony.com

It is SQL 2005 Standard edition. Both Integration Services and SP2 are installed. How do I access the SSIS packages

Tim

Re: Maintenance Tasks didn't install

Deepak Rangarajan

Have you created maintenance plans in sql 2005 if yes then it will be created as a SSIS package. Pls refer the link,
http://technet.microsoft.com/en-us/library/ms189953.aspx to create maintenance plan. http://msdn2.microsoft.com/en-us/library/ms137847.aspx. Just double click the maintenance plan and you can view the contents and tasks involved in the package.

Regards
Deepak

Re: Maintenance Tasks didn't install

Ekrem Önsoy

Is not there a node named "Maintanence Plans" under Management node when you open up SSMS

What makes you think that your SQL Server installation is lack of Maintanence Plans

Re: Maintenance Tasks didn't install

Ekrem Önsoy

Today, I realized that if you do not have sysadmin server fixed role, Maintanence Plan does not appear under Management in SSMS. This could be your issue. Can you confirm