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!

New from the Object Browser panel on the left side
of the screen: I expand the database tree, expand the stored procedures tree, highlight a specific stored procedure, then right-click it and select Edit. That opens it up in a new query window.
lincoln

"Chicago to my mind was the only place to be. ... I above all liked the city because it was filled with people all a-bustle, and the clatter of hooves and carriages, and with delivery wagons and drays and peddlers and the boom and clank of freight trains. And when those black clouds came sailing in from the west, pouring thunderstorms upon us so that you couldn't hear the cries or curses of humankind, I liked that best of all. Chicago could stand up to the worst God had to offer. I understood why it was built--a place for trade, of course, with railroads and ships and so on, but mostly to give all of us a magnitude of defiance that is not provided by one house on the plains. And the plains is where those storms come from." -- E.L. Doctorow


Never apply a Star Trek solution to a Babylon 5 problem.


I am not merely a "consumer" or a "taxpayer". I am a Citizen of the United States.


[link|mailto:bconnors@ev1.net|contact me]
New just glossing over it...
...I can't replicate the problem. Doesn't mean that there's not a problem. I generally don't use QA's or Enterprise Manager's of stored procs, as I keep the scripts external. I think it makes for easier source control. As a result, I've never used QA's object browser for the purpose.

The best way to tell if there's a cache issue is to dig into the tables and pull out the source from the underlying sys tables (that's how the QA and EM reconstruct the stored proc source code - at least that's how they're supposed to). Note, that the source for the stored proc is just a note in one of the tables, which is different than the compiled stored procedure itself.

Short of the possibility that you may be looking at a different database or server in QA than the one you are compiling, I couldn't explain the behavior. It's possible that QA has it's own cache for speed purposes, and that cache may be out of sync. But I would've that the MS would do a real time poll. But then that is assigning rational behavior based on the possible tradeoff of things slowing down.
     SQL Server's Query Analyzer not refreshing SPs - (lincoln) - (14)
         How are you retrieving the stored proc in Query Analyzer? - (ChrisR) - (2)
             from the Object Browser panel on the left side - (lincoln) - (1)
                 just glossing over it... - (ChrisR)
         Getting at the source - (ChrisR) - (4)
             the source shows the latest changes - (lincoln) - (1)
                 Occam's Razor and whatnot - (ChrisR)
             Izzat better than sp_helptext? -NT - (mmoffitt) - (1)
                 Same difference - (ChrisR)
         Problem no longer appearing - (lincoln) - (5)
             Its the magic of Microsoft -NT - (JayMehaffey) - (4)
                 s/magic/black-spaghetti-code-magic/ -NT - (folkert) - (3)
                     Also known as "non-deterministic" behavior. -NT - (a6l6e6x) - (2)
                         I was joking. You sound serious! - (folkert) - (1)
                             It's a "hot button" for me. :) -NT - (a6l6e6x)

The following is a paid announcement.
145 ms