Generating SQL Scripts in sql server.
- open the sql server management studio
- you can find list of database schemas, select the required database
- right click and select the generate scripts option
- select views, stored procedures, user defiend functions you will get them in new window.
exec sp_msforeachdb @command1='select ''?'' as databasename, * from ?.dbo.help'
No comments:
Post a Comment