Lowering priority: contain

Showing posts with label contain. 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, March 12, 2012

Main report drive Subreports

Will SRS support passing parameters from the main report to the subreport
which calls a stored proc that does not contain any parameters ? it will
automatically filter the data without the where clause.
I used to be able to do this in Crystal reports which I don't need to
specify a where clause in my subreport stored proc and I am not sure if SRS
will support this and I hope that I don't need to rewrite all the stored proc
for this.
Need help on this one !
ThanksRS has two different ways of filtering the data. One is to use it as a query
filter. In this case the parameter would either part of the query or passed
to a stored procedure. SQL Server would then only return the necessary data
to the report. The other possibility is to use a filter. The filter has RS
filter the data. Whatever data is defined in the dataset goes to the report
and then the report filters the data. I stay away from this because it is
much more efficient for the database to send only the necessary records to
Reporting Services. However, it sound like you want to use filters.
You would do the following. Create a subreport with a parameter. Use the
parameter in your filter. When you embed the subreport into the report then
do a right mouse click on the subreport and map the report parameter to
whatever is appropriate on the main report.
So in your case the subreport has a dataset based on a stored procedure that
has no parameters. That dataset returns the data. Then using the report
parameter passed into it by the main report, the report takes the data from
the stored procedure and filters it.
Read up in book online on filtering. You can apply the filter in multiple
spots. The value you want to filter on would be an expression which is where
you would then reference the report parameter.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
> Will SRS support passing parameters from the main report to the subreport
> which calls a stored proc that does not contain any parameters ? it will
> automatically filter the data without the where clause.
> I used to be able to do this in Crystal reports which I don't need to
> specify a where clause in my subreport stored proc and I am not sure if
> SRS
> will support this and I hope that I don't need to rewrite all the stored
> proc
> for this.
> Need help on this one !
> Thanks|||Brian,
In my report parameter, it's either a single area or all areas. The filter
works good with one area, but when I select all areas I want to have all
recordset coming back. Is there a way to conditionally turn the filter on or
off ? I only need to filter if the user select a single area.
Thanks,
Eric
"Bruce L-C [MVP]" wrote:
> RS has two different ways of filtering the data. One is to use it as a query
> filter. In this case the parameter would either part of the query or passed
> to a stored procedure. SQL Server would then only return the necessary data
> to the report. The other possibility is to use a filter. The filter has RS
> filter the data. Whatever data is defined in the dataset goes to the report
> and then the report filters the data. I stay away from this because it is
> much more efficient for the database to send only the necessary records to
> Reporting Services. However, it sound like you want to use filters.
> You would do the following. Create a subreport with a parameter. Use the
> parameter in your filter. When you embed the subreport into the report then
> do a right mouse click on the subreport and map the report parameter to
> whatever is appropriate on the main report.
> So in your case the subreport has a dataset based on a stored procedure that
> has no parameters. That dataset returns the data. Then using the report
> parameter passed into it by the main report, the report takes the data from
> the stored procedure and filters it.
> Read up in book online on filtering. You can apply the filter in multiple
> spots. The value you want to filter on would be an expression which is where
> you would then reference the report parameter.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
> news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
> > Will SRS support passing parameters from the main report to the subreport
> > which calls a stored proc that does not contain any parameters ? it will
> > automatically filter the data without the where clause.
> >
> > I used to be able to do this in Crystal reports which I don't need to
> > specify a where clause in my subreport stored proc and I am not sure if
> > SRS
> > will support this and I hope that I don't need to rewrite all the stored
> > proc
> > for this.
> >
> > Need help on this one !
> >
> > Thanks
>
>|||The filter is an expression. You should be able to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
news:00C86BEC-B4EC-4A91-8E09-D4C549915CD7@.microsoft.com...
> Brian,
> In my report parameter, it's either a single area or all areas. The filter
> works good with one area, but when I select all areas I want to have all
> recordset coming back. Is there a way to conditionally turn the filter on
> or
> off ? I only need to filter if the user select a single area.
> Thanks,
> Eric
> "Bruce L-C [MVP]" wrote:
>> RS has two different ways of filtering the data. One is to use it as a
>> query
>> filter. In this case the parameter would either part of the query or
>> passed
>> to a stored procedure. SQL Server would then only return the necessary
>> data
>> to the report. The other possibility is to use a filter. The filter has
>> RS
>> filter the data. Whatever data is defined in the dataset goes to the
>> report
>> and then the report filters the data. I stay away from this because it is
>> much more efficient for the database to send only the necessary records
>> to
>> Reporting Services. However, it sound like you want to use filters.
>> You would do the following. Create a subreport with a parameter. Use the
>> parameter in your filter. When you embed the subreport into the report
>> then
>> do a right mouse click on the subreport and map the report parameter to
>> whatever is appropriate on the main report.
>> So in your case the subreport has a dataset based on a stored procedure
>> that
>> has no parameters. That dataset returns the data. Then using the report
>> parameter passed into it by the main report, the report takes the data
>> from
>> the stored procedure and filters it.
>> Read up in book online on filtering. You can apply the filter in multiple
>> spots. The value you want to filter on would be an expression which is
>> where
>> you would then reference the report parameter.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
>> news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
>> > Will SRS support passing parameters from the main report to the
>> > subreport
>> > which calls a stored proc that does not contain any parameters ? it
>> > will
>> > automatically filter the data without the where clause.
>> >
>> > I used to be able to do this in Crystal reports which I don't need to
>> > specify a where clause in my subreport stored proc and I am not sure if
>> > SRS
>> > will support this and I hope that I don't need to rewrite all the
>> > stored
>> > proc
>> > for this.
>> >
>> > Need help on this one !
>> >
>> > Thanks
>>|||Thanks for the quick reply. I am not sure how to do this.
The way the filter works is that:
In Expression, type or select the expression for the field that you want the
filter to evaluate.
In Operator, select the operator that you want the filter to use to compare
the evaluated field and the value.
In Value, type the expression or value against which you want the filter to
evaluate the value in Expression.
Seem like you always need to assign a value to a filter, so in the case of
all values , I don't want to have a filter and how will this work with
expression ?
"Bruce L-C [MVP]" wrote:
> The filter is an expression. You should be able to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
> news:00C86BEC-B4EC-4A91-8E09-D4C549915CD7@.microsoft.com...
> > Brian,
> >
> > In my report parameter, it's either a single area or all areas. The filter
> > works good with one area, but when I select all areas I want to have all
> > recordset coming back. Is there a way to conditionally turn the filter on
> > or
> > off ? I only need to filter if the user select a single area.
> >
> > Thanks,
> > Eric
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS has two different ways of filtering the data. One is to use it as a
> >> query
> >> filter. In this case the parameter would either part of the query or
> >> passed
> >> to a stored procedure. SQL Server would then only return the necessary
> >> data
> >> to the report. The other possibility is to use a filter. The filter has
> >> RS
> >> filter the data. Whatever data is defined in the dataset goes to the
> >> report
> >> and then the report filters the data. I stay away from this because it is
> >> much more efficient for the database to send only the necessary records
> >> to
> >> Reporting Services. However, it sound like you want to use filters.
> >>
> >> You would do the following. Create a subreport with a parameter. Use the
> >> parameter in your filter. When you embed the subreport into the report
> >> then
> >> do a right mouse click on the subreport and map the report parameter to
> >> whatever is appropriate on the main report.
> >>
> >> So in your case the subreport has a dataset based on a stored procedure
> >> that
> >> has no parameters. That dataset returns the data. Then using the report
> >> parameter passed into it by the main report, the report takes the data
> >> from
> >> the stored procedure and filters it.
> >>
> >> Read up in book online on filtering. You can apply the filter in multiple
> >> spots. The value you want to filter on would be an expression which is
> >> where
> >> you would then reference the report parameter.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
> >> news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
> >> > Will SRS support passing parameters from the main report to the
> >> > subreport
> >> > which calls a stored proc that does not contain any parameters ? it
> >> > will
> >> > automatically filter the data without the where clause.
> >> >
> >> > I used to be able to do this in Crystal reports which I don't need to
> >> > specify a where clause in my subreport stored proc and I am not sure if
> >> > SRS
> >> > will support this and I hope that I don't need to rewrite all the
> >> > stored
> >> > proc
> >> > for this.
> >> >
> >> > Need help on this one !
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>

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, March 12, 2012

Main report drive Subreports

Lowering priority

Blog Archive

About Me