I believe the next version of SQL Server (Yukon) will have system level triggers. In the meantime, you might consider a third party tool by Lumigent called Entegra to see...

Make sure you have the latest service pack, at least SP3

select serverproperty('productlevel')

This will ensure you are not experiencing the slammer virus.

HTH

To stop table scans and use your indexes don't do this:

Where LastDATE = cast(year(getdate()) as varchar(4))+'/'+cast(Month(getdate()) as varchar(2))+'/'+cast(Day(getdate()) as varchar(2))

A bunch of better ways to do it, one way would...

In addition to Chris's comments, this page may help - http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

HTH

I've used ProClarity which is very nice for management types that insist on "graphical" and "pretty" reports. MS Excel pivot tables are good for the CPA types used to using...

This is a script snagged from SQL Server MVP Andrew Kelly, it keeps the log from getting full while going through reindexing alll your tables:

SET NOCOUNT ON

DECLARE @TableName VARCHAR(100), @Counter...

Here's one URL that will get you started,

http://www.microsoft.com/sql/yukon/productinfo/

Ray Higdon MCSE, MCDBA, CCNA

Yep, if you didn't know Yukon is the next version of SQL Server due to be released end of 2004, if you can wait that long you can have what...

Ah, didn't catch what you meant, well, without displaying that proddate, one way you could do this is to use a temp table:

create table tblmytable (productiondate datetime)

insert into tblmytable

select '2003-07-01'...

I believe Yukon will allow you to create system or server level triggers which would do what you need, Entegra,which Jonathan mentioned will do this now.

HTH

Ray Higdon MCSE, MCDBA, CCNA

To add to what Allen said, if you are having mostly inserts having the clustered index on a sequential column can give you a hot spot for inserts and help...

How about:

select datename(month,productiondate)+'-'+ datename(year,productiondate)

from tblmytable

group by datename(month,productiondate)+'-'+ datename(year,productiondate)

HTH

Ray Higdon MCSE, MCDBA, CCNA

You might look into xpsmtp, it's a popular alternative developed by a guy that was on the development team for SQL Server agent.

http://sqldev.net/xp/xpsmtp.htm

HTH

Ray Higdon MCSE, MCDBA, CCNA

Like Frank said, without DDL and DML, ANYTHING anyone says is a shot in the dark. You may get some best practices trivia but to get actual help for your...

It's probably non-optimal code in the trigger, you might want to post the trigger code for suggestions.

Ray Higdon MCSE, MCDBA, CCNA