John,

1. Yes you can create indexes on a table after data is inserted

2. It would actually be much better if you place indexes after you perform data insertion, as having...

I am assuming that you are using either a Profiler or a server trace which is writing the data to the the database table called: "dbo.LOAD_TEST_V_28_11_06 "

In...

Hmm ... don't know much more about email sending, but it appears that the error message states the problem.

Ah ... initially I assumed that by performing an INSERT within the TRIGGER we might enter some infinite loop where the INSERT would fire a TRIGGER, which would in turn...

http://www.only4gurus.net/miscellaneous/sqlsrv_programming.pdf

Information below is coming from the link mentioned above:

The computer running SQL Server must be set up as an e-mail client. SQL Server Enterprise Manager is used to assign...

There appears to be a problem with using a trigger in my case.

Namely, I believe we only have an AFTER TRIGGER  and an INSTEAD OF TRIGGER.

If I use INSTEAD OF TRIGGER, then...

This is great info.

Thanks a lot

Your syntax error (although not stated what it is exactly) is probably due to data type casting/conversion as described here:

http://www.extremeexperts.com/SQL/Articles/CASEinORDER.aspx

Will below work?

ORDER BY

 CASE WHEN @orderId = 1 THEN...

Guys,

If I create an INSERT trigger and then peform an INSERT of items (A,B), is it possible, inside the trigger, to see the items which are being inserted by the...

Thanks a lot guys.

Let me try both approaches.

I have a similar problem.  That is, I have jobs running every day performing backups of all the user databases.

For all, except 1 database, no problems ever occurred.  For one...

I just learned that the easiest way of removing the stored procedure from the cache is to recompile it as such:

sp_recompile 'stored procedure name'

I think that this is the best way to go,...

That is correct.  In your situation there is never a need to question the results of the testing area.

I will consult with my co-workers here and see whether we can set...

You are correct.  We do have both a testing and production areas.  And I do perform tests in the testing area, where the use of DBCC FREEPROCCACHE command is less...