Thanks to Andy Warren for the reply.

The VB code given is almost the same as what i did but with a SQLServer object to make the connection to my SQL...

As mromm mentioned,if for INSERT only, then it better set a default value = Getdate() for this column for the Test table.

When updating, avoid using trigger rather that UPDATE statement...

Thank for your replied. I'm a newbie for SQL Server.

I create a fieid using imgae data type

For example, the field name is "Photo"

From VB i save a jpeg file from...