Have you checked that the machine time on both server and client are the same?  I had a similar issue at one client site (not SQL Server, but using Windows...

...and taking that a small step further, make it a persisted computed column, so it's done once and automatically with application involvement.

Here is a code snippet from an old project I had on my archives.  I don't have VB6 loaded to test this to make sure (I thought it was a little...

Bob;

But the same condition applies.  If their are 2 rows in B that match to 1 row in A, you will have 2 rows returned since there will different values...

Are you sure the jobstep is completing?  Or are you assuming so because the backup file is there.  Could it be hanging doing a verify of the backup?

Your tables B or C have more that one row that matches a single row in A.  For instance:

Table A
ID
-----
A 
B
C

Table B
PK_ID    ID
-------  -----
1  ...

No problem. 

1. Creating your job to schedule and perform this backup.
2. Create a jobstep.  Set Type either to

• TSQL and use "Exec xp_sqlmaint..", or
• CMDEXEC and use sqlmaint. 

Parameters are the same...

However, if there are rows for the same emp_id and sales_date, you will still get multiple rows for a emp_id.  For instance, if emp_id 1831 had two orders on 6/10/06:

emp_id |...

Easier than trying to do date string manipulation in TSQL is to use the SQLMAINT utility.  You can specify to do TLog backups (-BkUpLog), remove old backups (-DelBkUps), and it...

Hopefully you are:

• using windows authentication only, and not using mixed authentication.  And
• your database applications use specific application accounts for database access, and not user accounts. 

If these are true, then...

I have to very strongly disagree.  Storing files outside of the database invariably leads to lost files, unauthorized or inappropriate access of the files, and eventual data integrity issues (broken...

The key in your VB6 app will be to convert the image to byte data array, use ADO recordsets for data access, and use GetChunk and AppendChunk to read/write the...

Not that it matters now (since you have already ordered a new system), but you don't mention 1) how much memory and how fast your disks are in the PIII...

I do not believe that you need to have a clustered index.  Without a clustered index, the rows are likely physical ordered in the order they were added.  (Perhaps, if...

RowGUID are not only for replication, though they are required for replication.

ADO.Net and ADO also use RowGuid (if it is set on a table) for identifying rows for disconnected...