To expand on Brandie's option, this solution is kind of ugly and you can only insert 1 Emp row at a time. You would also have to do all...

The best way I've found to handle this kind of logging from a web interface is to do all Inserts, Updates and Deletes in the database with stored procedures. ...

Barry,

Got it. I normally use the views unless I have to get down and dirty and find out of a column is computed or a timestamp or something like...

Doesn't anyone use the INFORMATION_SCHEMA views anymore?

Todd Fifield

A lot depends on the application that is using the database. I work extensively with a Point Of Sale application that needs customization for different clients that have different...

You might want to look at the table and see if there is a trigger on it that does some other update.

Todd Fifield

I don't know what you're trying to accomplish with these statements.

The first statement:

If Exists (Select * From table WHERE a=@a and b=@b)

update table

set

a= @a,

b=@b

from table where

a=@a and b=@b

This is...

I'd go with John Marsh's suggestion. If you see processes blocking each other, then that's probably your culprit. I had this happen on a SQL 2000 system where...

What I would do is write some code that normalizes the data so that each person/skill set is in a separate row. Then deal with the data in this...

I had a problem like this a couple of months ago. I've forgotten exactly what the fix was and I don't have easy access to that system any more.

The...

Probably your best bet is to execute a stored procedure in SQL Server in your form's After_Update event. The stored procedure would insert a record into the Warehouse table...

If nothing has changed on your SQL Server, then there must be some change on the SMTP server. Some security or SPAM setting?

Todd Fifield

I would be very, very careful about any query with a LOOP join if your data is going to grow. This is a real killer. If the table...

Gail,

I agree with the SQL Guru. However, setting the first day of the week in SQL Server is not really an option - it's way too messy. Keep...

I already posted this once today. I suggest that you get a little Unix/Linux box and put Zimbra on it. It can be a stand alone SMPT server....