Simply write an after insert trigger for a table, check row count and send mail with sp_send_dbmail procedure.

http://msdn2.microsoft.com/en-us/library/ms190307.aspx

However, you shouldn't do it on a high volume table.

On second look it seems like everything is coded to slow down updates:

What is it for?

SELECT @orderNumber=PARTSMANUFACTURING.M01_PRODUCTIONORDERNUMBER

FROM PARTSMANUFACTURING,INSERTED ...

First of all, executing a java program from a trigger is a bad idea, because transactions must be short. Second, I'd guess the java program connects to database and performs...

If you have multiple update triggers, be sure they don't overlap (functionally).

IOW, if you have two and they both update own table, one will fire the other one. In such...

Of course. SSMS can do it. DBLib supports it, OLEDB supports it, so it all depends on your knowledge on your front end, if you want to do it from...

Excellent. Simple and efficient.

exec dbo.proc_permutations 8

generates 40k records in 0.5 sec.

What are "demoralized tables"? I didn't know they can have such...

I know and that's not the point.

The script looks like

command

go

command

go

There are ~700 of them.

If autocommit is ON, each completed command should be committed and usually is. Uncompleted commands are rolled...

Rollback rolls back uncommitted modifications - undo in the database. Even if whole transaction was help in a buffer, the whole buffer must be written, which does not happen instantly.

It...

I guess you have a problem with query that executes for 30 sec, but shouldn't.

Examine the query execution plan. Red nodes need work on.

Not just that. Such data comes from poorly designed database model, client app and bad user habits.

A user is inputting an invoice. Does not use an available lookup to pick...

Stephen Lee (3/10/2008)

---

Hello All,

I've been charged with cleaning up 2-3 tables which contain approx 1 millions records each.

The problem I'm experiencing is, some of the companies (an important column)...

It's best explained in this article:

http://www.sqlservercentral.com/articles/Administering/executionplans/1345/

True for work computer in some companies....

Just my 2 cents.

If you set pagefile too small or worse disable it, the system will be slow regardless of ram size. On my comp with 2 GB ram the...