| Author |
Topic |
|
aravindt77
Posting Yak Master
120 Posts |
 Posted - 2008-06-04 : 01:45:45
|
| Hi,Anyone plz do tell me what s the query to see the text content of stored procedure from system database tables..from which table we get the content of spThanks & RegardsARV |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 01:48:02
|
| sp_helptext YourSPName |
 |
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2008-06-04 : 01:50:20
|
| Hi, Thanks .. but i want to get the entire sp of a particular database .. for that what to do ???ARV |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 01:52:14
|
quote:
Originally posted by aravindt77
Hi, Thanks .. but i want to get the entire sp of a particular database .. for that what to do ???ARV
You want code for entire sps in a db? May i know what you're trying to do on all sps? |
|
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2008-06-04 : 01:55:30
|
| Hi Vishakh ... bcoz i want to check a particular expression column and its value taken for that not able to locate for each sp and cant locate and chek for each sp if it exists ....ARV |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 02:02:07
|
quote:
Originally posted by aravindt77
Hi Vishakh ... bcoz i want to check a particular expression column and its value taken for that not able to locate for each sp and cant locate and chek for each sp if it exists ....ARV
You could use the syscomments table for searching on text content of sps |
|
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2008-06-04 : 02:17:51
|
| Thanks a lot ... bcoz i just frgt that moment .... any way thank u so muchARV |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 02:52:45
|
quote:
Originally posted by aravindt77
Thanks a lot ... bcoz i just frgt that moment .... any way thank u so muchARV
sorry didnt get you..frgt what? |
|
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-06-04 : 02:56:14
|
quote:
Originally posted by visakh16
quote:
Originally posted by aravindt77
Thanks a lot ... bcoz i just frgt that moment .... any way thank u so muchARV
sorry didnt get you..frgt what?
i think it may b 'frgt' means FORGOTTEN |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
content of sp from system tables