Ashish,

>I hace one database, I want to create same database with no data.
>is there any other way except database script, backup and restore, sp_attachdb >etc.

If you are using SQL7, use the data import export wizard. Select your source and destination and choose transfer objects and data between SQL Server 7.0 Databases.

On the next screen, simply uncheck copy data. This will copy the structures, stored procedures etc.

Hope this helps.