embedding RS into a java (j2ee) application

Can anyone point me to some useful information on embedding reports into a
java (J2EE) application?
StephanieNot specifically but I can tell you your options. There are three ways to
integrate reports into an application: roll your own with web services, use
URL integration, use the reportviewer control that comes with VS 2005. Of
these you can use the first two. The control is a 2.0 framework control and
is of no use to you.
The easiest is URL access(search BOL for URL).
Report Manager itself uses web services (Report Manager is really just a
portal that ships with RS. It does nothing that you can't do yourself with
published web services)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
> Can anyone point me to some useful information on embedding reports into a
> java (J2EE) application?
> Stephanie|||Thanks, Bruce. I can see how you can hide the Toolbar if you want to
(&rc:Toolbar=false). Is there a way to hide sections above the toolbar?
Basically, I want the user to only see the Toolbar and below within the app.
Perhaps the application can manage the Back button functionality?
Also, another quick question: Can you hide the report header and footer with
this sort of option or would you have to add hidden parameters to do that?
Some reports are used within the app and outside the app. When inside the
app, I do not want the report header and footer to show. I'm thinking I have
to add yet another hidden parameter.
S.
"Bruce L-C [MVP]" wrote:
> Not specifically but I can tell you your options. There are three ways to
> integrate reports into an application: roll your own with web services, use
> URL integration, use the reportviewer control that comes with VS 2005. Of
> these you can use the first two. The control is a 2.0 framework control and
> is of no use to you.
> The easiest is URL access(search BOL for URL).
> Report Manager itself uses web services (Report Manager is really just a
> portal that ships with RS. It does nothing that you can't do yourself with
> published web services)
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
> > Can anyone point me to some useful information on embedding reports into a
> > java (J2EE) application?
> >
> > Stephanie
>
>|||You can hid the parameter area too. This link shows the things you can
control for the html viewer. I tend to hide the parameter area but not the
toolbar.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/1c3e680a-83ea-4979-8e79-fa2337ae12a3.htm
Correct about the hidden parameter for the report header and footer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:DD1721F3-3164-479A-BB25-AB4218CA6E40@.microsoft.com...
> Thanks, Bruce. I can see how you can hide the Toolbar if you want to
> (&rc:Toolbar=false). Is there a way to hide sections above the toolbar?
> Basically, I want the user to only see the Toolbar and below within the
> app.
> Perhaps the application can manage the Back button functionality?
> Also, another quick question: Can you hide the report header and footer
> with
> this sort of option or would you have to add hidden parameters to do that?
> Some reports are used within the app and outside the app. When inside the
> app, I do not want the report header and footer to show. I'm thinking I
> have
> to add yet another hidden parameter.
> S.
> "Bruce L-C [MVP]" wrote:
>> Not specifically but I can tell you your options. There are three ways to
>> integrate reports into an application: roll your own with web services,
>> use
>> URL integration, use the reportviewer control that comes with VS 2005. Of
>> these you can use the first two. The control is a 2.0 framework control
>> and
>> is of no use to you.
>> The easiest is URL access(search BOL for URL).
>> Report Manager itself uses web services (Report Manager is really just a
>> portal that ships with RS. It does nothing that you can't do yourself
>> with
>> published web services)
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
>> > Can anyone point me to some useful information on embedding reports
>> > into a
>> > java (J2EE) application?
>> >
>> > Stephanie
>>

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
Graham (Pete) Berry
PeteBerry@.Caltech.edu
|||Sorry should have said:
2005
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:

> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||Sorry should have said:
2005
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:
> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> > Hello all,
> >
> > Can someone point me to a site that takes you thru the steps involve in
> > setting up the following;
> > We want the server to email a list of admins when the system is having
> > problems.
> >
> > Thanks
> >
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||Sorry should have said:
2005
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:

> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do thi
s
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?

Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do this
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?
From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?
sql

Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do this
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
--
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?

Elusive Backup Process

Howdy Folks,

I have recently taken over looking after this machine & the previous guardian is unavailable. I've got to a point where I'm starting to think about looking into MSDB, but am not overly keen to start reviewing this db for obvious reasons... Can anyone please offer advise ?

Thank In Advance
Suze.

Environment: Microsoft SQL Server 2000 - 8.00.760 (sp3) on Win2000
H/W Dell PowerEdge 2550

Issue: Discovered in the sql log that there is a second set of bkps occurring around 7:30am - the bkps we have setup, run at 2am & are also being logged to sql log as completing normally.

The 7:30am bkps appear to be backing up to a remote location using pipes... or at a guess an agent ?? (I don't know know what that looks like cos we don't use agents). We backup db's to disk and then let arcserve pick up those backup files later.

I assume that this has been occurring for some time, sql logs back to July 7 advise so... Unable to locate scheduled job / maintenance plan that runs at this time...

Last night I set up a trace to catch it but that hasn't helped me either, apart from telling me that its an internal process to the server, and that the process actually started at 6:50am.

SQL LOGS Entries between midnight & 8am in attached file:

Trace contents in attached zip file:Someone had the sql agent installed on this server previously. It appears that the NT backup person still had it selected in the backup as well as the backups to disk. We have now removed this & shall wait and see tonight but I guess I now know what a remote agent arcserve backup looks like.

Cheers

Electrical Symbols - Ohms - micro

Hi,
would anyone be able to point me in the right direction on how to save
the
electrical symbols for ohms and micro in a sql server field.
Many thanks,Make sure you use NVARCHAR, and pass the character in a string with the N
prefix.
CREATE TABLE dbo.foo
(
symbol NVARCHAR(32)
);
GO
INSERT dbo.foo
SELECT N''; -- not sure if this will be correct in your newsreader
GO
SELECT symbol FROM dbo.foo;
GO
DROP TABLE foo;
GO
"Jedawi" <jedawi@.hotmail.co.uk> wrote in message
news:eK9ZVWkBGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi,
> would anyone be able to point me in the right direction on how to save
> the
> electrical symbols for ohms and micro in a sql server field.
> Many thanks,
>
>|||Many thanks Aaron, works a treat..
Cheers
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uVLElYkBGHA.1008@.TK2MSFTNGP12.phx.gbl...
> Make sure you use NVARCHAR, and pass the character in a string with the N
> prefix.
> CREATE TABLE dbo.foo
> (
> symbol NVARCHAR(32)
> );
> GO
> INSERT dbo.foo
> SELECT N''; -- not sure if this will be correct in your newsreader
> GO
> SELECT symbol FROM dbo.foo;
> GO
> DROP TABLE foo;
> GO
>
>
> "Jedawi" <jedawi@.hotmail.co.uk> wrote in message
> news:eK9ZVWkBGHA.1288@.TK2MSFTNGP09.phx.gbl...
>

Edition Compatibility

Hi all,
I am under the impression that one can not Log Ship from enterprise edition to standard edition. Anyone have any documentation they can point me to?
TIA,
SQLPoet

The problem is Log Shipping comes with only the Enterprise edition not the standard but you can use the backup and restore wizard to do most of what you do with Log shipping. Try the links below for Microsoft provided Log shipping tutorial and another with the advantages and disadvantages of Log Shipping. Hope this helps.
http://www.informit.com/articles/article.asp?p=331402&rl=1

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx

|||Thanks Gift...
I do understand that it comes with enterprise. The question is can I log ship from enterprise to standard if I never plan to promote the standard copy?
SQLPoet|||The answer is no because Log Shipping is not part of the Standard Edition. That is the reason I gave you the first link because it explains the alternative of the none production Developer edition which comes with Log Shipping. Hope this helps.