Primary Keys & ID Properties Not Transfering

[RPG42]

Hi,

I make a backup of the "live" database to test new VB programs on, but for some reason whenever I make the test DB, it doesn't transfer the primary keys and ID properties for any of the tables.

What am I missing?

Thanks,

RPG

 

[SQLSister]

HOw did you make the new database?

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[dbomrrsm]

might be better to tke a copy of the mdf and ldf files and make the new DB from those - see attach detach DB in BOL

[blue]DBomrrsm[/blue]