There's something wierd going on there. Please post the trigger code and the vb code that you call the inserts from.

Triggers fire within the connection and the transaction that did the initial insert/update/delete. If 4 users all update different records of a table and there's an update trigger on the...

I recomend clusters on unchanging, increasing, narrow, unique columns (priority in that order), especially if you have a lot of queries that sort by that field, do ranged searches or...

1433 and 1434 are the tcp/ip ports used by SQL if it's using TCP sockets to communicate. 445 is for named pipes.

I think the reason that 445 isn't mentioned is...

I just want to give a great big 'shout-out' to Gila for the information about avoiding the use of functions in where clauses.

My pleasure.

No need to do that, read comitted is the default isolation level in SQL

IF exists (select * from dbo.sysobjects

Just note that in sql dates always have assocated times. Getdate() returns date and time, not just date. There's no built in function that only returns date.

I believe using DateDiff() is going to offer the best performance and clearest results.

Clearest results possibly, but very definately not best performance. Be very careful when applying any function...

Yes, locks will be taken on the base table. You can see this my running the stored proc sp_lock or looking at the system table syslocks (located in the master database)....

That's the way to create tables in SQL 2000 and SQL 2005. MS

SQL Server doesn't implement that portion of the SQL 1999 standard. Offhand, I can't think of a...

If it's a parent table and several child tables you can create foreign keys (or modify existing ones) and set them to cascade delete. Then you delete from the parent and the...

What I would recomend, if you're using stored procdures (and if you're not, why not?) is to do the summary calc in the sp before or after inserting the detail...

The question does state the version. Look at the category

Category : SQL Server 2005 - TSQL

The pseudocode looks OK at a quick glance. Can you post the actual code? Would be easier to debug.

Why global temp tables?