coppy sql objects

microsoft.public.sqlserver.programming

7 Jul 2005 1:03 PM

Sam

how can i copy all objects (empty tables, views, trigers ...) from an sql db
and create with it a new db
in another computer?

thanks

7 Jul 2005 12:13 PM

Uri Dimant

Sam
Generate SQL Script via EM

Show quote

"Sam" <focu***@zahav.net.il> wrote in message
news:ONzhovugFHA.3936@tk2msftngp13.phx.gbl...
> how can i copy all objects (empty tables, views, trigers ...) from an sql
db
> and create with it a new db
> in another computer?
>
> thanks
>
>

7 Jul 2005 12:16 PM

John Bell

Hi

The easiest way is probably to use backup and restore. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

John

Show quote

"Sam" wrote:

> how can i copy all objects (empty tables, views, trigers ...) from an sql db
> and create with it a new db
> in another computer?
>
> thanks
>
>
>