select sysobjects.name, syscomments.text from syscomments left join sysobjects on syscomments.id=sysobjects.id where sysobjects.xtype='p' and name='你的名'
select syscomments.text from sysobjects join syscomments on sysobjects.id=syscomments.id where TYPE='p' and syscomments.id=object_id('将要察看的存储过程的名字')
exec sp_depends
exec sp_help
而用楼上朋友的程序得到的是二行参数,貌似不一样的吧...再问个比较弱的问题,什么叫存储过程的脚本?
select sysobjects.name, syscomments.text from syscomments left join sysobjects on syscomments.id=sysobjects.id where sysobjects.xtype='p' and name='你的名'
syscomments.id=object_id('将要察看的存储过程的名字')