get sp details by passing sp name

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 2005 Forums

Transact-SQL (2005)

get sp details by passing sp name

Author

Topic

dhanu.tpk
Starting Member

14 Posts

Posted - 2010-02-01 : 04:52:17

Hi,

by passing sp name i need to get count of line numbers, count of parameters used in sp,tile,tables used.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-01 : 04:55:09

you need to write custom sp for that. you can start from looking into sys.sql_modules

dhanu.tpk
Starting Member

14 Posts

Posted - 2010-02-01 : 04:57:45

can you give some more details on that...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-01 : 05:03:05

http://msdn.microsoft.com/en-us/library/ms175081.aspx

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-02-01 : 05:05:16

refer to the Books Online on sys.sql_modules
http://msdn.microsoft.com/en-us/library/ms175081.aspx

forgot to hit F5

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-02-01 : 06:11:13

quote:
Originally posted by dhanu.tpk

Hi,

by passing sp name i need to get count of line numbers, count of parameters used in sp,tile,tables used.

Why do you want to do this?

Madhivanan

Failing to plan is Planning to fail

dhanu.tpk
Starting Member

14 Posts

Posted - 2010-02-01 : 06:21:31

i have 300 sp and i need to give some details for each sp,so that region!!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-01 : 06:39:02