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.

 All Forums
 Site Related Forums
 Site Related Discussions
 Hooray for SQLTeam Forum Search

Author  Topic 

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-08-07 : 18:02:07
Excuse me while I rave for a moment, but the SQLTeam Forum Search has just saved me from a migraine. My PC has been tweaked for a couple of weeks, and for some strange reason, when I go to EM and open the properties of a stored procedure, I can only see about the first 10 lines, which is usually just enough to see some of the input parameters. Well, my computer will be fixed later this week, but I needed to see inside one of our sprocs NOW.

I knew I had read something along these lines here on SQLTeam, so I did a search in the Forum, and sure enough, I found graz's answer to another suffering soul about using sp_helptext. This was just what I was looking for!

Thank you again Graz and SQLTeam!

Mark Caldwell

------------------------------------------------------------------
Contractor$ never die, they just leave for higher-paying project$.
   

- Advertisement -