Lowering priority: shown

Showing posts with label shown. Show all posts

Friday, March 30, 2012

Maintenance Plan folder not shown in Management Folder

Hi,
I have a problem on just one server : The Management folder in
Enterprise Manager does not contain a folder for Maintenance plans. I
have created a plan by right clicking on a db, all tasks > maintenance
plan, but I have no way of editing this as it is not displayed
anywhere. I know I can edit the individual jobs that appear in the
Jobs folder, but I'd like to know why the maintenance plan folder is
not shown. It's not possible to re-install SQL, I would appreciate any
help.
Thanks
Kev.Perhaps just a refresh problem? Have you tried to restart Enterprise Manager?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kev smart" <kev@.earlshilton.com> wrote in message
news:13f1d9b4.0504040344.640c89ad@.posting.google.com...
> Hi,
> I have a problem on just one server : The Management folder in
> Enterprise Manager does not contain a folder for Maintenance plans. I
> have created a plan by right clicking on a db, all tasks > maintenance
> plan, but I have no way of editing this as it is not displayed
> anywhere. I know I can edit the individual jobs that appear in the
> Jobs folder, but I'd like to know why the maintenance plan folder is
> not shown. It's not possible to re-install SQL, I would appreciate any
> help.
> Thanks
> Kev.|||Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
right in thinking that the maintenance plan option should be added when
applying sp3a?
Thanks
Kev|||I'm not sure, I haven't used EM against MSDE. Give it a spin and see...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nsiadmin" <kev@.earlshilton.com> wrote in message
news:1112621866.677876.74970@.l41g2000cwc.googlegroups.com...
> Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
> right in thinking that the maintenance plan option should be added when
> applying sp3a?
> Thanks
> Kev
>|||I applied sp3adesk, wrote output to a log file which ends with
(snip)
Property(C): DATABASE = C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\6c801f.msi
Property(C): OriginalDatabase = D:\sql2ksp3\MSDE\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): QFEUpgrade = 1
Property(C): Preselected = 1
Property(C): ACTION = INSTALL
=== Logging stopped: 4/5/2005 7:18:49 ===MSI (c) (C4:CC): Note: 1: 1728
MSI (c) (C4:CC): Product: Microsoft SQL Server Desktop Engine --
Configuration completed successfully.
MSI (c) (C4:CC): Grabbed execution mutex.
MSI (c) (C4:CC): Cleaning up uninstalled install packages, if any exist
MSI (c) (C4:CC): MainEngineThread is returning 0
=== Verbose logging stopped: 4/5/2005 7:18:49 ===
Which looks like a successful install, but after rebooting the server and
going back into enterprise manager, there is still no Maintenance Plan folder
and the server properties ( and @.@.version ) show the version as sql2000
8.00.194 RTM as though no service pack installed.
Getting desperate....... Kev.
"Tibor Karaszi" wrote:
> I'm not sure, I haven't used EM against MSDE. Give it a spin and see...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nsiadmin" <kev@.earlshilton.com> wrote in message
> news:1112621866.677876.74970@.l41g2000cwc.googlegroups.com...
> > Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
> > right in thinking that the maintenance plan option should be added when
> > applying sp3a?
> >
> > Thanks
> >
> > Kev
> >
>
>|||Have you checked whether the maint wiz is included in msde? I'm not sure it is...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevsmart" <kevsmart@.discussions.microsoft.com> wrote in message
news:711B7170-7B9F-4570-B40B-8023EECD1A56@.microsoft.com...
>I applied sp3adesk, wrote output to a log file which ends with
> (snip)
> Property(C): DATABASE = C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\6c801f.msi
> Property(C): OriginalDatabase = D:\sql2ksp3\MSDE\Setup\SqlRun01.msi
> Property(C): UILevel = 3
> Property(C): QFEUpgrade = 1
> Property(C): Preselected = 1
> Property(C): ACTION = INSTALL
> === Logging stopped: 4/5/2005 7:18:49 ===> MSI (c) (C4:CC): Note: 1: 1728
> MSI (c) (C4:CC): Product: Microsoft SQL Server Desktop Engine --
> Configuration completed successfully.
> MSI (c) (C4:CC): Grabbed execution mutex.
> MSI (c) (C4:CC): Cleaning up uninstalled install packages, if any exist
> MSI (c) (C4:CC): MainEngineThread is returning 0
> === Verbose logging stopped: 4/5/2005 7:18:49 ===>
> Which looks like a successful install, but after rebooting the server and
> going back into enterprise manager, there is still no Maintenance Plan folder
> and the server properties ( and @.@.version ) show the version as sql2000
> 8.00.194 RTM as though no service pack installed.
>
> Getting desperate....... Kev.
>
> "Tibor Karaszi" wrote:
>> I'm not sure, I haven't used EM against MSDE. Give it a spin and see...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "nsiadmin" <kev@.earlshilton.com> wrote in message
>> news:1112621866.677876.74970@.l41g2000cwc.googlegroups.com...
>> > Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
>> > right in thinking that the maintenance plan option should be added when
>> > applying sp3a?
>> >
>> > Thanks
>> >
>> > Kev
>> >
>>|||The wizard is there because it is accessible by right clicking the db name,
all tasks, maintenance plan. However although this creates the plan and jobs,
it wont run because there is no sqlmaint.exe in the binn folder. Once this is
copied in (from any other SQL installation ) the next plan to be created will
generate the Maintenance Plan folder under Management. Problem solved!
Thanks
Kev
"Tibor Karaszi" wrote:
> Have you checked whether the maint wiz is included in msde? I'm not sure it is...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kevsmart" <kevsmart@.discussions.microsoft.com> wrote in message
> news:711B7170-7B9F-4570-B40B-8023EECD1A56@.microsoft.com...
> >I applied sp3adesk, wrote output to a log file which ends with
> >
> > (snip)
> > Property(C): DATABASE = C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\6c801f.msi
> > Property(C): OriginalDatabase = D:\sql2ksp3\MSDE\Setup\SqlRun01.msi
> > Property(C): UILevel = 3
> > Property(C): QFEUpgrade = 1
> > Property(C): Preselected = 1
> > Property(C): ACTION = INSTALL
> > === Logging stopped: 4/5/2005 7:18:49 ===> > MSI (c) (C4:CC): Note: 1: 1728
> > MSI (c) (C4:CC): Product: Microsoft SQL Server Desktop Engine --
> > Configuration completed successfully.
> >
> > MSI (c) (C4:CC): Grabbed execution mutex.
> > MSI (c) (C4:CC): Cleaning up uninstalled install packages, if any exist
> > MSI (c) (C4:CC): MainEngineThread is returning 0
> > === Verbose logging stopped: 4/5/2005 7:18:49 ===> >
> >
> > Which looks like a successful install, but after rebooting the server and
> > going back into enterprise manager, there is still no Maintenance Plan folder
> > and the server properties ( and @.@.version ) show the version as sql2000
> > 8.00.194 RTM as though no service pack installed.
> >
> >
> > Getting desperate....... Kev.
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> I'm not sure, I haven't used EM against MSDE. Give it a spin and see...
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "nsiadmin" <kev@.earlshilton.com> wrote in message
> >> news:1112621866.677876.74970@.l41g2000cwc.googlegroups.com...
> >> > Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
> >> > right in thinking that the maintenance plan option should be added when
> >> > applying sp3a?
> >> >
> >> > Thanks
> >> >
> >> > Kev
> >> >
> >>
> >>
> >>
>
>sql

