This appears to work nicely.  Thanks. <strike>  I have an unrelated task.  That is the removal of full stops in all strings of a field.  For example, the string 167.4 would need to become 1674. ...

DATEDIFF(YEAR, CAST(DOB AS DATETIME), CAST(DODiag AS DATETIME) )

Caused the following error:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

The statement has...

[Key_m] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,

when this column is specified as NOT FOR REPLICATION does that make this column a non clustered primary key?  I...

I think that I remember what I did before.  I set the identity key as a primary key. 

The table in the source database had a key that was specified as an IDENTITY column.  But for some reason when I transferred that table it lost its’ status as...

What about triggers?  Could each table have a trigger that prevents it happening?

Does anyone please have any examples of these?

So, would it be sufficient to backup a database and then copy the .BAK files from one machine to another and then restore the database on the new machine?

Script.  We have tried several things but have not had a chance to test it yet.  These are as follows:

We changed the minimum query size, we removed 3 processors...

I'm not sure whether it is a table problem or a SPROC problem.

What is BOL?

I find that it works when I get the reciepient PC to pull the data in rather than get the host PC to push the data out.

Is there a quick and easy way of creating 60 already written SPROCs in a specific database?

Now I get an error message saying that 'the login already has an account under a different user name'.

The Administrator rights were removed from the login.