Developer Forum

I note that sql server 2005 express does not support the sqlagent.

So how do I copy a database from a 2005 (standard) instance to a 2005
Express edition.

Thanks

Ed Warren

You should be able to do a Backup and Restore or detach and attach.

--
Andrew J. Kelly SQL MVP

Thanks, I was able to do a detach, move the file, then attach. I was afraid
I had missed something simple.
I greatly appreciate your help

Ed Warren.