Isn't that overkill? You'll not only copy the table, but you'll copy
everything else in that database as well!!!!

Thanks,
Brian

John Bell wrote:
>
> Hi
>
> I suggest that you backup the database and restore it as a different
> database.
>
> See the following (for move read copy!):
>
> http://support.microsoft.com/default...n-us;Q314546#2
>
> John
>
> "Bill" <billzimmerman@gospellight.com> wrote in message
> news:8da5f4f4.0307221412.380787ad@posting.google.c om...
> > I have a table I'd like to copy so I can edit it and play around with
> > the data. How do I create copy of a table in SQl Server?
> >
> > Thanks,
> >
> > Bill

--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"