I do not consider you geeks.  I see this more as a very hot refining fire that will help me pay more attention to details and be more specific.  From...

autoshrink can activate at bad moments (when many people are using the database) and so they will experience degraded performance.  We have autoshrink on for most of our production databases,...

Well, I made an oversight again.  I mentioned that you are using Enterprise Manager in the question but failed to change the correct answer to say Enterprise Manager won't allow...

create a table, perhaps called tblSPParameters with columns such as ParameterName varchar(30), ParameterValue varchar(30), SPName varchar(50), DateExecuted datetime with a default value of getdate(), and any other info you need.

Add...

No offense is taken.  And I am not try to offend everyone by explaining my thought process as I created this question of the day.  Recent comments help me to...

Try this:

CREATE TRIGGER trSendEmail ON dbo.TableName FOR INSERT

AS

EXEC master.dbo.xpsendmail @Recipients = 'myemail@mycompany.com', @Subject = 'Test'

This was my first question of the day.  I did my best to make it as clear as possible.  I also counted on the fact that those who work with...

I don't think I have ever reindexed system tables and doubt it is a good idea to do so.  From what I have seen SQL Server system objects generally take...

I'm not sure you can get the parameter values the way you are trying.  I have never tried and don't know.

I will make some other suggestions.  You can put a...

You mean VBScripts won't work anymore.  That won't be good.  We use VBScripts in most of our DTS packages and for the reason you mention to get around DTS limitations. ...

It seems to me that the first part of the where clause is only meant to get one row.  This modification might work:

WHERE EXISTS (SELECT Trans2.Parent_Record

       FROM Sor_Order_History Ord2

      ...

It will help me (and I believe others) to see the table structure, sample data for both tables, and the query used.  Without seeing the query I might suggest things...

I experienced problems with transfering objects and the only way I found to identify which objects were the problems was to remove them one by one or in groups and...

A very nice article (and I only read half of it).  I second the concern of how well will existing packages transfer to DTS in Yukon.  Microsoft has made a...

I just got through reading about the new DTS in Yukon.  It sounds like it is as easy as 2000 if not easier.