List of Views, Functions and SPs

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

List of Views, Functions and SPs

Author

Topic

erwine
Yak Posting Veteran

69 Posts

Posted - 2007-08-21 : 05:50:10

Hi all,

I would like to like all the views, functions and stored procedures of a database as well as its definition (I'm referring to the script of views, functions and SPs). Anyone know about it?

I need it because I need to import it from one database to another. So, if i can easily get all its definition, i can just run it in the new database.

Thanks for your kind attention.

Cheers,
erwine

... sql is fun...

erwine
Yak Posting Veteran

69 Posts

Posted - 2007-08-21 : 05:52:01

oopz...get it.

cheers,
erwine

... sql is fun...