Exporting Report Data to Case Management System

I work for a large government organisation and I have built several reports
that enable clients to drill down to case level which they love. The problem
is that now they all want to be able to "push a button" and send the cases to
a case management system. I know how to write the code to send the cases to
the case management system tables but I don't know how to enable the client
to be able to trigger it from the report interface. Any assistance would be
much appreciated!Well this depends on how you want to do it... right now I assume they view
the reports from a browser right? If so, you may want to look into
customizing a front end to view the reports - or you can simply create a
smart client where you have a button on a form and the reports are listed
that can be exported to the case management system.
The last option is to create a delivery extension, which I think would be
the best thing to do, you select the report, and the new output to render to
if you will. :)
=-Chris
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:1BCF18A3-5568-41F7-B69B-A948828A0625@.microsoft.com...
>I work for a large government organisation and I have built several reports
> that enable clients to drill down to case level which they love. The
> problem
> is that now they all want to be able to "push a button" and send the cases
> to
> a case management system. I know how to write the code to send the cases
> to
> the case management system tables but I don't know how to enable the
> client
> to be able to trigger it from the report interface. Any assistance would
> be
> much appreciated!

Exporting Jobs in SQL Server Agent

Hello,
We have about 20 Jobs in the SQL Server Agent, under the Management section
of the Enterprise Manager tree that run on different schedules daily. We're
moving to a new server and I can't seem to find a way or a tool that will
let me copy the jobs to the new server. Does anyone know if there is a way
or a tool for such a task? We can redo them manually but thought I would ask
first before we started. We're on SQL2K. Thanks for any information you may
be able to give me.
RGPyou can right click on the job and choose Generate SQL Script...
btw, jobs are saved in msdb. :-)
"riley" <riley3@.microtek-sales.com> wrote in message
news:%23lSae4BxDHA.1060@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We have about 20 Jobs in the SQL Server Agent, under the Management
section
> of the Enterprise Manager tree that run on different schedules daily.
We're
> moving to a new server and I can't seem to find a way or a tool that will
> let me copy the jobs to the new server. Does anyone know if there is a way
> or a tool for such a task? We can redo them manually but thought I would
ask
> first before we started. We're on SQL2K. Thanks for any information you
may
> be able to give me.
> RGP
>|||Right click the Jobs under Management | SQL Server Agent
for that SQL Server instance, select All Tasks -> Generate
SQL Scripts ..., and save the SQL script for all the local
jobs.
You can then run this generated script on a differen
server to re-create the jobs. You may need to edit the
script somewhat if the script contains references that are
not valid on this other server.
Linchi
>--Original Message--
>Hello,
>We have about 20 Jobs in the SQL Server Agent, under the
Management section
>of the Enterprise Manager tree that run on different
schedules daily. We're
>moving to a new server and I can't seem to find a way or
a tool that will
>let me copy the jobs to the new server. Does anyone know
if there is a way
>or a tool for such a task? We can redo them manually but
thought I would ask
>first before we started. We're on SQL2K. Thanks for any
information you may
>be able to give me.
>RGP
>
>.
>|||Thank you very much -I didn't realize the Generate SQL Scripts was for that
purpose. Appreciate the help.
RGP
"NEW NAME, OLD GUY" <PLEASE!> wrote in message
news:O4vnJFCxDHA.3436@.tk2msftngp13.phx.gbl...
> you can right click on the job and choose Generate SQL Script...
> btw, jobs are saved in msdb. :-)
> "riley" <riley3@.microtek-sales.com> wrote in message
> news:%23lSae4BxDHA.1060@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> > We have about 20 Jobs in the SQL Server Agent, under the Management
> section
> > of the Enterprise Manager tree that run on different schedules daily.
> We're
> > moving to a new server and I can't seem to find a way or a tool that
will
> > let me copy the jobs to the new server. Does anyone know if there is a
way
> > or a tool for such a task? We can redo them manually but thought I would
> ask
> > first before we started. We're on SQL2K. Thanks for any information you
> may
> > be able to give me.
> > RGP
> >
> >
>

Exporting a table to a file -reg

Dear Friends,
I am having Sql Server 2005 Express Edition. Also I have installed "Sql
Server Management Studio Express".
In "Sql Server Management Studio Express", how to export a table to a csv
file, or to another table?
Thanks & Regards,
Thirumalai.Hi
Use AdventureWorks
--Import to another table
SELECT * INTO Person.Address_New FROM
Person.Address
SELECT * FROM Person.Address_New
--Import to the file
exec master..xp_cmdshell 'BCP AdventureWorks.Person.Address_New OUT
c:\test1.txt -c -C850 -SSERVER\SQLSERVERDEV2005 -Usa -Ppwd'
"Thirumalai" <thirumalai@.cspl.com> wrote in message
news:eiQpaM$SGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Dear Friends,
> I am having Sql Server 2005 Express Edition. Also I have installed "Sql
> Server Management Studio Express".
> In "Sql Server Management Studio Express", how to export a table to a csv
> file, or to another table?
> Thanks & Regards,
> Thirumalai.
>
>

Exportin database

Hello,

I have database on MS SQL SERVER and I want to expert it and send by e-mail.

How can I do exporting database in MS SQL SERVER Management studio express.

thank you Martina

You mean you want to send an entire db via email? Can you explain more what you are attempting to do? Coz emailing a DB is not a proper option, IMHO.|||

So how can I export the database and send ?

|||

Hi,

Maybe I'm not sure what you want, but one way you should try is to backup your local database and send the backup file by emal. If you want to import the database into other SQL Server, you can restore the backup file. If I've misunderstood your question,please feel free to reply. Thanks.

|||

martinaV:

So how can I export the database and send ?

SQL server 2000

right click on your database ... select all task.. then select backup database. .... add the destination "filename.bak" then click ok... and follow new steps.

export Strored procedures in MS sql server Management studio

Hi,

Can anyone tell me how to export a batch of stored procedures in MS sql server Management studio?

Thanks.

Right click the database

Tasks > generate Script > Choose the appropiate object types in the wizard.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

export SQLExpress2005 to Access/Excel?

it seems that the SQLExpress2005 Management Studio Express has no DTS
functionality ... is there a way to automatically export an SQLExpress2005
database (or parts of it) to Access and/or Excel ?
thanks
-Michael
hi Michael,
Michael Peters wrote:
> it seems that the SQLExpress2005 Management Studio Express has no DTS
> functionality ... is there a way to automatically export an
> SQLExpress2005 database (or parts of it) to Access and/or Excel ?
>
not directly, but if you have and already created Access database or Excel
file, you can import/export via linked server,
http://msdn2.microsoft.com/en-us/library/ms190479.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply