IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Izzat better than sp_helptext?
Post #245,586
by mmoffitt
2/21/06 10:08:37 AM
Reply
New Izzat better than sp_helptext?
bcnu,
Mikem

It would seem, therefore, that the three human impulses embodied in religion are fear, conceit, and hatred. The purpose of religion, one might say, is to give an air of respectibility to these passions. -- Bertrand Russell
Post #245,587
by ChrisR
2/21/06 10:50:35 AM
Reply
New Same difference
TIMTOWTDI - or some such acronym. Looking at the source for sp_helptext, it's pretty well just grabbing the syscomments:
SELECT text\nFROM syscomments \nWHERE id = OBJECT_ID(@objname) and encrypted = 0\nORDER BY number, colid

Since it's a question of tools, though, I'd want to know what's actually in the underlying tables, stripped of any intermediate facilities (including stored procs). And I'd want to see that raw value in the same tool that is causing the grief.
     SQL Server's Query Analyzer not refreshing SPs - (lincoln) - (14) - Feb. 16, 2006, 10:24:44 AM EST
         How are you retrieving the stored proc in Query Analyzer? - (ChrisR) - (2) - Feb. 16, 2006, 11:12:46 AM EST
             from the Object Browser panel on the left side - (lincoln) - (1) - Feb. 16, 2006, 04:29:29 PM EST
                 just glossing over it... - (ChrisR) - Feb. 16, 2006, 05:35:57 PM EST
         Getting at the source - (ChrisR) - (4) - Feb. 17, 2006, 09:54:26 AM EST
             the source shows the latest changes - (lincoln) - (1) - Feb. 21, 2006, 10:04:19 AM EST
                 Occam's Razor and whatnot - (ChrisR) - Feb. 21, 2006, 11:27:39 AM EST
             Izzat better than sp_helptext? -NT - (mmoffitt) - (1) - Feb. 21, 2006, 10:08:37 AM EST
                 Same difference - (ChrisR) - Feb. 21, 2006, 10:50:35 AM EST
         Problem no longer appearing - (lincoln) - (5) - March 3, 2006, 02:39:44 PM EST
             Its the magic of Microsoft -NT - (JayMehaffey) - (4) - March 4, 2006, 12:24:42 PM EST
                 s/magic/black-spaghetti-code-magic/ -NT - (folkert) - (3) - March 4, 2006, 06:22:46 PM EST
                     Also known as "non-deterministic" behavior. -NT - (a6l6e6x) - (2) - March 4, 2006, 11:09:15 PM EST
                         I was joking. You sound serious! - (folkert) - (1) - March 5, 2006, 01:11:56 AM EST
                             It's a "hot button" for me. :) -NT - (a6l6e6x) - March 5, 2006, 12:09:09 PM EST

Powered by medium-dudgeon.
54 ms