Hi,
How can I copy all from a database without copying the data in the tables?
Thanks
DibIn Enterprise manager you can right click on the DB and choose "All Tasks".
Then Generate a SQL Script. From there a wizard will pop up and guide you
through the rest. Make sure you check all the objects you want.
Andrew J. Kelly SQL MVP
"Dib" <dNOSPAMshahene@.conNOSPAMsoftware.com> wrote in message
news:OtRXGugOFHA.3076@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can I copy all from a database without copying the data in the tables?
> Thanks
> Dib
>|||Thanks
Dib
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:e1eQTIhOFHA.1392@.TK2MSFTNGP10.phx.gbl...
> In Enterprise manager you can right click on the DB and choose "All
Tasks".
> Then Generate a SQL Script. From there a wizard will pop up and guide you
> through the rest. Make sure you check all the objects you want.
> --
> Andrew J. Kelly SQL MVP
>
> "Dib" <dNOSPAMshahene@.conNOSPAMsoftware.com> wrote in message
> news:OtRXGugOFHA.3076@.TK2MSFTNGP12.phx.gbl...
tables?[vbcol=seagreen]
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment