At 02:28 PM 10/06/2003 +1000, you wrote:

>I agree, doesn't sound possible. On further investigations, the stored procs
>didn't come over either even though the output we took from the
>backup/restore suggest that they were written.
>I will look at doing a metadata only backup.
>Johnb

Sounds like a restore that abended before the constraints and other
late-binds were applied....or that maybe you were looking at the restored
database before the restore completed. (Unfortunately, you CAN do this...)

heLen