Just run this query.
Select Object_Name(C.id) AS Name , text From SysComments AS C Left Join SysObjects AS O On C.id = O.id Where O.xtype = 'P'
Select Object_Name(C.id) AS Name , text From SysComments AS C Left Join SysObjects AS O On C.id = O.id Where O.xtype = 'P'
Lajapathy ArunPosted Jul 4, 2012, 8:18 AM
Keep blogging :)
Kunal VaishyaPosted Jul 4, 2012, 5:51 AM
Thanks Dear
Lajapathy ArunPosted Jul 3, 2012, 5:38 AM
http://www.c-sharpcorner.com/Blogs/9135/getting-sql-script-of-database-object-of-used-database-using.aspx Hope this helps you.
Lajapathy ArunPosted Jul 3, 2012, 5:36 AM
SysComments outdated for production try to use sys.sql_modules and use definition column.
Kunal VaishyaPosted Jul 3, 2012, 4:22 AM
no dear its gives current databases
Lajapathy ArunPosted Jul 3, 2012, 1:16 AM
This query gets all the proc from all databases ?