Generate Scripts

Is there a stored proc to generate scripts to create a database and all
it's objects?
I'm using SQL 7.
Thanks-in-advanceNo built-in stored procedure available.
Check out http://www.mssqlcity.com/Scripts/T-...erateScript.sql
Why not use the Enterprise Manager?
Nathan H. Omukwenyi
"Bob" <Go1369@.Yahoo.Com> wrote in message
news:1147202443.779246.214780@.g10g2000cwb.googlegroups.com...
> Is there a stored proc to generate scripts to create a database and all
> it's objects?
> I'm using SQL 7.
> Thanks-in-advance
>|||You can use sp_OACreate and use the SQLDMO COM object where the scripting fu
nctionality exists. Do
some googling and I'm sure you will find just such samples.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bob" <Go1369@.Yahoo.Com> wrote in message
news:1147202443.779246.214780@.g10g2000cwb.googlegroups.com...
> Is there a stored proc to generate scripts to create a database and all
> it's objects?
> I'm using SQL 7.
> Thanks-in-advance
>|||I want to be able to create a dts package or script because I would run
it every other year or so.|||How about some Active scripting using the DMO object model? See:
http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bob" <Go1369@.Yahoo.Com> wrote in message
news:1147203928.872491.73660@.v46g2000cwv.googlegroups.com...
>I want to be able to create a dts package or script because I would run
> it every other year or so.
>