Can you show simply examples of the two tables (columns etc) and describe how they are realted, and what column(s) you want to update with values from which column(s)..?

(your example...

Still, that is not reason enough to cross-post. Please post questions in one forum only, else all forums would soon be full of duplicates of the same question. Worse is...

If you pick out a table and a missing columnname and run this query, do you get something else besides a zero as return value?

select permissions(object_id('dbo.myTable'), 'myColumn')

/Kenneth

Well, depending on how he logs on (windows auth or SQL login) it may not do any difference if he is admin on the win box or not.

Unless he's running...

A common factor for all of the INFORMATION_SCHEMA views is that they will show only what the current user has permissions on.

So, what permissions does your colleague's login have on...

Are the databases initially created with small sizes and are the growthfactor still at the default 10% ?

If yes, then you should change that to some larger value, like 50...

In that case you can import the two logs into a staging table (which then may hold duplicate rows) and insert from the staging table to the master table like...

Well, most of the times the wording 'you get what you pay for' has a tendency to become true. As I said, let the value of your data influence the...

I really have no clue, perhaps try asking in a Access forum?

Though if this is data that is important, I'm not too sure that using Access is such a good...

It's better to use LIKE and wildcards instead of ISNUMERIC() because LIKE + wc gives you more control.

If you want to find values with numerics only:

SELECT myColumn

FROM  ...

First question: How do you define a duplicate? (ie which column(s) do you consider as the natural key)

/Kenneth

Since apparently something funky happened in the cloning process, I'd personally do it again, or even get the CD's out and do a clean install from the ground up on...

Just note that weeknumbers are ambigous on a global scale. Different countries have different rules on when week one starts for a given year, and also in which weeknumber a...

If you want to be selective, here's a few ways to generate scripts for dropping FK's and unique constraints and plain indices.

Note that it's also possible to just disable FK...

I'm not going to pretend that I know everything there is about bit-magic, but.. 2097215 is what you get when the current user has execute perms (32) AND also can...