Rank: Newbie
Groups: Member
Joined: 2/8/2010
Posts: 2
Points: 6
Location: UK
|
Hey,
I am using mylittleadmin for SQL Server 2005 lite edition. I used to have the code for all of the stored procedures, but unfortunately my laptop was stolen 2 weeks ago and I only have a backup from several months ago - since then I remember I made lots of changes. I would have thought I would be able to view the code for a stored procedure using mylittleadmin, or maybe even export them - but this does not appear to be the case in the lite edition.
Does anyone know of a way to do this? It seems stupid if its not possible, even though I am using the free edition of mla.
I have tried using sp_helptext <sproc name>, but that does display anything - it just says the table has been altered but there is nothing in the output tab.
Any help with this would be great.
Regards,
Richard
|
Rank: Newbie
Groups: Member
Joined: 2/8/2010
Posts: 2
Points: 6
Location: UK
|
Nevermind - I solved it. I forgot to put "exec" on the beginning of "sp_helptext <sproc name>"..
Richard
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
The full version allows displaying and editing the code of SPs.
|