Thanks for the reply! I can copy with a number of methods but I always loose
the database rules when I copy or import data (i.e. primary keys, identity,
default values, etc.). Any ideas or tips to keep the database and rules
intact?
TIA - Rob
"Anith Sen" <an***@bizdatasolutions.com> wrote in message
news:iy*****************@newsread3.news.atl.earthl ink.net...
You can do this by either detaching, renaming & attaching the database
files with a different name or you can backup the database & restore it as a
different name. For smaller databases, you can even do the Copy database
wizard which can create a copy of the database with a different name.
Please refer to SQL Server Books Online for details on any of these
approaches and check the following MSKB links :
http://support.microsoft.com/default.aspx?kbid=314546
http://support.microsoft.com/default...cid=kb;q224071
--
- Anith
( Please reply to newsgroups only )