Best practice - triggers and SP

HI all,
Whats the best practice when it comes to deciding what to put into triggers
or SP.
At the moment I find myself putting a lot of stuff into triggers. I have no
idea as to what is generally considered too much for triggers.
Any thoughts
Thanks
RobertRobert
http://www.sql-server-performance.c..._procedures.asp
http://www.sql-server-performance.c...gger_tuning.asp
"Robert Bravery" <me@.u.com> wrote in message
news:OkNr$tpRGHA.4920@.tk2msftngp13.phx.gbl...
> HI all,
> Whats the best practice when it comes to deciding what to put into
> triggers
> or SP.
> At the moment I find myself putting a lot of stuff into triggers. I have
> no
> idea as to what is generally considered too much for triggers.
> Any thoughts
> Thanks
> Robert
>|||Personally, I put as little as possible in the triggers. Use SP if you can.
I use triggers when there is a possibility of accessing data in the table
from a number of different procedures or when I need to be certain
(absolutely) that something will be done when data changes in the table.
MC
"Robert Bravery" <me@.u.com> wrote in message
news:OkNr$tpRGHA.4920@.tk2msftngp13.phx.gbl...
> HI all,
> Whats the best practice when it comes to deciding what to put into
> triggers
> or SP.
> At the moment I find myself putting a lot of stuff into triggers. I have
> no
> idea as to what is generally considered too much for triggers.
> Any thoughts
> Thanks
> Robert
>|||I find triggers are very good to do audit, in other cases SP is preferred.
James
"Robert Bravery" wrote:

> HI all,
> Whats the best practice when it comes to deciding what to put into trigger
s
> or SP.
> At the moment I find myself putting a lot of stuff into triggers. I have n
o
> idea as to what is generally considered too much for triggers.
> Any thoughts
> Thanks
> Robert
>
>|||Triggers are best for enforcing constraints that cannot be enforced
declaratively, or for tracking or reacting to modifications--especially from
multiple sources.
Stored procedures are better for everything else.
"Robert Bravery" <me@.u.com> wrote in message
news:OkNr$tpRGHA.4920@.tk2msftngp13.phx.gbl...
> HI all,
> Whats the best practice when it comes to deciding what to put into
> triggers
> or SP.
> At the moment I find myself putting a lot of stuff into triggers. I have
> no
> idea as to what is generally considered too much for triggers.
> Any thoughts
> Thanks
> Robert
>

Beginning

Hi, im a Beginner and I have to start next week with create and programming
some Reports with Reporting Services. Can anyone give me some good stuff
where I find the first lessons what I have to do etc. Perphaps some links or
e idea for some good books!? The installation wasn't a problem, it's about
the programming.
Thanks very much for your help!
schueppi/SwitzerlandOn Thu, 7 Apr 2005 23:35:06 -0700, "schueppi"
<schueppi@.discussions.microsoft.com> wrote:
>Hi, im a Beginner and I have to start next week with create and programming
>some Reports with Reporting Services. Can anyone give me some good stuff
>where I find the first lessons what I have to do etc. Perphaps some links or
>e idea for some good books!? The installation wasn't a problem, it's about
>the programming.
>Thanks very much for your help!
>schueppi/Switzerland
There was a series of 5 webcasts about a month ago. I included a link
from my blog, http://www.tfosorcim.org/archives/000340.html.
The webcasts are ideal for getting your head round SQL Reporting
Services 2000.
Once you have watched those, you will be in a better position to
understand the Reporting Services Books Online, link from here:
http://www.tfosorcim.org/archives/000352.html.
Andrew Watt
MVP - InfoPath