How can i have a copy of entire databse with out data??

[ganeshkumar08]

Hi all,

Using generate scripts i generated the database script file and executed,
i got an error.

How to copy the entire database without data.

Can any one help me..

Ganesh

[ck9663]

What error did you get?

-- CK

[ganeshkumar08]

Its a SP error, which i did mistake..
Can u tell the procedure to generate script, i need to have script like this...
I should not even create a new database, the script should have create new database also..

Can u pls tell me...

[ck9663]

Are you planning to copy a database? Or just create a new one?

Why not just create a new one? Try this

-- CK

[ganeshkumar08]

I need all the Table, SP, View, Schema scripts.
So, using this scripts i want to execute in another server. My requirement is i need to generate a DB script file which should be executed in another server. So, while executing the script the database also must created with tables, SP, View, Schema etc..