Can anyone please confirm how well e-mail delivered subscriptions of
reports work using Novell Groupwise as the mail solution?
There is a post in this forum that suggests Novell Groupwise suffers
from the same corruption of PDF and Excel attached reports as Lotus
Notes.We've run it with V6.5 GroupWise using PDF attachments without any problems
so far.
Julian
"Uncle Earnie" <david.roys@.nz.ey.com> wrote in message
news:5eeae37a.0409202028.750f4df9@.posting.google.com...
> Can anyone please confirm how well e-mail delivered subscriptions of
> reports work using Novell Groupwise as the mail solution?
> There is a post in this forum that suggests Novell Groupwise suffers
> from the same corruption of PDF and Excel attached reports as Lotus
> Notes.sql
Showing posts with label solution. Show all posts
Showing posts with label solution. Show all posts
Thursday, March 22, 2012
Friday, February 24, 2012
Documenting triggers
I believe in avoiding triggers whenever possible. However, in the
circumstance that a trigger is the "right" solution, I'd be curious how
people document/diagram triggers so that a successor could actually find
them aside from just having a document that says "by the way, there are some
triggers on these tables ...". That's the type of document that will be
lost/forgot about in a hurry. Moreover, triggers don't fall nicely into the
graphically easy to find categories of tables, views, stored procedures,
etc..
Thanks in advance for your suggestions.
MarkThere is no way to do this in SQL Server (only through quering the
information_schmea /systables), but if you have Visio you can easily load
them from your database via Reverse Engineering. Thats the way a documenting
i use, because if something changes i just "reload" the database in Visio
and Voil.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mark" <Mark@.nowhere.com> schrieb im Newsbeitrag
news:ue%23F8noSFHA.3188@.TK2MSFTNGP09.phx.gbl...
>I believe in avoiding triggers whenever possible. However, in the
>circumstance that a trigger is the "right" solution, I'd be curious how
>people document/diagram triggers so that a successor could actually find
>them aside from just having a document that says "by the way, there are
>some triggers on these tables ...". That's the type of document that will
>be lost/forgot about in a hurry. Moreover, triggers don't fall nicely into
>the graphically easy to find categories of tables, views, stored
>procedures, etc..
> Thanks in advance for your suggestions.
> Mark
>|||See if this helps:
Schema: How do I show all the triggers in a database?
http://www.aspfaq.com/show.asp?id=2105
AMB
"Mark" wrote:
> I believe in avoiding triggers whenever possible. However, in the
> circumstance that a trigger is the "right" solution, I'd be curious how
> people document/diagram triggers so that a successor could actually find
> them aside from just having a document that says "by the way, there are so
me
> triggers on these tables ...". That's the type of document that will be
> lost/forgot about in a hurry. Moreover, triggers don't fall nicely into t
he
> graphically easy to find categories of tables, views, stored procedures,
> etc..
> Thanks in advance for your suggestions.
> Mark
>
>
circumstance that a trigger is the "right" solution, I'd be curious how
people document/diagram triggers so that a successor could actually find
them aside from just having a document that says "by the way, there are some
triggers on these tables ...". That's the type of document that will be
lost/forgot about in a hurry. Moreover, triggers don't fall nicely into the
graphically easy to find categories of tables, views, stored procedures,
etc..
Thanks in advance for your suggestions.
MarkThere is no way to do this in SQL Server (only through quering the
information_schmea /systables), but if you have Visio you can easily load
them from your database via Reverse Engineering. Thats the way a documenting
i use, because if something changes i just "reload" the database in Visio
and Voil.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mark" <Mark@.nowhere.com> schrieb im Newsbeitrag
news:ue%23F8noSFHA.3188@.TK2MSFTNGP09.phx.gbl...
>I believe in avoiding triggers whenever possible. However, in the
>circumstance that a trigger is the "right" solution, I'd be curious how
>people document/diagram triggers so that a successor could actually find
>them aside from just having a document that says "by the way, there are
>some triggers on these tables ...". That's the type of document that will
>be lost/forgot about in a hurry. Moreover, triggers don't fall nicely into
>the graphically easy to find categories of tables, views, stored
>procedures, etc..
> Thanks in advance for your suggestions.
> Mark
>|||See if this helps:
Schema: How do I show all the triggers in a database?
http://www.aspfaq.com/show.asp?id=2105
AMB
"Mark" wrote:
> I believe in avoiding triggers whenever possible. However, in the
> circumstance that a trigger is the "right" solution, I'd be curious how
> people document/diagram triggers so that a successor could actually find
> them aside from just having a document that says "by the way, there are so
me
> triggers on these tables ...". That's the type of document that will be
> lost/forgot about in a hurry. Moreover, triggers don't fall nicely into t
he
> graphically easy to find categories of tables, views, stored procedures,
> etc..
> Thanks in advance for your suggestions.
> Mark
>
>
Sunday, February 19, 2012
Documentation
Hello,
I have a BI solution in SQL server 2005, is there a documentation tool to help me do the documentation for my project?
I use SSIS, SSAS and SSRS. I need documentation for the first two.
Thank you
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ssisvcs.mspx - SSIS
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ssasvcs.mspx - SSAS
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rptsvcs.mspx - SSRS
And SQL server 2005 books online too (updated Fe2007).
|||Sorry, i must have explained wrongly.
I want to generate my solutions documentation, is there a way to do it using sql server 2005, or do i need a external tool?
If so, what tool?
Thanks
Subscribe to:
Posts (Atom)