Hi, Unfortunately not. The data source I am using does not have a unique column that can be used for each record, however the target database requires one.

Sadly I...

Hi,

The view is a mixture of data from multiple tables I need to have a ROWID number that is unqiue for each record.

So... For example

The row containing data for Machine1 would be...

Gentlemen,

Excellent replies. Thankyou for your assistance.

Many thanks

Paul,

Thankyou for your reply. I've checked the DB and Auto - Shrink is turned off, at the time of the error the shrink command was not been run.  I have...

Thankyou for your reply I have attached the entries from the SQL error log and the windows event log. Interestingly enough after i received notification of the error, I ran...