Monday, February 20, 2012

my data base table is as follow

Hi, my data base table is as follows

PersonID City Sex 1 New York M 2 Boston M 3 Seatle F

and i need to make a report as shown below:

Male

Female Total % Male City

New York 5 8 13 38% Boston 20 35 55 36% Seatle 10 6 16 63%

I'm assuming i need to use a matrix, but how can i get a total and a % column

You can use a standard table for this. To get the total just use an expression to add male and female together. To get the percentage, once again use an expression to evaluate (male/total)*100.

|||Hi sluggy

I am new to reporting services and about to start creating some (matrix) reports. I am interested in your comment that the example above can be created using a tabular report.

I wonder if you could help me out on this scenario:
Say I have a db table with sales for a particular year. (i.e 2003 and 2004). Sol the database table is: field1 = Sales, field2 = Date ( assume the years are static )
Using a tabular report is it possible to calculate the sums for each...? This effectivly what a matrix report would do very well as it allows grouping by columns.

Any response would be greatly appreciated.

Regards,
Neil
|||You could still use a tabular report for eachyear. Matrix reports are when you have information for rows, columns, details (and page header which is optional). In your case, you just have Rows (which will be Date) and Sales (which is column name) and SUM(Sales) group by year (which will be your table details)|||

NeilSt wrote:

