Can multiple stored procs be printed all at once.

Can multiple stored procs be printed all at once.In Enterprise Manager,
choose all the SPs that you want to print,
right click one of the SPs and choose All Tasks/Generate SQL script
save the script to a file
open the file
print
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:B3A790D9-11B8-4032-93D4-F540FA7ECE89@.microsoft.com...
> Can multiple stored procs be printed all at once.

can I use MS Access reports on SQL Server 2000 db?

Hi,
I have a SQL Server 2000 db on which I would like to perform querys and have
pretty reports printed. Can I use MS Access (for the pretty reports) to
connect to the SQL Server 2000 db? If yes, can you please tell me how to
set up the connection?
Thanks,
Rogue Petunia"Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> Hi,
> I have a SQL Server 2000 db on which I would like to perform querys and
have
> pretty reports printed. Can I use MS Access (for the pretty reports) to
> connect to the SQL Server 2000 db? If yes, can you please tell me how to
> set up the connection?
--
Hi Rogue,
You can use the Access ADP to link data from SQL Server. The Access ADP uses
OLE-DB to connect to SQL Server.
For more details, please consult your Access doco's.
Hope this helps,
-Eric Cárdenas
SQL Server support|||Hi Eric,
Totally lost. Don't know what ADP is. Looked in Access Help, can't find
ADP.
Further details appreciated.
Thanks.
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:3fce4bf3$1@.news.microsoft.com...
> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> > Hi,
> > I have a SQL Server 2000 db on which I would like to perform querys and
> have
> > pretty reports printed. Can I use MS Access (for the pretty reports) to
> > connect to the SQL Server 2000 db? If yes, can you please tell me how
to
> > set up the connection?
> --
> Hi Rogue,
> You can use the Access ADP to link data from SQL Server. The Access ADP
uses
> OLE-DB to connect to SQL Server.
> For more details, please consult your Access doco's.
> Hope this helps,
> -Eric Cárdenas
> SQL Server support
>|||"Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> Hi Eric,
> Totally lost. Don't know what ADP is. Looked in Access Help, can't find
> ADP.
--
Hi Rogue,
ADP stands for "Access database project." The other Access file is MDB for
"Microsoft database." IIRC, the ADP was introduced in Access 2000.
The difference in the ADP and the MDB is that the ADP contains no data. The
ADP is purposely designed to use SQL Server (or any OLE-DB source). The MDB
can store data using Access tables. The MDB uses ODBC to connect to SQL
Server.
What version of MS Access will you use?
Let me know if you need more information.
--
Eric Cárdenas
SQL Server support|||Eric,
A co-worker just showed me how to do it. Sort of like a variation of "a
picture is worth a thousand words" ;) Now it totally makes sense.
thanks anyway,
Rogue Petunia
"Eric Cardenas - ANZ MSFT support" <anonymous@.discussions.microsoft.com>
wrote in message news:3fce5657$1@.news.microsoft.com...
> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
> > Hi Eric,
> > Totally lost. Don't know what ADP is. Looked in Access Help, can't
find
> > ADP.
> --
> Hi Rogue,
> ADP stands for "Access database project." The other Access file is MDB for
> "Microsoft database." IIRC, the ADP was introduced in Access 2000.
> The difference in the ADP and the MDB is that the ADP contains no data.
The
> ADP is purposely designed to use SQL Server (or any OLE-DB source). The
MDB
> can store data using Access tables. The MDB uses ODBC to connect to SQL
> Server.
> What version of MS Access will you use?
> Let me know if you need more information.
> --
> Eric Cárdenas
> SQL Server support
>|||You can also use an MDB. Base your reports on a pass-through query or
a query against a linked table/view.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Wed, 3 Dec 2003 16:55:28 -0500, "Rogue Petunia"
<roguepetunia@.NOSPAMnyc.rr.com> wrote:
>Eric,
>A co-worker just showed me how to do it. Sort of like a variation of "a
>picture is worth a thousand words" ;) Now it totally makes sense.
>thanks anyway,
>Rogue Petunia
>
>"Eric Cardenas - ANZ MSFT support" <anonymous@.discussions.microsoft.com>
>wrote in message news:3fce5657$1@.news.microsoft.com...
>> "Rogue Petunia" <roguepetunia@.NOSPAMnyc.rr.com> wrote:
>> > Hi Eric,
>> > Totally lost. Don't know what ADP is. Looked in Access Help, can't
>find
>> > ADP.
>> --
>> Hi Rogue,
>> ADP stands for "Access database project." The other Access file is MDB for
>> "Microsoft database." IIRC, the ADP was introduced in Access 2000.
>> The difference in the ADP and the MDB is that the ADP contains no data.
>The
>> ADP is purposely designed to use SQL Server (or any OLE-DB source). The
>MDB
>> can store data using Access tables. The MDB uses ODBC to connect to SQL
>> Server.
>> What version of MS Access will you use?
>> Let me know if you need more information.
>> --
>> Eric Cárdenas
>> SQL Server support
>>
>

Can I Update a SQL Database...

We have a SSRS report that needs to update a specific table in the SQL db it
is using to let us know when an invoice has been printed, and we'd like to
flag that specific invoice (or set of invoices). Is this possible?
I had thought about creating a stored procedure that gets called that really
doesn't return any required data, but could update the db, or custom code.
What would be the better approach? I've never connected/written to a db via
custom code before so any articles/samples you may know about and can provide
links to would be greatly appreciated.
Michael COn Oct 11, 11:44 am, Michael C <Micha...@.discussions.microsoft.com>
wrote:
> We have a SSRS report that needs to update a specific table in the SQL db it
> is using to let us know when an invoice has been printed, and we'd like to
> flag that specific invoice (or set of invoices). Is this possible?
> I had thought about creating a stored procedure that gets called that really
> doesn't return any required data, but could update the db, or custom code.
> What would be the better approach? I've never connected/written to a db via
> custom code before so any articles/samples you may know about and can provide
> links to would be greatly appreciated.
> Michael C
I have to agree that the idea you mentioned would be the best
alternative for performance and ease of change; however, if you want
to go the custom code route, here's a link that might be helpful.
http://msdn2.microsoft.com/en-us/library/ms155798.aspx
Of course, you would place the custom code in Layout view >> Report
drop-down >> Report Properties... >> Code. As far as I know, it
accepts pretty standard VB.NET code w/a few minor limitations. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks E!
As it turns out (I guess I miss understood the request) I need to try and
capture only the ones that are actually sent to the printer! Now I'm back to
square one with no idea how I'm going to do that. Any suggestions of how to
capture a print command in SSRS?
Michael C.
"EMartinez" wrote:
> On Oct 11, 11:44 am, Michael C <Micha...@.discussions.microsoft.com>
> wrote:
> > We have a SSRS report that needs to update a specific table in the SQL db it
> > is using to let us know when an invoice has been printed, and we'd like to
> > flag that specific invoice (or set of invoices). Is this possible?
> >
> > I had thought about creating a stored procedure that gets called that really
> > doesn't return any required data, but could update the db, or custom code.
> > What would be the better approach? I've never connected/written to a db via
> > custom code before so any articles/samples you may know about and can provide
> > links to would be greatly appreciated.
> >
> > Michael C
>
> I have to agree that the idea you mentioned would be the best
> alternative for performance and ease of change; however, if you want
> to go the custom code route, here's a link that might be helpful.
> http://msdn2.microsoft.com/en-us/library/ms155798.aspx
> Of course, you would place the custom code in Layout view >> Report
> drop-down >> Report Properties... >> Code. As far as I know, it
> accepts pretty standard VB.NET code w/a few minor limitations. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>