User sporadically unable to update stored procedure

[alistairpaul]

Any ideas why a user might all-of-a-sudden not be able to save a stored procedure?

He's been able to do it all day, no permissions have changed, and now he reports that it appears to be saving, but when he goes to view it, it's actually not changed.

Any ideas?

Thanks! If my post was helpful, please Mark it below. Thanks! - Al

 

[tlbroadbent]

Just to make sure I am clear on this. Does the user actually update and save the stored procedure or is he executing a stored procedure to save data? Terry

http://members.home.net/tlbroadbent/index.htm

 

[Andel]

probably have to refresh.

execute SP_HELPTEXT yourStoredProc

and see if if did really change.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com