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 |
|
pravin14u
Posting Yak Master
246 Posts |
 Posted - 2008-03-05 : 02:04:24
|
| Which SP should I use to get the definition of a user created SP?Thanks,Prakash.P |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-03-05 : 02:21:57
|
| use sp_helptext to get the details about the procedure.eg:sp_helptext 'spname' execute this statement |
 |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-03-05 : 03:00:09
|
| Thanks a lot. Is there anyway where I can get the "Create Table... " script of a specified table? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-05 : 03:20:44
|
quote:
Originally posted by pravin14u
Thanks a lot. Is there anyway where I can get the "Create Table... " script of a specified table?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53007or better make use of Generate SQL script from Enterprise ManagerMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SP Definition