myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Viewing the definition of a stored procedure.. Options · View
Clarkey1987
Posted: Monday, February 08, 2010 3:03:32 PM
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
Clarkey1987
Posted: Monday, February 08, 2010 3:09:56 PM
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
elian
Posted: Monday, February 08, 2010 4:44:55 PM

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.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.