Apologies. You were right. It works correctly now.

I've tried this before and just tried again, but I still get the same error - The data types varbinary and varchar are incompatible in the add operator.

I remember when I moved a database from a SQL 2000 iteration to a 2008 iteration, I had to Restore the Database Master Key from a backup. I didn't realize...

Many thanks. So the Database Master Key is now moved with the database backup unlike versions of SQL Server up to 2008.

No, I chose default instance during installation.

Oh you're right! The old table has somehow got added to my user name rather than dbo. So I have deleted it and now everything works correctly. Brilliant, I would...

The data returned shows the linked tables and the MasterAgentPayment create scripts and all the foreign key and default data is all corect, but it shows only the correct table...

Running sp_help shows only the data for the correct new table and all the data is correct. There is no data related to the incorrect table.

You can't just double click the short cut, you have to right click and then click Run as Administrator. Then it connects.

Not used to Windows Vista yet, but I'm already...

Thanks so much for your kind offers and advice, but I already rebuilt the database and will use a proper backup to transfer the data next time.

Thanks again,

Doug

Sorry, the above still looks wrong because some of the code I typed has been deleted by the forum. The final line should be:

VALUES(open chevron cfif This.DeptID EQ "" close...

You're right of course. The real code ignoring the other fields was this:

INSERT INTO Employees(DeptID)

VALUES(#Val(This.DeptID)#)

where #DeptID# is a ColdFusion variable which contained an empty string.

The real correct code is:

INSERT INTO...

If the foreign key name is the same as its relative column name in the other table and this is not a multi-column constraint, it is not actually necessary to...

When I try to run this I just get the message - Can't open the database.

I can't imagine why. It still works okay on the other computer, but copies of...

Using CheckDB I get the error:

The header for file 'C:\MSSQL7\data\mydb_Data.MDF' is not a valid database file header. The PageAudit property is incorrect.

Anyone know what PageAudit means? Can it be corrected....