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.
| Author |
Topic |
|
aravindt77
Posting Yak Master
120 Posts |
 Posted - 2008-11-19 : 06:17:04
|
| Hi,Can anyone tel me from where do i get the body of Stored Procedure ??Although the column "Routine_Definition" in the Information_Schema.Routines shows only of VARCHAR(4000) ...Many of SP of bigger size is truncated...Thanks & RegardsARV |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-19 : 06:22:22
|
| SP_HELPTEXT'spname' |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 06:48:05
|
| [code]select text from syscomments where id=OBJECT_ID('YourProcedureNameHere')[/code] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-20 : 02:49:25
|
quote:
Originally posted by visakh16
select text from syscomments where id=OBJECT_ID('YourProcedureNameHere')
Rely on sp_help onlyIf there are more than 4000 characters, text is stored in more than one rowMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
fetch body of SP