Thanks... that did it!!

Thanks, that was very helpful...

Sounds like I need to pin down the actual requirements first.

Thanks

Susan

Sorry should of mentioned I'm working with SQL 2000.

The article you referred me to is for restoring a backup.

I don't have a backup, just the ldf/mdf files.

Thanks

I don't believe that's an option with the system databases -

Here's the error message I receive -

System databases master, model, msdb, and tempdb cannot be detached.

I was also able to do it with this

select convert(char(10),cast(DateIn as datetime),120)

The cast works to modify the field to the smalldatetime, but how I would use the convert in the same select statement?

Thanks for your help

Thanks... SP2 did it.

I tried it with SP1, but still didn't see the 'per object' option.

Once I applied SP2, there it was...

Thanks again

Susan

I don't have the same options as you, what is the SQL 2005 version and edition are you using?

I'm running a standard SQL 2005 with no sp's.

Thanks in advance

Susan

I don't have those options...

Here's what I have in the same screen.

Are the indexes the same between the original and new server? By default, nonclustered indexes are not copied when a table is replicated.

I did add the indices, but the...

Sorry, I should have posted to the SQL 2005 site.