You missed somthing in my post.

First, there is no reason why a PK should be changed without changing the FK in another table. FK means dependant.

In case , it really...

there are two solutions:

1. On the foreign key, enforce Cascade on Delete and Update.

2. PK columns can never be null.

So PK columns do not need to be...

It will work.

Microsoft online documentation says both 64 and 32 bit Versions use the same storage format.

Search in the Master database.

If you create a stored procedure in the Master database and give it name starting with 'sp_', you can call it in any database.