Using a tabular report is it possible to calculate the sums for each...?

It sure is - there are many posts on this forum explaining how to do a total row on a table. Totalling is done at the group level, so you can have subtotals within grand totals.

NeilSt wrote:

This effectivly what a matrix report would do very well as it allows grouping by columns.

A matrix is more for when you have a dynamic number of columns. In your prior example, you could use a matrix if Male, Female, Male percentage and Total were on the rows and you had a column grouping on state. But it is just as easy to do it as a table, with Male/Female/etc being the columns and the states being the rows.

|||Hi

The answer to my post seems to assume that the Years field would be a row. I am saying... Row = sales and column = 2003 and 2004. Its more a column group that is required no ? if so how are they done in tabular reports ?

Maybe im missing something...

thanks for the help again.

Neil

Example:
2003 | 2004 | Total

Sales 100 | 50 | 150
now to get the total is fine i guess.. but sales is made up of a number of sales within the year. So its effectivly a sum of all sales in 2003... thats what im trying to work out how to do.

|||

Neil,

You can sum up your sales for all available years in the database in the SQL query itself like this:

(if you have stored the year in a separate column in the table)

SELECT SUM(Sales) AS Sales, Year

FROM SalesTable

GROUP BY Year

(if you have not stored the year in a separate column in the table but in a datetime column, us this)

SELECT SUM(Sales) AS Sales, YEAR(SalesDate) AS Year

FROM SalesTable

GROUP BY YEAR(SalesDate)

and in your matrix, add a row group on Sales field and column group on Year field.

Shyam

|||Shyam,

Yes that is possible, I think when I first responded to this thread, I was mor einterested to know if its possible to do column grouping in tabular reports...? It seems that is what all this comes down to..

Thanks for your help.

Neil
|||Maybe someone can help me decide which style of report makes sense for this mockup of a report:
Columns: Jan - Dec
Rows: City

So lets say we can to find the number of sales for a city form Jan to Dec...
So looking something like,

nyc: 1 2 3 3 3 3 15 3 4 x
nj: 1 1 1 1 1 1 6 1 1 x
la: 2 2 2 2 2 2 12 2 5 x

So which is the best report type to use.. ? Matrix supports column grouping ... tabular only supports row grouping from what I can tell...

each record in the db contains a month , sale value and city...

I leave it up to you all to let me know which one is best suited (tabular/matrix)

Neil
|||

Of course Matrix is suitable. But your report layout woulc make more sense if you could have an additional ROW grouping on Year besides City .

Shyam

|||Hey man.

Thanks again, maybe you can explain to me how one can work out the Total for years column...
which calculates the sum of each row.. This is a limitation of the tabular report (no column grouping) ?

Maybe you could point me in the right direction for this situation: Say i have under each row group, subtotals. But for every detail textbox I check the month of that record and only display it in the appropriate column (jan or feb etc..) how can I get the row group sub total to produce a result for each month.. and not a subtotal of the row group (city), I guess this can be done using a SQL query but im wondering if RS can provide some support for it...

I require this table to have static columns and therefore using a matrix seems too limited.. And there are these small issues stopping me from knowing if its possible to implement using a tabular report...

Neil
|||

- Removed -

|||WOAH!

that is one heck of a thread jack. so anyone have an answer for my original question?
|||

I'm sorry, I didn't intend to thread-jack... I thought we were talking about similar things.

My apologies.

|||sorry

Friday, March 30, 2012

Maintenance Plan folder not shown in Management Folder

Maintenance Plan folder not shown in Management Folder

Maintenance Plan folder not shown in Management Folder

Monday, February 20, 2012

my data base table is as follow

Lowering priority

Blog Archive

About Me